Re: sqlite database
On Sun 01 Jul 2018 at 21:36:00 (+0100), Joe wrote:
> On Sun, 01 Jul 2018 22:21:11 +0200
> deloptes <deloptes@xxxxxxxxx> 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 for anything more demanding. Horses for courses, as ever.
… but I'm not sure whether we were given the use case in that thread.