3 ms·

Is there something about sqlite that postgres can't come in to replace it completely (a kind of dynamic postgres that starts up and shuts down like sqlite). Wit

• dnr 13y ago
  SQLite isn't a replacement for postgresql (or vice versa). SQLite is a replacement for fopen. Among its many advantages in that situation: a database is contained in a single file with minimal overhead, the source is shipped as one .c file and encouraged to be statically linked, and the code size is relatively small (compared to something like postgresql).
  • mamcx 13y ago
    I hope sqlite someday add functions and/or store procedures. Plus better error messages (like when a foreign key is violated)
    • kevingadd 13y ago
      Why exactly do you need stored procedures in sqlite? You can just write code. Are you using it in a scenario where you can't write code to interact with sqlite?
      • mamcx 13y ago
        For the same reason are used in others DBs. Some things are better expressed in the DB native language. Help to abstract and share implementation of DBs that are used by different languages.
• bitserf 13y ago
  Why would you want to use PostgreSQL in the contexts that SQLite is used? SQLite is fantastic when you need a data store for mobile or embedded use, you'd like ad-hoc queries over your data with the option of adding indexes to speed up frequently used ones, you want transactional update to the data, and multi-user access is not a problem. It's basically a much better replacement for the hash table on a disk approach of DBM libraries. PostgreSQL would just be total overkill for this kind of scenario.
  • nraynaud 13y ago
    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.
    • jeffasinger 13y ago
      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
    • dragonwriter 13y ago
      > 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.
• hannibal5 13y ago
  SQLite is database for clients and relatively small application specific databases. Postgres is database for servers. Your Firefox browser and Skype client come with SQLite.
• hrjet 13y ago
  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.
  • jeltz 13y ago
    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.