Re: Xapian database to complement UDD
On Sat, Nov 08, 2008 at 03:57:14PM +0100, Sandro Tosi wrote: > I know nothing about xapian (neither of postgresql) so sorry if my > information are wrong, but reading [1] I noticed that tsearch2[2] was > integrated into psql v8.3[3], so that we can do full text search > directly from the database[4], since UDD is running on a "PostgreSQL > 8.3.1" server. Yes, but we don't want to duplicate work. UDD currently does not inject stuff like full bug logs or package descriptions, while Enrico as worked on that stuff already and has already a working full text search infrastructure. We really don't want to duplicate/re-implement that elsewhere. Cheers. -- Stefano Zacchiroli -*- PhD in Computer Science \ PostDoc @ Univ. Paris 7 [EMAIL PROTECTED],pps.jussieu.fr,debian.org} -<>- http://upsilon.cc/zack/ Dietro un grande uomo c'è sempre /oo\ All one has to do is hit the right uno zaino-- A.Bergonzoni \__/ keys at the right time -- J.S.Bach signature.asc Description: Digital signature
Re: Xapian database to complement UDD
Hi all! On Fri, Nov 7, 2008 at 12:56, Enrico Zini <[EMAIL PROTECTED]> wrote: > for debtags.debian.net/search I'm using a Xapian database as a backend. I > could not use UDD because I take advantage of several feature that are unique > to a full text index rather than a relational database. I know nothing about xapian (neither of postgresql) so sorry if my information are wrong, but reading [1] I noticed that tsearch2[2] was integrated into psql v8.3[3], so that we can do full text search directly from the database[4], since UDD is running on a "PostgreSQL 8.3.1" server. Hope this help, Sandro [1] http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL [2] http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ [3] http://www.postgresql.org/about/press/features83.html [4] http://www.postgresql.org/docs/8.3/static/textsearch-intro.html -- Sandro Tosi (aka morph, Morpheus, matrixhasu) My website: http://matrixhasu.altervista.org/ Me at Debian: http://wiki.debian.org/SandroTosi -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Xapian database to complement UDD
On Fri, Nov 07, 2008 at 11:56:37AM +, Enrico Zini wrote: > So I was thinking: how if I set up the machinery to generate and > maintain a Xapian database, alongside UDD, with information about > Debian packages, that is accessible by the same machines that UDD is > accessible from? That would allow to write applications that take > advantage of both. Thanks for the nice idea. But still, I'm dreaming of a bit more of an integration. One of the nice things of UDD is its consistent and relatively well-known interface: SQL queries. Would it be possible, by the means of some Postgres extension written in $PROG_LANG, to query a local Xapian database *from SQL*? There are many full text searches implementations for Postgres, I'm wondering whether we can use an external one based on Xapian. I leave the answer to our beloved Postgres gurus :-) /me just to throwing another idea in the bag. Cheers. -- Stefano Zacchiroli -*- PhD in Computer Science \ PostDoc @ Univ. Paris 7 [EMAIL PROTECTED],pps.jussieu.fr,debian.org} -<>- http://upsilon.cc/zack/ Dietro un grande uomo c'è sempre /oo\ All one has to do is hit the right uno zaino-- A.Bergonzoni \__/ keys at the right time -- J.S.Bach signature.asc Description: Digital signature