mORMot Open Source

esmondb

Member

From: London

Registered: 2010-07-20

Posts: 299

SQLite respect

Does anyone have an opinion on when not to use SQLite instead something like of Postgres? I guess it's when there's a large amount of users or data. My question was triggered by this article:

https://fly.io/blog/all-in-on-sqlite-litestream

Last edited by esmondb (2022-05-10 08:32:39)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: SQLite respect

Such a question is more about proper architecture, than databases.
For instance, SQlite3 is just perfect for a MicroService embedded storage.
And in a MicroService, the side of data tends to be not so large, by definition. You have several databases, one per MicroService, so you shard/distribute your data.

And you can replicate directly with mORMot - no need of LiteStream fork and GoLang - using its master/slave replication feature.
What I also did is to use MongoDB as replicated NoSQL database to store the data in several nodes, for reporting or auditing.

For a data-centric approach, Postgres and SQlite are good choices.
But of course, Postgres has more features, and if you need accounting-level and business-aware support, then it is the way to go.