You can download this release as binaries for Windows. Just run the executable corresponding with the Python version you are using. The Windows binaries all include the FTS and RTree extensions. (FTS3_PARENTHESIS is on.)
Some Linux distributions also have packages.
|Ubuntu PPA||I maintain a PPA that is up to date at https://launchpad.net/~ubuntu-rogerbinns/+archive/apsw which has SQLite embedded statically inside (ie system SQLite is ignored) and has all the extensions enabled: FTS3/4, RTree, ICU. Note that builds are not available for Ubuntu 12.10 because Canonical/Ubuntu add a broken flag to the PPA.|
|Arch Linux||Install python-apsw|
Note that these (except my Ubuntu PPA) may trail the SQLite and APSW releases by a year, or more. It is also possible to build RPMs and DEB packages from the source, although this involves setting up package management tools and various dependencies on your build machine.
Downloads are now digitally signed so you can verify they have not been tampered with. Download and extract the zip file of signatures listed above. These instructions are for GNU Privacy Guard. (GPG is installed as standard on most Unix/Linux platforms and can be downloaded for Windows.)
To verify a file just use –verify specifying the corresponding .asc filename. This example verifies the source:$ gpg --verify apsw-3.7.17-r1.zip.asc gpg: Signature made ... date ... using DSA key ID 0DFBD904 gpg: Good signature from "Roger Binns <email@example.com>"
If you get a “good signature” then the file has not been tampered with and you are good to go.
Getting the signing key
You may not have the signing key available in which case the last line will be something like this:gpg: Can't check signature: public key not found
You can get a copy of the key using this command:$ gpg --keyserver hkp://keyserver.ubuntu.com --recv-keys 0DFBD904 gpg: requesting key 0DFBD904 from hkp server keyserver.ubuntu.com gpg: /home/username/.gnupg/trustdb.gpg: trustdb created gpg: key 0DFBD904: public key "Roger Binns <firstname.lastname@example.org>" imported gpg: Total number processed: 1 gpg: imported: 1
Repeat the verify step.
The source is controlled by Mercurial documented at https://code.google.com/p/apsw/source/checkout
APSW is not available at the Python Package Index (pypi) and hence cannot be installed using easy_install, pip or similar tools. The reason for this is that the tools do not provide a way of providing options to the setup.py included with APSW and hence there is no way for APSW to know if you want SQLite downloaded, a consistent version of SQLite or the latest, to use a system SQLite instead, error if an a system version is not available etc. I could pick a sensible default but everyone else using pypi would be disadvantaged or worse get undesired behaviour (eg different versions of SQLite depending on when a machine did an install). Additionally the world of Python packaging is going through another series of changes (distutils2 aka packaging) so some solution may come out of that.
I’m happy to work with anyone who has a solution to this problem.