5 ms·
It has taken over already. Sqlite is the most popular database for some time already.
by datadeft 2y ago
It has taken over already. Sqlite is the most popular database for some time already.
- doctor_eval 2y agoIsn’t that a bit like saying that the iPhone is the most popular computer? To stretch the analogy: if you need a database server, neither SQLite nor the iPhone are a good fit.
- datadeft 2y agoI think Sqlite is an option in many cases when people want to use Postgres. I believe there is more overlap between Sqlite and Postgres than iPhone and a general computer.
- doctor_eval 2y agoSQLite is pretty great but I’ve spent my career building multi-user apps, and this is a category for which SQLite is simply a bad fit - as they point out themselves at https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html While there is significant overlap in the basic DML operations due to them both being SQL based, getting SQLite working for my use cases would be like using an iPhone to serve my app over the internet: a whole lot of work, and many compromises, for no good reason.