-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sun, Jul 01, 2018 at 10:21:11PM +0200, deloptes wrote: > Cousin Stanley wrote: > > > As an alternative to client-server database managers, > > such as mysql, mariadb, postgresql, etc. , > > the sqlite embedded database manager is very useful .... > > Not sure what thread you write to, but can you do concurrent reads/writes to > sqlite3 DB? > > I think it is not possible as the process that writes, locks the file, so > just keep in mind that there are severe limitations in the use of sqlite3 > databases. Correct me if I am wrong
Yes, SQLite can do concurrent. Of course, some locking/WAL scheme is used (modern SQLite can do both). There are some limitations, and for databases with many clients and things running over the network, classical client/ server DBs may have an edge: https://sqlite.org/lockingv3.html https://sqlite.org/wal.html SQLite is an awesome piece of software, arguably the one with the most complete test suite (excepting perhaps some specialized domains). Cheers - -- t -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAls5O7cACgkQBcgs9XrR2kZlSgCeP6SmpDSLDeIHOGPLCPnS/ufM CMYAnA0jJog5vLsuuDfJmi3z+wDiZpGg =IzaS -----END PGP SIGNATURE-----