From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Ted Zlatanov Newsgroups: gmane.emacs.devel Subject: Re: SQLite interface Date: Sat, 15 Mar 2014 13:23:37 -0400 Organization: =?utf-8?B?0KLQtdC+0LTQvtGAINCX0LvQsNGC0LDQvdC+0LI=?= @ Cienfuegos Message-ID: <87d2hn74va.fsf@lifelogs.com> References: <87zjku76nk.fsf@mid.deneb.enyo.de> <87y50e6mck.fsf@lifelogs.com> <87pplp263o.fsf@mid.deneb.enyo.de> <1B24FFF2-0973-4814-94EF-041B63E94B7B@raeburn.org> <8761nfo6aj.fsf@mid.deneb.enyo.de> Reply-To: emacs-devel@gnu.org NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain X-Trace: ger.gmane.org 1394904191 14292 80.91.229.3 (15 Mar 2014 17:23:11 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Sat, 15 Mar 2014 17:23:11 +0000 (UTC) To: emacs-devel@gnu.org Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Sat Mar 15 18:23:19 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 1WOsIp-0004rq-Eo for ged-emacs-devel@m.gmane.org; Sat, 15 Mar 2014 18:23:19 +0100 Original-Received: from localhost ([::1]:50695 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WOsIp-00059J-0C for ged-emacs-devel@m.gmane.org; Sat, 15 Mar 2014 13:23:19 -0400 Original-Received: from eggs.gnu.org ([2001:4830:134:3::10]:37123) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WOsIg-00058L-Dx for emacs-devel@gnu.org; Sat, 15 Mar 2014 13:23:16 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WOsIa-0000HF-9k for emacs-devel@gnu.org; Sat, 15 Mar 2014 13:23:10 -0400 Original-Received: from plane.gmane.org ([80.91.229.3]:33788) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WOsIa-0000Gv-3D for emacs-devel@gnu.org; Sat, 15 Mar 2014 13:23:04 -0400 Original-Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1WOsIW-0004cO-4S for emacs-devel@gnu.org; Sat, 15 Mar 2014 18:23:00 +0100 Original-Received: from c-98-229-61-72.hsd1.ma.comcast.net ([98.229.61.72]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 15 Mar 2014 18:23:00 +0100 Original-Received: from tzz by c-98-229-61-72.hsd1.ma.comcast.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 15 Mar 2014 18:23:00 +0100 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: emacs-devel@gnu.org Original-Lines: 20 Original-X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: c-98-229-61-72.hsd1.ma.comcast.net X-Face: bd.DQ~'29fIs`T_%O%C\g%6jW)yi[zuz6; d4V0`@y-~$#3P_Ng{@m+e4o<4P'#(_GJQ%TT= D}[Ep*b!\e,fBZ'j_+#"Ps?s2!4H2-Y"sx" Mail-Copies-To: never User-Agent: Gnus/5.130008 (Ma Gnus v0.8) Emacs/24.3.50 (gnu/linux) Cancel-Lock: sha1:WszRoUreXgp376+0j1r+fVvwGF0= X-detected-operating-system: by eggs.gnu.org: Genre and OS details not recognized. X-Received-From: 80.91.229.3 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:170397 Archived-At: On Sat, 15 Mar 2014 16:00:52 +0100 Florian Weimer 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