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-----
Reply to: