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

Groups > linux.debian.user > #197110

Re: sqlite database

Show all headers | View raw

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.

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.

Cheers,
David.

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