Chordate Systems Solutions	General information Installation Use feedback home Gadfly home
	Gadfly FAQ (Frequently asked questions) General information What is gadfly? What is the current version? Where can I get it? Why SQL and the relational model? Why Python? What is the License? Is it Free? Why? You mean I can bundle it into my own product for free? Really? Where does it run? What are the software/hardware requirements? Is there a query optimizer? Is it fast? Are there data size limitations? What about recovery after crashes? What about client/server based access? What about concurrency control? Is there a mailing list? Who uses it? Is support available? What are the plans for Gadfly? How do I contribute some code that uses Gadfly? Installation Where is sqlwhere? I get an ImportError! Why not use hierarchical packages? Does Gadfly support ODBC or JDBC? How can I move a Gadfly database instance from one location/machine to another? How can I access gadfly from another program? What database size limits are there? What are the file types in the gadfly database directory? Use Does Gadfly support virtual tables (VIEWS)? Quantifiers? EXISTS? Aggregates? Groupings? Indices? How standard is the SQL subset supported? Are BLOBS (binary large objects) supported? How can I find the column names in a "select *"? Can I add my own table implementation? Why can't I update my own table implementation via SQL? How do you define a primary key? What about NULLs, Triggers and other missing stuff? Where is the LIKE predicate? After a crash Gadfly won't recover! Help!
	Gadfly Frequently Asked Questions

The following topics are of a general nature.

• What is gadfly?

  Gadfly is a relational database management system which uses a large subset of very standard SQL as its query language and Python modules and optional Python/C extension modules as its underlying engine. Gadfly stores the active database in memory, with recovery logging to a file system. It supports an optional TCP/IP based client server mode and log based failure recovery for system or software failures (but not for disk failures).

• What is the current version?

  The current version is Gadfly 1.0. To be sure you have the current version, please consult the version number that comes in the documentation.

  Gadfly 1.0 attempts to fix all known bugs in previous versions and adds a small number of features (hopefully without adding too many new bugs).

• Where can I get it?

  Please get it from http://www.chordate.com

• Why SQL and the relational model?

  Gadfly is based in SQL and the relational model primarily because the SQL query language and the relational model have been highly successful, are highly standard, and are well understood by a large number of programmers. If you understand standard SQL you already know how to use Gadfly -- and this distinguishes Gadfly from many similar database systems out there -- even ones which aren't "really free."

• Why Python?

  Gadfly is based in Python because Python made the development of such a relatively sophisticated and standard SQL implementation feasible for one programmer, in his spare time, and also because it automatically made Gadfly portable to almost any computing platform. In addition, Gadfly can be used with Python to develop sophisticated data manipulation applications easily.

• What is the License? Is it Free? Why?

  Gadfly can be used and modified in source form for any purpose, including commercial purposes. There is no explicit or implied warrantee for Gadfly, even though it is intended to be useful. Gadfly is free because I wanted people to use it, and I suspected they wouldn't if it wasn't free and highly standard, and furthermore I didn't want to risk the possibility of legal responsibility if people did use it and had problems.

• You mean I can bundle it into my own product for free? Really?

  Yes. Please do. Several organizations have done so already.

• Where does it run?

  To run Gadfly you need (1) a file system and (2) Python. If Python runs on your platform Gadfly should run there too. I have not been able to verify that this version runs on the Macintosh yet (since the Mac apparently has some fairly nonstandard file system conventions), but even if it doesn't it should run after a few trivial adjustments. Please let me know if Gadfly doesn't run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.

  Gadfly is expected to run "out run on any of your platforms.