Installing PySQLite on OS X 10.4

[Gerhard Häring]

Rob Cowie wrote:
> [...]
> "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.

Quoting http://initd.org/pub/software/pysqlite/doc/install-source.html

"""
SQLite:
     * SQLite version 3.2.2 or later (as of pysqlite 2.1.0).
"""

You'll need to install a more recent SQLite version than the one shipped 
with OS X 10.4.

Alternatively, you could use pysqlite 2.0.7, which has less cool 
features, but works with your SQLite version. If you plan to stick to 
the DB-API and not use convenience features introduced in pysqlite 2.1 
it doesn't make any difference.

-- Gerhard