[odb-users] SQLite Concurrency

Simon Riggs simon at 2ndquadrant.com
Thu Jan 26 10:38:16 EST 2017

On 26 January 2017 at 15:16, Boris Kolpackov <boris at codesynthesis.com> wrote:
> Hi Simon,
> Simon Riggs <simon at 2ndquadrant.com> writes:
>> That's called "Postgres".
> While I think PostgreSQL is great, in most cases you can't just
> replace (an embedded) database like SQLite with (a client-server)
> like Postgres.

Agreed its not a drop in replacement.

> For example, we use SQLite in bpkg[1], a C++ package manager we are
> developing. Suggesting that users of bpkg install and administer the
> PostgreSQL server would be absurd.
> [1] https://build2.org

I guess for me "embedded" => single-session. SQLite was developed from
Postgres as a specialization for certain use cases. If you need
multi-session then using Postgres is the right choice, even if that is
single user. Postgres is regularly used in unattended installs and has
been for many years. It's a common requirement to do multiple things
at once as well as have active replication and concurrent maintenance
via vacuuming, for example.

Apologies for popping in like this, been reading list for some time now.

Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

More information about the odb-users mailing list