Python 2.5 + sqlite full text search possible?

[Guillermo]

Hi!

Is it possible to load the full-text search module for the SQLite
version bundled with Python 2.5?

I've tested it and the stand-alone SQLite distribution doesn't seem to
include it (sqlite> .load fts2), nor does Python.

I'm on Windows XP.

Regards,

Guillermo

 

[Gerhard Häring]

Hi!

Is it possible to load the full-text search module for the SQLite
version bundled with Python 2.5? [...]
I'm on Windows XP.

Yes, it's possible. But not easily.

You have to replace the sqlite3.dll that comes with Python 2.5 with one
that includes fulltext search. If you can't or don't want to build it
yourself, you could perhaps kindly ask on the SQLite mailing list.

The DLL has to include fulltext search already, because only the very
latest release of pysqlite wraps the method to enable loading of SQLite
extensions. But still then, you'd need to have a custom built fts2.dll
to load it into SQLite.

-- Gerhard