I like #sqlite and works pretty much good with #strapi and #directus
seems to me still better choice than use "cloud db" but I need more instances into 1file - so I searched and found this article https://sqlite.org/forum/info/339d237d6517783a which refers to you
I what I read is pretty great https://bedrockdb.com very good builded project 😃👏
Q) so it is process service above #sqlite connected through port for sync ?
Q) it that communications encrypted somehow ?
Q) how colisions are handeled ?
For MySQL or PostgreSQL, if you sometime get a lot of data, it may happen that you would need to migrate to SQLite to keep costs manageable:
Many small queries are efficient in SQLite:
Using SQLite is 35% faster than using filesystem:
For GDPR encrypted stuff, there is Databunker:
If MySQL is not your preferred option, you could also look is MySQL compatible Noria any better:
nc localhost 8888
Query: SELECT 1 AS foo, 2 AS bar;
foo | bar
1 | 2