Top download

Database Tools Python scripts - Top 4 Download

Search Script:

Register Login

Database Tools Python script downloads

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
Efficient database trees 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

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 ADO to list field definitions for tables 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

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

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
Resultset 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

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

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
Another way to use fields for databases 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

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

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
Metakit for safe reading and writing 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

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

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
Modifying pickles without instantiating objects downloadDownload

Popular Scripts Search

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