SnakeSQL - 0.5.2

SnakeSQL is a pure Python SQL database written to remove the dependence of the Python Web Modules on 3rd party drivers for non-Python databases like MySQL but designed to be a useful database in its own right.

The database supports the simplest possible subset of ANSI SQL 92 including NULLs (something other pure Python databases such as Gadfly do not currently support) as well as more advanced features such as foreign key constraints and simple joins.

The database is fully DB-API 2.0 compliant and is written in layers so that it can easily be extended to support different storage mechanisms. Currently implemented are a fast binary DBM driver (default) and a slower CSV file driver (handy for viewing table contents when designing and developing an application or database structure).

This is an alpha release designed to give interested users the chance to feedback bug reports or comments. The database appears stable on Windows XP Python 2.1 to 2.4 and successfully runs the test scripts and test SQL in Interactive Prompt mode. It has not been tested more extensively. If you use the database and it doesn't work, please let me know.

To report bugs please email bugs@pythonweb.org. quoting [SnakeSQL] at the start of the subject line.

Whats New In The Latest Version?

  • Foreign Key Constraints
  • Simple Joins

Documentation

The documentation is included with the distribution or available to browse online here in a number of formats:

Download the latest release

Download the latest release here. Snake SQL will work with nothing more than Python 2.1 or above installed.