News for hackers. Stuff that matters.
Re:SQLite 3.8.0 Release with next-generation query planner by hrjet on Tuesday August 27, 2013 @02:11AM (#6281763)
This is a brilliant idea.

If postgresql could have a single file, embedded mode, then it could replace sqlite.

The advantages of such a design would be: 1. All the optimisations and transaction guarantees of a full-featured DB 2. All the conveniences of a single file DB 3. Better utilisation of open-source resources as the OP points out.

On the other hand, the postgresql system might be bigger (in terms of code size and heap usage) than sqlite. So it may not be feasible to use in all embedded applications.

Re:SQLite 3.8.0 Release with next-generation query planner by jeltz on Tuesday August 27, 2013 @08:32PM (#6287272)
I think embeddable mode is more realistic than single file since the single user mode used by for example pg_upgrade is quite close to that. Some features are missing though for wide use.