Ok this is how I got the fts working in python and .net...
In python 2.5 sqlite3 is automatically included as a builtin. However I
could not find any method which loads the extention or to enable it,
I COULD do it in SQL by using:
conn.cursor().execute("SELECT load_extension('fts2')")
however this will give an not authorized sql error, so you MUST call
enable_load_extension however this is not available in python, so I
recompiled the SQLite3.dll with directive SQLITE_ENABLE_LOAD_EXTENSION=1
set.
Notice I had to set this to =1 because this directive is still an older
#ifdef instead of if defined, which would work with just
SQLITE_ENABLE_LOAD_EXTENSION.
Now this is enabled by default and the above can work in python or .net
or anything im guessing whether it has the loadextension or not, as long
as FTS2.dll is present.
I obviously understand that for SQLite to enable this by default is a
security issue, which could allow attackers to load malicious dll's,
maybe it would be nice, if the authors could do the following:
Maybe provide a precompiled dll with extension enabled, OR with FTS1,
and 2 compiled in,
What I tried that would be nice is to compile FTS2 and 1 in the dll so
it just works by default without having to loadext or anything,
By enabling: SQLITE_ENABLE_FTS1 and SQLITE_ENABLE_FTS2
But I could NOT get this to work in M$ Visual Studio , I was getting
weird memory corruption in my DLL when I used maybe because Im a c noob?
Could be, I did not do something I was supposed to.
Just thought others trying to do the same thing might find this helpful,
or provide feedback.
