Re: SQLite interface

[Ted Zlatanov]

On Sat, 15 Mar 2014 16:00:52 +0100 Florian Weimer <address@hidden> wrote: 

FW> * Kenneth Raeburn:
>> I suppose using SELECT QUOTE(CAST (column AS BLOB)) ... and INSERT
>> ... CAST(X'010203' AS TEXT), passing values as hexadecimal, would be
>> horribly intrusive when writing the queries and processing the
>> results, but is there more than that needed to use the command line
>> client?

FW> It would require parsing the queries and rewriting them.

FW> I don't know yet how horrid the Emacs C internals are, but I'm pretty
FW> sure it cannot be that bad, and it's easier to write something in C
FW> now (and throw it away once the FFI arrives) than to implement two
FW> sides of an IPC mechanism and all the query and result set massaging.

Yup.  Having done exactly this sort of query rewriting for an old
database, I agree it's not worth the pain.

Ted