Database Tools scripts - Top 4 Download

Database Tools script downloads

Python DAO interface class

Python DAO interface class is a simple base class that can be used to quickly get connected to any database that has DAO interface.  It really is just a Python wrapper around the DAO COM object. ...
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

Pivot Crosstab Denormalization of Normalized List

This script shows you a function that creates a cross-tab or pivot table from a normalised input table. You can use this function to 'denormalize' a table of normalized records. ...
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

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

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

Create an ODBC data source

 With the help of the ctypes module, this script creates the required ODBC data sources when you install database applications that use ODBC. Requirements: · ctypes ...
Python

Simple ZODB viewer in wxPython

This is a very simple script that allows you to examine a ZODB database. Start the script and you can see what is in your ZODB file as well as the overall structure. ...
Python

Adding SQLite sign function

This script adds a user defined Sign function to SQLite using PySQLite. Requirements: · PySQLite ...
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

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

Parse and create fixed size binary data

Python's struct library is too low-level for direct usage. This script having only 40 lines shows how it can be turned into more developer-friendly tool. ...
Python

Create table statements for MS Access tables

This script parses the output of MS Access's documenter report and generates sql create table statements for the tables in the report. ...
Python

Run SQLite connections in isolated threads

This script lets databaseconnections live in their own thread and queues are used to communicate with them. ...
Python

GUID Script

This script is a globally unique identifier that combines ip, time, and random bits. Since the time is listed first, you can sort records by guid. You can also extract the time and ip if needed. GUIDs make wonderful database keys. They require no access to the database (to get the ...
Python