Top download

Database Tools scripts - Top 4 Download

Search Script:

Register Login

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
Python DAO interface class downloadDownload

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
Mapping arbitrary objects to a PostgreSQL database downloadDownload

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
Pivot Crosstab Denormalization of Normalized List downloadDownload

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
DBF reader and writer downloadDownload

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
MS SQL Server log monitor downloadDownload

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
mx ODBC example downloadDownload

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
Simple ZODB viewer in wxPython downloadDownload

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
Create an ODBC data source downloadDownload

Adding SQLite sign function

This script adds a user defined Sign function to SQLite using PySQLite. Requirements: · PySQLite ...
Python
Adding SQLite sign function downloadDownload

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
Expressions Generator for database requests downloadDownload

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
Read tabular data from Excel spreadsheets downloadDownload

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
Parse and create fixed size binary data downloadDownload

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
Create table statements for MS Access tables downloadDownload

Run SQLite connections in isolated threads

This script lets databaseconnections live in their own thread and queues are used to communicate with them. ...
Python
Run SQLite connections in isolated threads downloadDownload

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
GUID Script downloadDownload

Popular Scripts Search

sql  management  manager  database ruby  sqlite  database management  table  database components  database administration  backup  ruby database  administration  database application  application  database tool  database tools  grid  database  query  mysql  database utility  database interface  database manager  library  tool  php  ruby  interface  data  database query