Re: [Cppcms-users] Threaded access to SQLite

[Artyom B. <art...@gm...>]

In general sqlite3 behaves poorly with multiple threads and you should
make yourself ready to deal with the issue - simultanious updates and
even query + update may fail.

Artyom

On Fri, Jan 6, 2017 at 8:54 PM, Josh Hunsaker <jos...@ni...> wrote:
> Is connection pooling expected to work for the SQLite backend?  When I
> spawn three threads and try to connect to the database from each, one
> of the connections will succeed and the other two will fail.  On the
> two that fail, I get an error saying "database is locked."  This
> happens whether I am using the connection pool directly (via
> cppdb::pool) or indirectly (via @pool_size).
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Cppcms-users mailing list
> Cpp...@li...
> https://lists.sourceforge.net/lists/listinfo/cppcms-users