Gadfly Relational Database
Gadfly is a relational database management system written in Python.
Gadfly is a collection of Python modules that provides relational database functionality entirely implemented in Python. It supports a part of the standard RDBMS Structured Query Language (SQL).
Gadfly runs anywhere Python runs and supports client/server on any platform that supports the standard Python socket interface. The file formats used by Gadfly for storage are cross-platform. A gadfly database directory can be moved from Win95 to Linux using a binary copying method and gadfly will read and run the database.
It supports persistent databases consisting of a group of structured tables with indices, and a big subset of SQL for accessing and changing those tables. It supports a log based recovery protocol that allows committed operations of a database to be restored even if the database was not shut down in a good manner (For example, in a case of a computer or software crash). It also supports a TCP/IP Client/Server mode where remote clients can enter a Gadfly database over a TCP/IP network (like the Internet) subject to configurable security mechanisms.
Since Gadfly depends a lot on the kwParsing package it is distributed as part of the kwParsing package, all under the same copyright.
Gadfly allows Python programs to save, retrieve and query tabular data without needing to rely on any external database engine or package. It provides an in-memory relational database type of engine for Python programs, complete with a sense of a “committed, recoverable transaction” and “aborts”.
Here is a link to the Gadfly relational Database project: