From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Florian Weimer Newsgroups: gmane.emacs.devel Subject: Re: SQLite interface Date: Sat, 15 Mar 2014 16:00:52 +0100 Message-ID: <8761nfo6aj.fsf@mid.deneb.enyo.de> References: <87zjku76nk.fsf@mid.deneb.enyo.de> <87y50e6mck.fsf@lifelogs.com> <87pplp263o.fsf@mid.deneb.enyo.de> <1B24FFF2-0973-4814-94EF-041B63E94B7B@raeburn.org> NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: ger.gmane.org 1394895663 22324 80.91.229.3 (15 Mar 2014 15:01:03 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Sat, 15 Mar 2014 15:01:03 +0000 (UTC) Cc: emacs-devel@gnu.org To: Kenneth Raeburn Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Sat Mar 15 16:01:11 2014 Return-path: Envelope-to: ged-emacs-devel@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1WOq5H-0005aC-33 for ged-emacs-devel@m.gmane.org; Sat, 15 Mar 2014 16:01:11 +0100 Original-Received: from localhost ([::1]:50274 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WOq5G-0001eH-Ml for ged-emacs-devel@m.gmane.org; Sat, 15 Mar 2014 11:01:10 -0400 Original-Received: from eggs.gnu.org ([2001:4830:134:3::10]:41930) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WOq58-0001ZY-2f for emacs-devel@gnu.org; Sat, 15 Mar 2014 11:01:08 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WOq52-0005o5-3E for emacs-devel@gnu.org; Sat, 15 Mar 2014 11:01:02 -0400 Original-Received: from ka.mail.enyo.de ([87.106.162.201]:34736) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WOq51-0005ng-Sd for emacs-devel@gnu.org; Sat, 15 Mar 2014 11:00:56 -0400 Original-Received: from [172.17.135.4] (helo=deneb.enyo.de) by ka.mail.enyo.de with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) id 1WOq4y-00008i-QF; Sat, 15 Mar 2014 16:00:52 +0100 Original-Received: from fw by deneb.enyo.de with local (Exim 4.80) (envelope-from ) id 1WOq4y-0007VP-Kq; Sat, 15 Mar 2014 16:00:52 +0100 In-Reply-To: <1B24FFF2-0973-4814-94EF-041B63E94B7B@raeburn.org> (Kenneth Raeburn's message of "Sat, 15 Mar 2014 02:53:04 -0400") X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 87.106.162.201 X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Original-Sender: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.devel:170394 Archived-At: * 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? It would require parsing the queries and rewriting them. I don't know yet how horrid the Emacs C internals are, but I'm pretty sure it cannot be that bad, and it's easier to write something in C now (and throw it away once the FFI arrives) than to implement two sides of an IPC mechanism and all the query and result set massaging.