Hello all,
Is there any way to connect postgres with Xapian?
So that data can be indexed and searched with the help of Xapian but to/from
Postgres.
So, it would be great to integrate it with application which is database
centric.
Waiting for reply.
Thank you
Regards
--
(((())))
(@ @)
(_)
+----oOO------------Ooo----------+
| Gupteshwar D Joshi |
| |
+------------------------------------+
|___|___|
| | | |
ooO Ooo
On Tue, Feb 20, 2007 at 06:28:47PM +0530, Gupteshwar Joshi wrote:> Is there any way to connect postgres with Xapian? > So that data can be indexed and searched with the help of Xapian but to/from > Postgres. > So, it would be great to integrate it with application which is database > centric.It's possible to do, but I'm not aware of anyone actually having done it. There's been some past discussion - for example, here: http://thread.gmane.org/gmane.comp.search.xapian.general/230 Currently, the easy route is to have the Xapian application "pull" changes from the Postgres database (by using a suitable SQL query, or by dumping the table periodically if changes are frequent and extensive). But that's not as flexible as what you're talking about. It certainly would be nice to see some sort of "connector" which allowed the SQL database to "push" changes to Xapian. Cheers, Olly
On Tue, Feb 20, 2007 at 06:28:47PM +0530, Gupteshwar Joshi wrote:> Hello all, > Is there any way to connect postgres with Xapian? > So that data can be indexed and searched with the help of Xapian but to/from > Postgres. > So, it would be great to integrate it with application which is database > centric.Take a look at http://pgestraier.projects.postgresql.org/ While it isn't support for Xapian, I think that pgestraier might help to get you stared. I might try to offer some help (time permiting) because I would love to see Xapian support for PostgreSQL. Another posibility would be to use one of embeded languages in PostgreSQL, but I did try to use perl back in early 8.0-beta days, and got stuck with numerous problems, so I wrote functions in C. Things might be easier now. -- Dobrica Pavlinusic 2share!2flame dpavlin@rot13.org Unix addict. Internet consultant. http://www.rot13.org/~dpavlin