Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #197123

Re: sqlite database

Show all headers | View raw

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

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

sqlite database Cousin Stanley <cousinstanley@gmail.com> - 2018-07-01 19:20 +0200
  Re: sqlite database deloptes <deloptes@gmail.com> - 2018-07-01 22:30 +0200
    Re: sqlite database <tomas@tuxteam.de> - 2018-07-01 22:40 +0200
    Re: sqlite database Joe <joe@jretrading.com> - 2018-07-01 22:40 +0200
      Re: sqlite database David Wright <deblis@lionunicorn.co.uk> - 2018-07-02 01:10 +0200
        Re: sqlite database Joe <joe@jretrading.com> - 2018-07-02 11:30 +0200
          Re: sqlite database David Wright <deblis@lionunicorn.co.uk> - 2018-07-02 19:10 +0200
            Re: sqlite database Joe <joe@jretrading.com> - 2018-07-02 19:50 +0200
              Re: sqlite database David Wright <deblis@lionunicorn.co.uk> - 2018-07-02 21:10 +0200
            Re: sqlite database deloptes <deloptes@gmail.com> - 2018-07-02 20:00 +0200
              Re: sqlite database David Wright <deblis@lionunicorn.co.uk> - 2018-07-02 21:10 +0200
                Re: sqlite database Greg Wooledge <wooledg@eeg.ccf.org> - 2018-07-02 21:30 +0200
                Re: sqlite database Joe <joe@jretrading.com> - 2018-07-02 21:50 +0200
                Re: sqlite database David Wright <deblis@lionunicorn.co.uk> - 2018-07-03 18:20 +0200

csiph-web