News for hackers. Stuff that matters.
Re:SQLite 3.8.0 Release with next-generation query planner by nraynaud on Monday August 26, 2013 @09:49PM (#6280978)
I just would like the simplicity of use of sqlite on my server. No socket, no connection, no driver that has to match the server, no config file in /etc, no user in /etc/passwd, no cruft.
Re:SQLite 3.8.0 Release with next-generation query planner by jeffasinger on Monday August 26, 2013 @10:48PM (#6281182)
The separation between the client and server that brings all the 'cruft' makes it a lot simpler to have high performance concurrent operations, a major advantage of a full DBMS over SQLite
Re:SQLite 3.8.0 Release with next-generation query planner by dragonwriter on Tuesday August 27, 2013 @02:21PM (#6285188)
> I just would like the simplicity of use of sqlite on my server.

The simplicity comes from largely from not supporting multiple user accounts (authn/authz are left to the owning application), and secondarily (I think) from not being designed to support large numbers of connected processes. If your server need fits that profile, then you can use SQLite and benefit from its simplicity. But if -- as is often the case -- it doesn't, you can't, and its not because no one has merged SQLite with PostgreSQL, its because there is inherent complexity that comes with serving certain use cases.