APSW Another Python SQLite Wrapper

APSW - Another Python SQLite Wrapper

apsw-3.3.7-r1 7th September 2006

APSW provides an SQLite 3 wrapper that provides the thinnest layer over
SQLite 3 possible. Everything you can do
from the C API to SQLite 3,
you can do from Python. Although APSW looks vaguely similar to the DBAPI, it is not compliant with that API and instead works the way
SQLite 3 does. (pysqlite is DBAPI
compliant - differences between apsw and pysqlite
2).

Table of contents

  • Download
    • Source and binaries
    • Source code control
  • SQLite
    version compatibility and benchmarking
  • Example
  • Building
  • API Reference
    • Module methods
    • Module constants
    • Connection class
    • Cursor class
  • Exceptions
    • Augmented stack
      traces
  • Types
  • Unicode
  • Multi-threading and re-entrancy
  • Tracing
    • Execution Tracer
    • Row Tracer
  • 64 bit hosts, Python 2.5
  • Execution model
  • DBAPI notes
    • Module Interface
    • Connection Objects
    • Cursor Objects
    • Type objects
    • Optional DB API
      Extensions
  • pysqlite differences
  • Copyright and License
  • Version History
    • 3.3.7-r1
    • 3.3.5-r1
    • 3.2.7-r1
    • 3.2.2-r1
    • 3.2.1-r1
    • 3.1.3-r1
    • 3.0.8-r3
    • 3.0.8-r2
    • 3.0.8-r1

Download

Source and binaries

You can download APSW from SourceForge at
http://sourceforge.net/project/showfiles.php?group_id=75211&package_id=113804.
There is a zip of the source as well as binary packages for Windows.

Some Linux distributions also have packages. Debian users can grab the
package python-apsw.
Gentoo users can grab the package dev-python/apsw.

Source code control

The source is controlled by Subversion accessible as https://svn.sourceforge.net/svnroot/bitpim/subprojects/apsw/trunk
and can be web browsed at http://svn.sourceforge.net/viewcvs.cgi/bitpim/subprojects/apsw/trunk/

SQLite version compatibility and
benchmarking

APSW binds to the C interface of SQLite. That interface is stable for each
major version of SQLite (ie the C interface for any SQLite 3.x is stable, but
SQLite 4.x would be an incompatible change). Consequently you can use APSW
against any revision of SQLite with the same major version number. There are
small enhancements to the C api over time, and APSW adds support for them as
appropriate. The version number of APSW covers the version these enhancements
were added. The vast majority of changes to SQLite are in the SQL syntax and
engine. Those will be picked up with any

标签 , ,