Web lists-archives.com

Re: sqlite database




-----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-----