[odb-users] SQLite Concurrency

[Simon Riggs]

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