Use embedded database #71
Description
During a recent discussion I've had with @jerkerdelsing about databases, it seems as if the idea is that all Arrowhead systems should use embedded databases, or at least start up and manage their own database processes. Ideally, the user of an Arrowhead system should have to do no database configuration or setup at all.
While leaving it open for database clustering is standard practice in the context of the Internet, @jerkerdelsing claims that it will rarely be directly relevant in the context of Arrowhead. In situation where would be relevant, my impression is that it should be facilitated by the way in which the Arrowhead systems themselves are connected, and not how their databases are.
Perhaps it would be apt to switch from MySQL/MariaDB to SQLite? If you don't mind using non-relational databases, I have good experience with LMDB, which is a key/value store relying on B+-trees. If you @ng201 @tsvetlin have doubts or questions about this, please have a discussion with @jerkerdelsing and everyone else with stake in MySQL/MariaDB/PostgreSQL being supported.