ePrivacy and GPDR Cookie Consent by Cookie Consent

Database Tools Python scripts - Top 4 Download

Database Tools Python script downloads

Sql2diagram sxd

It can be used in reverse-engineering ERD (Entity-Relationship Diagrams) to create UML-style table structure diagrams.The program outputs OpenOffice.org Draw (.sxd) files, so the results are editable.The program can also output a machine readable textual explanation of the diagram it is writing. ...
Python

Read tabular data from Excel spreadsheets

Sometimes you get an Excel spreadsheet (say, from the marketing departement) and you want to read tabular data from it (i.e. a line with column headers and lines of data). There are many ways to do this (including ODBC mxODBC), but the easiest way could be this script: provide a file ...
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

neo my2pg

neo_my2pg is a Python script for migration from mysql to postgresql. Don't need dump because it use the dbapi 2.0 during the migration.The script is compatible with all major web browsers and is very easy to install and use. ...
Python

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

DBF reader and writer

In this script the reader iterates over records in Dbase or Xbase files and the writer creates dbf files from Python sequences. ...
Python

Expressions Generator for database requests

This script is a wrapper around DBAPI-compliant databases to support iteration and generator expression syntax for requests, instead of SQL. ...
Python

Metakit

Metakit is an efficient embedded database library with a small footprint. It fills the gap between flat-file, relational, object-oriented, and tree-structured databases, supporting relational joins, serialization, nested structures, and instant schema evolution. There is a C API, a Python binding called Mk4py, and a Tcl binding called Mk4tcl (with an optional ...
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

MS SQL Server log monitor

MS SQL Server log monitor is a script that gathers errors, warnings, and failures from Micrsoft SQL Servers and SQL Server Agents. It creates a single HTML file from multiple server logs.It could be used as a quick daily check to determine if particular servers require administrator intervention.You can authenticate using either native ...
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

ADO primary key and table creation

This script creates an Access 2000 table and adds a primary key to it. ...
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

mx ODBC example

Mx.odbc is cross platform and very fast. It could be used to go through a few hundred thousand rows of an access database in seconds where pure ADO would take 30 min (or 3 min if you use the ADO type library). This script is a simple example of how to talk to ...
Python

Pybliographer

Pybliographer is a tool for managing bibliographic databases. You can either use its graphical interface (based on Gnome) which provides powerful editing capabilities, a nice hierarchical search mechanism, direct insertion of references into LyX and Kile, direct queries on Medline, and more. Or you can directly access its internal python classes ...
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

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

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

Dee Module

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

Mapping arbitrary objects to a PostgreSQL database

Mapping arbitrary objects to a PostgreSQL database script allows you to introduce arbitrary objects into a PostgreSQL database. ...
Python