Re: sqlite database
- Date: Mon, 2 Jul 2018 18:45:31 +0100
- From: Joe <joe@xxxxxxxxxxxxxx>
- Subject: Re: sqlite database
On Mon, 2 Jul 2018 12:05:25 -0500
David Wright <deblis@xxxxxxxxxxxxxxxxx> wrote:
> On Mon 02 Jul 2018 at 10:20:00 (+0100), Joe wrote:
> > 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.
> Well, it's always difficult to know what the OP¹ is really after. The
> ?first time this came up (17 months ago), "minimal" was in the subject
> line, sqlite was looked at favourably, but the fact that it had a web
> interface was seen as a downer, perhaps because the word "web"
> appeared to contradict "no networking".
There is a program called sqlitebrowser, which does not obviously use a
web interface. Difficult to say, as I wanted to use it recently but it
is currently uninstallable on [my] sid. I believe I've used it in the
distant past. I had a data issue with Calibre, which used sqlite then
and probably still does.
I understood the recent web reference to be concerning mariadb, and
hence phpmyadmin or adminer. But both sqlite and mariadb/MySQL can be
driven by command, and no seasoned database admin (I'm not) would dream
of using anything as wimpy as a GUI DB manager. Hand-hacked perl would
be more likely...
> Whether a client-server model is now required depends on how one
> interprets https://lists.debian.org/debian-user/2018/06/msg00757.html
> "The [HOWTOs] I find are written assuming things that are never
> identified or use some distro specific hack. Many presume a
> WEB-SERVER is involved. I understand that MySQL's definition of
> server is somehow different."
> Again, that word "web" seems to be perceived as a problem. Now I would
> hate to prejudge the OP¹'s desires in terms of *learning*, but using
> their own expressed situation as a guide (the courses):
> . no networking,
> . single user (so likely no simultaneous writes),
> . no evidence of big (TB) data,
> most software selectors would choose sqlite as more appropriate than
> a client-server database system (the horses).
> > > 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.
> It did occur to me while writing this that the OP¹ has asked here
> about PDAs running Debian for data collection, and about transferring
> files between devices by using their USB ports. If the use case is the
> accumulation of said data, I don't see any pressing need for a
> client-server model, do you?
> ¹ OP of the thread I referred to.
No, but he has frequently expressed a desire for education, and his
recent correspondence was explicitly about mariadb.