MonetDB is a open-source database system for high-performance applications in data mining, OLAP, GIS, XML Query, text and multimedia retrieval. MonetDB often achieves a 10-fold raw speed improvement for SQL and XQuery over competitor RDBMSs. ...
DBAComp is an easy-to-use graphical tool for Oracle database administration. It allows to visualise the content of the data dictionary of Oracle databases. It does this in a way that allows you to drill down from one item of information to related ones in a completely graphical way. The SQL used ...
Micro DB Manager is a database abstraction class written in PHP using object oriented technologies.The class realize the following functionalities: - Connectiong to the databse - Executing queries - Converting results to associative array - Get selected rows - Get affected rows - Get last insert ...
PythonReports is a toolkit aimed to build database reports in Python programs. The toolkit includes report template designer, report builder and several printout renderers for GUI and graphic file output. Report builder applies a template to a sequence of uniform data objects and produces a printout structure that can be saved ...
DirectoryStorage is a Storage for ZODB, the object database used by Zope. It uses ordinary files and directories to store revisions of ZODB objects; one file per revision per object. Features: - very simple file format; one file per revision per object. Your data is not locked away inside an unfamiliar, ...
In the Web domain, sometimes it is necessary to dynamically create images containg just text. This script uses PIL to do just that, and it can be integrated to Zope/Plone through External Methods. ...
Resultset allows you to accessdatabase results by field name. It wraps each result row in a ResultRow class which allows you to retrieve results via a dictionary interface (by column name). The regular list interface (by column number) is also provided. ...
Berkeley DB is an open source database. Its most important advantages are its simplicity to use and its performance. This is an introductory example, that shows how to create a database, add new elements in it (as Key/Value pairs) and finally how to print all content of the database. The example ...
One of the problems of dealing with databases is presenting the result of a query when you may not know much about the data. This script uses the cursor's description attribute to try and provide appropriate headings, and optionally examines each output row to ensure column widths are adequate. ...
Metakit is a reliable/lightweight/fast database library that python can use. Metakit has an extend mode that enables many simultaneous readers and one writer w/out needing a database server to synchronize things. ...
This script shows one use for class methods, i.e. to map Relational tables and rows to objects in python. class methods come in handy when you want all objects in a class to share one method, in this case to retrieve rows from a table. ...
This code loads arbitrary pickles. It just loads their data into totally inert objects which you can then traverse and do what you like to. It's pretty similar to processing a DOM tree. ...
Sometimes it can be hard to work out a way of efficiently representing a tree in the database. Combining modified preorder tree traversal with a parent child model allows most common queries to be represented in a single sql query. This example uses MySQLdb, but can easy be changed to use ...
