now step away from Microsoft APIs altogether. Gadfly is an SQL
relational database written in Python by Aaron
can be found at
http://www.chordate.com, and is distributed
in a 200-KB Zip file, including documentation.
Gadfly gives Python programs relational database capabilities without relying on any external database engines. It offers the following features:
Compliance with the Python Database API
Total portability between platforms
A transaction log and recovery procedure
A built-in TCP/IP server mode, allowing it to serve clients on remote machines
Security policies to prevent accidental deletion of data
It’s not intended as a multiuser production system, and some features are missing at present, notably Null values and Date/Time variables.
Aaron previously produced both a parsing engine named
and a library of
data structures, including sets, directed graphs, and dictionaries,
. These C extensions
are part of the Gadfly package and can build an efficient and fast
in-memory SQL engine. If you are interested in either how to parse
SQL statements or in the low-level relational operations, Gadfly is a
great package to explore. To install and set up
perform these steps:
Download the 217-KB Zip file.
Unzip to a directory on the Python path.
CD to the directory in a DOS prompt.
Create a subdirectory for a test database with
dbtest. This ...