3 ms·
You clearly can use it but is there a good reason to use SQLite when you could use Postgres? I've just looked and it seems that Foreign Key constraints can now
by josephlord 12y ago
You clearly can use it but is there a good reason to use SQLite when you could use Postgres? I've just looked and it seems that Foreign Key constraints can now be enforced but I don't think that the type checking is as strong and there aren't the JSON capabilities.
SQLite is great and the obvious choice for structured data embedded in an application or on an embedded platform.
- Renaud 12y agoAs you pointed out, really not the same use case. Firefox and Chrome use SQLite. Imagine if you had to download and install PostgreSQL just to browse the Internet. SQLite is not meant to be a multi-user shared database. It's never going to replace a database server if that's what you need. The reverse of your question is: is there a good reason to use PostgreSQL when you can use SQLite?
- josephlord 12y agoYes but this article is about web services where you clearly can use SQLite but I wanted to understand if there were good reasons to give up Postgres' advantages to do so.