Installing PySQLite on OS X 10.4

[Rob Cowie]

Gerhard Häring wrote:
> Rob Cowie wrote:
> > [...]
> > However, if I do "from pysqlite2 import test" as suggested after
> > installation, I get the following traceback...
> >
> > Traceback (most recent call last):
> >   File "<stdin>", line 1, in ?
> >   File "pysqlite2/test/__init__.py", line 25, in ?
> >     from pysqlite2.test import dbapi, types, userfunctions, factory,
> > transactions
> >   File "pysqlite2/test/dbapi.py", line 26, in ?
> >     import pysqlite2.dbapi2 as sqlite
> >   File "pysqlite2/dbapi2.py", line 32, in ?
> >     from pysqlite2._sqlite import *
> > ImportError: No module named _sqlite
> > [...]
>
> Apparently, you're doing this from the pysqlite sources root directory.
> So the pysqlite2 directory is tried, which does ont include the compiled
> C extension module. Execuring from any other working directory on your
> system should work fine.
>
> I'll have to check that this is all properly documented before I do the
> next pysqlite release.
>
> -- Gerhard

Thanks.... however, now when I try "from pysqlite2 import test" it
results in:

Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File
"build/bdist.darwin-8.5.0-Power_Macintosh/egg/pysqlite2/test/__init__.py",
line 25, in ?
  File
"build/bdist.darwin-8.5.0-Power_Macintosh/egg/pysqlite2/test/dbapi.py",
line 26, in ?
  File
"build/bdist.darwin-8.5.0-Power_Macintosh/egg/pysqlite2/dbapi2.py",
line 32, in ?
  File
"build/bdist.darwin-8.5.0-Power_Macintosh/egg/pysqlite2/_sqlite.py",
line 7, in ?
  File
"build/bdist.darwin-8.5.0-Power_Macintosh/egg/pysqlite2/_sqlite.py",
line 6, in __bootstrap__
ImportError:
dlopen(/Users/rob/.python-eggs/pysqlite-2.1.3-py2.3-macosx-10.4-ppc.egg-tmp/pysqlite2/_sqlite.so,
2): Symbol not found: _sqlite3_transfer_bindings
  Referenced from:
/Users/rob/.python-eggs/pysqlite-2.1.3-py2.3-macosx-10.4-ppc.egg-tmp/pysqlite2/_sqlite.so
  Expected in: dynamic lookup

I now suspect that this may all be down to the version of sqlite3
installed as part of OS X 10.4. Some people report success when using
this version with pysqlite, others report failure.