Re: Using a command-line program (sqlite3) as a backend

[florian]

On Mar 25, 2:03 am, Glenn Morris <rgm+n...@stanford.edu> wrote:

> You don't say anything about having looked at sql.el, distributed with
> Emacs for 10 years.

That's true, I didn't mention that. I did have a look, but my
impression was that this is mainly concerned with editing SQL, and
invoking one of several databases to test (or evaluate) the SQL
statements written. This is definitely a useful thing, and might prove
handy later on, but is not quite what I want to do right now. I want
to use an SQLite database in a rather hidden (or let's call it "user-
friendly") way, i.e. write functions that do e.g. queries, but take
care of the SQL themselves.

Nevertheless, I tested the (sql-sqlite ..) function, and it does not
seem like a function that has actually ever been tested: it asks for a
user name, password, and server, none of which makes sense with SQLite
(or, as I suspect, has ever made sense with it). And it does complain
and die: "sqlite3.exe: unknown option: -user=florian". That leaves me
a little suspicious about whether sql.el can serve as a model, let
alone library,  for what I want to do. But I'm open to be taught
otherwise, of course ...

Best regards,
Florian