[pysqlite] Unable to get apsw-3.6.6.2-r1 and fts3 working

"Reza Lotun" <rlotun-/[email protected]> Tue, 16 Dec 2008 13:05:17 +0000
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
Hi All,

If anyone could help me that would be wonderful - I can't seem to get
apsw-3.6.6.2-r1 and full text search working. I did this:

- downloaded http://apsw.googlecode.com/files/apsw-3.6.6.2-r1.zip and
extracted
- did a:
         sudo python setup.py --enable=fts --fetch-sqlite install
Everything seems to work fine.
- in python i can do an 'import apsw' and 'apsw.apswversion()' returns
'3.6.6.2-r1'
- likewise: apsw.sqlitelibversion() == '3.6.6.2'
- apsw.__file__ == '/Library/Python/2.5/site-packages/apsw.so'
- apsw.SQLITE_VERSION_NUMBER == 3006006

However, when I do:

: conn = apsw.Connection('test_db')
: cur = conn.cursor()
: cur.execute('create virtual table t using fts3')

I get 'SQLError: SQLError: no such module: fts3'

I am using Mac OS X 10.5.5 and Python 2.5.1 (the stock python that comes
with it).

Does anyone have an idea of what's going wrong?

Thanks,
Reza

-- 
Reza Lotun
Senior Software Engineer
Peer Technologies Limited
reza-/[email protected]

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite