actually, the latest situation is
debian:~/pysqlite-2.5.0/doc# python
>>> from pysqlite2 import dbapi2 as sqlite3
>>> con = sqlite3.connect(":memory:")
>>> con.execute("CREATE VIRTUAL TABLE posts using FTS3(title, body);")
Traceback (most recent call last):
File "", line 1, in
pysqlite2.dbapi2.OperationalError: no such module: FTS3
-- Forwarded message --
From: hawk gao <[EMAIL PROTECTED]>
Date: 2008/10/30
Subject: Re: how to get full-text search of pysqlite3 work in python2.5.2
To: Guilherme Polo <[EMAIL PROTECTED]>
I build and install a 3.6.4 by following this guide
http://www.sqlite.org/cvstrac/wiki?p=CompilingFts
eventually, i can run "CREATE VIRTUAL TABLE posts using FTS3(title, body);"
under sqlite3 command line.
debian:~/pysqlite-2.5.0# sqlite3
SQLite version 3.6.4
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE VIRTUAL TABLE posts using FTS3(title, body);
sqlite>
then i rebuild and reinstall pysqlite2.5.0. but, even "from pysqlite2
import dbapi2 as sqlite3" cannot be accepted.
debian:~/pysqlite-2.5.0# python
Python 2.5 (release25-maint, Jul 20 2008, 20:47:25)
[GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from pysqlite2 import dbapi2 as sqlite3
Traceback (most recent call last):
File "", line 1, in
File "pysqlite2/dbapi2.py", line 27, in
from pysqlite2._sqlite import *
ImportError: No module named _sqlite
2008/10/30 Guilherme Polo <[EMAIL PROTECTED]>
> On 10/30/08, hawk gao <[EMAIL PROTECTED]> wrote:
>
> > Thanks for your advice. but the problem still here.
> >
> > debian:~/sqlite-3.6.4-build# python
> > Python 2.5 (release25-maint, Jul 20 2008, 20:47:25)
> > [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)] on linux2
> > Type "help", "copyright", "credits" or "license" for more information.
> > >>> from pysqlite2 import dbapi2 as sqlite3
> > >>> con = sqlite3.connect(":memory:")
> > >>> con.execute("CREATE VIRTUAL TABLE posts using FTS3(title, body);")
> > Traceback (most recent call last):
> >File "", line 1, in
> > pysqlite2.dbapi2.OperationalError: no such module: FTS3
> >
>
> Yes... you have to compile pysqlite against the sqlite library that
> has the builtin support fot fts3. pysqlite is probably being compiled
> against the sqlite found in /usr/lib, while the sqlite with fts3
> support is at /usr/local/lib.
>
> --
> -- Guilherme H. Polo Goncalves
>
--
http://mail.python.org/mailman/listinfo/python-list
