mx.ODBC example

Category: Python - Database Tools

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 a database, in this case an access file, get the columns of a table and get data from the table. Date: 04 February, 2012


Table Data - Table Column - Database Query - Mx ODBC - Database - Query

Homepage: http://code.activestate.com

Developer: code.activestate.com

License: Freeware

Operating System: Windows

Add a Comment

all are required fields

     
What do you think of this resource?

Select Your Rate:

Votes:0

 

Related Scripts Download

It is written with an eye to output on a text-only console.

developer Developer: elifulkerson.com
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


Python has list comprehensions to select items in an iterable if a certain condition is true ; this is very similar to database requests.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: All


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

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: All


GEQUEL is a GTK-based frontend for a MySQL database.

developer Developer: ta.twi.tudelft.nl
license License: Freeware
operating systems Operating System: All


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

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: All


SPIDERS (SQL PHP/PERL Integrated DEvelopment Reporting System) is a PHP web front end on apache used to run perl script reports on SQL databases.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All


This script runs parameterized map, filter, reduce, and extract functions on a database structured as a list of tuples.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: All


MS SQL Server log monitor is a script that gathers errors, warnings, and failures from Micrsoft SQL Servers and SQL Server Agents.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


This is a very simple script that allows you to examine a ZODB database.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris