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. Al

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.