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: Embedding SQLite Date: Mon, 19 Apr 2010 13:26:52 -0500 Organization: =?utf-8?B?0KLQtdC+0LTQvtGAINCX0LvQsNGC0LDQvdC+0LI=?= @ Cienfuegos Message-ID: <87pr1vl2mr.fsf@lifelogs.com> References: <87sk6tonv8.fsf@mid.deneb.enyo.de> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: dough.gmane.org 1271701701 23332 80.91.229.12 (19 Apr 2010 18:28:21 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Mon, 19 Apr 2010 18:28:21 +0000 (UTC) To: emacs-devel@gnu.org Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Mon Apr 19 20:28:20 2010 connect(): No such file or directory Return-path: Envelope-to: ged-emacs-devel@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1O3vhi-0002NZ-VC for ged-emacs-devel@m.gmane.org; Mon, 19 Apr 2010 20:28:19 +0200 Original-Received: from localhost ([127.0.0.1]:55340 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O3vhi-0000WG-B9 for ged-emacs-devel@m.gmane.org; Mon, 19 Apr 2010 14:28:18 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1O3vgb-0007mS-RA for emacs-devel@gnu.org; Mon, 19 Apr 2010 14:27:09 -0400 Original-Received: from [140.186.70.92] (port=49335 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O3vga-0007kl-AB for emacs-devel@gnu.org; Mon, 19 Apr 2010 14:27:09 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1O3vgZ-0001qb-1d for emacs-devel@gnu.org; Mon, 19 Apr 2010 14:27:08 -0400 Original-Received: from lo.gmane.org ([80.91.229.12]:38035) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1O3vgY-0001qS-7y for emacs-devel@gnu.org; Mon, 19 Apr 2010 14:27:07 -0400 Original-Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1O3vgU-0001cO-7s for emacs-devel@gnu.org; Mon, 19 Apr 2010 20:27:02 +0200 Original-Received: from 38.98.147.130 ([38.98.147.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 19 Apr 2010 20:27:02 +0200 Original-Received: from tzz by 38.98.147.130 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 19 Apr 2010 20:27:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ connect(): No such file or directory Original-Lines: 24 Original-X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: 38.98.147.130 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" User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/24.0.50 (gnu/linux) Cancel-Lock: sha1:FGsfVJlP+xZuCGlQA93JseAy80k= X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.devel:123888 Archived-At: On Sat, 17 Apr 2010 21:55:23 +0200 Florian Weimer wrote: FW> Would an interface to SQLite be acceptable for integration into Emacs? FW> I'm looking into improving the performance of large nnml folders in FW> Gnus, and storing the .overview data in an SQLite database might be an FW> option. FW> SQLite is public domain and could be shipped with GNU Emacs. It is FW> supposed to be quite portable. I am in favor of doing this. In my experience SQLite has been fast and reliable, plus it can be controlled with SQL which is a well-known language. It would be nice if it was possible to serialize/deserialize hashtables and lists directly from a SQLite table. It may seem like "just another library" but I'm tired of the 30 ways in Emacs to serialize data and then load it back (all of them inefficient and incompatible with each other). Gnus, at least, would benefit significantly from this. I wouldn't make it an external dependency, though. Bring it into Emacs itself and update the C source when an update is released. Ted