On Sun, 01 Jul 2018 22:21:11 +0200 deloptes <[email protected]> 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 > And the single file is vulnerable to network issues. Basically the same limitations as MS Access when used as a single-file database. Sqlite is the right answer for most single-user non-network applications, but not for anything more demanding. Horses for courses, as ever. -- Joe
