Gadfly Highly portable SQL query engine based in Python with transactions, recovery and client server mode
Download

Gadfly Ranking & Summary

Gadfly Tags

store query Retrieve SQL query query engine sql retriever

Gadfly Description

Highly portable SQL query engine based in Python with transactions, recovery and client server mode Gadfly is a simple relational database system implemented in Python based on the SQL Structured Query Language.Gadfly is a collection of python modules that provides relational database functionality entirely implemented in Python. It supports a subset of the intergalactic standard RDBMS Structured Query Language SQL.Gadfly allows Python programs a convenient way to store, retrieve and query tabular data without having to rely on any external database engine or package. That is, Gadfly provides an easy, simple, and relatively efficient in-memory relational database style engine for Python programs, complete with a notion of "aborts" and "committed, recoverable transaction".One of the most compelling aspects of Gadfly is that it runs whereever Python runs and supports client/server on any platform that supports the standard Python socket interface. Even 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 mechanism and gadfly will read and run the database.It supports persistent databases consisting of a collection of structured tables with indices, and a large subset of SQL for accessing and modifying those tables. It supports a log based recovery protocol which allows committed operations of a database to be recovered even if the database was not shut down in a proper manner (ie, in the event of a CPU or software crash, ). It also supports a TCP/IP Client/Server mode where remote clients can access a Gadfly database over a TCP/IP network (such as the Internet) subject to configurable security mechanisms.

Gadfly Related Software