Re: sqlite database
On Sun, 1 Jul 2018 18:04:15 -0500
David Wright <deblis@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 <deloptes@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
Reply to: