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: Thu, 13 Mar 2014 13:26:51 -0400 Organization: =?utf-8?B?0KLQtdC+0LTQvtGAINCX0LvQsNGC0LDQvdC+0LI=?= @ Cienfuegos Message-ID: <87y50e6mck.fsf@lifelogs.com> References: <87zjku76nk.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 1394731591 25812 80.91.229.3 (13 Mar 2014 17:26:31 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Thu, 13 Mar 2014 17:26:31 +0000 (UTC) To: emacs-devel@gnu.org Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Thu Mar 13 18:26:40 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 1WO9Ov-0004Jn-8e for ged-emacs-devel@m.gmane.org; Thu, 13 Mar 2014 18:26:37 +0100 Original-Received: from localhost ([::1]:40805 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WO9Ou-00089E-PU for ged-emacs-devel@m.gmane.org; Thu, 13 Mar 2014 13:26:36 -0400 Original-Received: from eggs.gnu.org ([2001:4830:134:3::10]:33811) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WO9Ol-0007RC-Qp for emacs-devel@gnu.org; Thu, 13 Mar 2014 13:26:33 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WO9Oc-00018c-Hl for emacs-devel@gnu.org; Thu, 13 Mar 2014 13:26:27 -0400 Original-Received: from plane.gmane.org ([80.91.229.3]:33848) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WO9Oc-00018N-Bs for emacs-devel@gnu.org; Thu, 13 Mar 2014 13:26:18 -0400 Original-Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1WO9OY-0003wj-LV for emacs-devel@gnu.org; Thu, 13 Mar 2014 18:26:14 +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 ; Thu, 13 Mar 2014 18:26:14 +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 ; Thu, 13 Mar 2014 18:26:14 +0100 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: emacs-devel@gnu.org Original-Lines: 19 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:KE7c+xkQjf2Wv4J+/S8m0bdhRFQ= 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:170322 Archived-At: On Thu, 13 Mar 2014 11:08:15 +0100 Florian Weimer wrote: FW> Would a patch that exposes the SQLite C API at the Lisp level be FW> acceptable for inclusion in Emacs, or is this not a good idea because FW> SQLite is public domain software outside of the GNU project? FW> I would like to use SQLite to speed up updating the overview files in FW> the nnml backend for Gnus. I have some folders where these files are FW> several hundred megabytes large, and they are rewritten from scratch FW> each time new mail is received. So far, I've thrown hardware at the FW> problem, but that's becoming less and less cost-effective. Given that any possible FFI interface is after the freeze and probably will take months to get into a released Emacs, can you consider writing this with a shell backend for now and use the C API opportunistically? I don't know the details about SQLite's accessibility, but I believe it can do at least some useful things non-interactively over STDOUT/STDIN. Ted