Persistent Memcached or Redis — is it possible to create a database?

Good day [x2], the question arose - is it possible to write non-relational (well, as understand without the SQL syntax) database?
Effectively, whether it will use database in the server memory?
June 10th 19 at 14:37
2 answers
June 10th 19 at 14:39
Solution
As you said - it depends for what purposes. If you are talking a very large load on the database and you is extremely important the response time from the server and all this data is volatile, it is possible radish to do. If you want to make a database of users, forums and so on, use relational.
Well, in fact, is an analogue of the forum, only really slow to load.
More precisely, the messenger, but do only certain persons - classmates.
Just want to write something that could allow communication between users.
Something like that. What DB would you recommend? - eveline21 commented on June 10th 19 at 14:42
Redis as the message store will not work. Memory is not rubber, and over time it will become clogged. Better to use relationse. I only worked with MySQL, so objectively say what relazioni better - I can't. But on the theoretical knowledge from the forums and other postgreSQL will run faster.
If you are talking about Redis, you want to buy VDS. Then I can advise you to do your project with Node.js+Socket.io+Redis+PostgreSQL.
Noda will be to create a server, it works much faster than php.
Socket.io to create active connections between users, will work much faster to users than doing everything in Ajax requests.
Redis is used for storing the titles of the dialogues(which are created through Socket.io), which is the user. But it is also necessary to configure periodic downloading of data from Redis on the hard drive, as beautiful to the Redis server, the user will lose all the dialogue, and they must be recovered. Crashes Redis as for me it is very rare, if you have not made any errors in addresses, but still better safe than sorry.
Well, PostgreSQL will store the message. - nasir commented on June 10th 19 at 14:45
so the point is something that restart the server daily, and after the restart the database with the chat log will be deleted.
And still will be engine_messages.php that every minute will look for new messages in current chat-log, and bring them into a common database for long-term storage.
As for Node.js - I haven't learned JS( - eveline21 commented on June 10th 19 at 14:48
June 10th 19 at 14:41
Solution
You can write, but get much worse than existing solutions, if ever, happens. DBMS write commands from a very cool man and spend years on this.

Find more questions by tags Databases