Database Tools scripts - Top 4 Download

Database Tools script downloads

MonetDB

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

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

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

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 ...
Python

DirectoryStorage

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, ...
Python

Dee Module

Dee Module implements a truly relational database language using Python. ...
Python

Dynamic Generation of image labels

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. ...
Python

ADO primary key and table creation

This script creates an Access 2000 table and adds a primary key to it. ...
Python

Using ADO to list field definitions for tables

This script demonstrates the use of ADO to get database table definitions. A PostgreSQL create code is generated. ...
Python

Using the MySQLdb interface

Using the MySQLdb interface script is a simple example showing how to use the MySQLdb interface to function with your MySQL database. ...
Python

MySQL and accessing database results by field

MySQL and accessing database results by field script allows you to access database records returned by a query using the field name. ...
Python

Resultset

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. ...
Python

Using Berkeley DB Database

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 ...
Python

Printing of Database Cursor Contents

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. ...
Python

Another way to use fields for databases

Another way to use fields for databases script is a lightweight method to access the field names from a database. ...
Python

Metakit for safe reading and writing

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. ...
Python

Classmethods for Object Relational Mappings

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. ...
Python

Single parameters style for DB API modules

This script allows you to code SQL queries the same way independent on paramstyle of used DB module. ...
Python

Modifying pickles without instantiating objects

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. ...
Python

Efficient database trees

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 ...
Python