SQLite extension loading is not supported and should be

[MAcks]

Binary package hint: python-apsw

Description: Ubuntu 8.10
Release: 8.10

python-apsw:
  Installed: 3.3.13-r1-3
  Candidate: 3.3.13-r1-3
  Version table:
 *** 3.3.13-r1-3 0
        500 http://pl.archive.ubuntu.com intrepid/universe Packages
        100 /var/lib/dpkg/status

As Ubuntu build of sqlite supports loading of extensions, this line should be commented-out in APSW's setup.py to enable extension loading from python:
define_macros.append( ('SQLITE_OMIT_LOAD_EXTENSION', 1) )

[Roger Binns (ubuntu-rogerbinns)]

(Disclosure: I am the author of apsw).

Jaunty includes APSW 3.5.9-r2 where that line is commented out as I distribute it that way, so a simple upgrade to Jaunty will solve your immediate problem.

You can also build APSW yourself. It is really easy and can even download the latest SQLite for you! See http://apsw.googlecode.com/svn/publish/build.html - in summary 'python setup.py --fetch-sqlite build' will make the extension which you can then copy to whatever directory is most useful for you.

I have also been meaning to get around to setting up a PPA that contains the lastest APSW with the latest SQLite ...

[Roger Binns (ubuntu-rogerbinns)]

The PPA now exists: https://launchpad.net/~ubuntu-rogerbinns/+archive/apsw
It doesn't include an Intrepid build since the packaging tools are too old.

Since it appears that nobody at Ubuntu has any intention of making the one line change to fix the LTS package in the 1 1/2 years since it was reported, and that several workarounds exist, I suggest closing it.