On Sun, 1 Jul 2018 18:04:15 -0500 David Wright <deb...@lionunicorn.co.uk> wrote:
> On Sun 01 Jul 2018 at 21:36:00 (+0100), Joe wrote: > > On Sun, 01 Jul 2018 22:21:11 +0200 > > deloptes <delop...@gmail.com> 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, > > … which sounds like a perfect fit for the recent thread on MariaDB. Not if you're trying to learn client-server databases. > > https://lists.debian.org/debian-user/2018/06/msg00757.html > > > but > > not for anything more demanding. Horses for courses, as ever. > > … but I'm not sure whether we were given the use case in that thread. -- Joe