From mboxrd@z Thu Jan 1 00:00:00 1970 From: wmorgan-sup@masanjin.net (William Morgan) Date: Wed, 23 Jul 2008 10:09:35 -0700 Subject: [sup-talk] rethinking sup part ii In-Reply-To: <1216802131-sup-4710@wrasse> References: <1216589569-sup-1520@entry> <1216802131-sup-4710@wrasse> Message-ID: <1216832349-sup-2908@entry> Reformatted excerpts from Richard Heycock's message of 2008-07-23: > My one concern is that you are thinking of using Sphinx and as a > consequence you are relient on a relational database. Is that really > what you want for a mail client? I find this disturbing on two levels: > having a full blown database system for email seems like overkill and > the idea of an index bring based on a relational model quite appaling. I feel exactly the same way. I'm using Sphinx's XML interface to add things to the index, so there's no RDBMS involved. I hate XML but not as much as I hate RDBMS. The current plan is to actually store email/documents in some kind of persistent key-value store. I have a preliminary very simple implementation that just uses files on disk, but it will be possible to swap that out to something like TokyoCabinet or AWS. > There are a number of other indexs such as Xapian or Hyper Estraier > both have ruby bindings and both are quite mature and widely used in > other projects. Interesting. I will check those out. I only picked Sphinx because it seemed popular and robust, but it is currently making my life more difficult than it really needs to be. -- William