Web lists-archives.com

Re: sqlite database




On Sun, 1 Jul 2018 18:04:15 -0500
David Wright <deblis@xxxxxxxxxxxxxxxxx> wrote:

> 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 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