Sitemap

McMillan Enterprises, Inc.
Python Pages
  Sockets HOWTO
  Distributing Python Programs
  A Python C++ API
  Embedding Python
  Stackless Python
  MkSQL
    MkSQL Users Guide
    MkSQL Grammar
  Import Hooks
Java Samples
About ME Inc.

MkSQL

What is it?

MkSQL is a Python package which implements a SQL front end to the MetaKit database. It implements a large subset of the SQL 2 (aka SQL 92) standard, and comes with a Python DBI version 2 interface.

Prerequisites

MkSQL requires:

More Details

MkSQL can be used to query or update any existing MetaKit database which has a relational structure. Basically that means that subviews are are ignored.

In addition, if you use MkSQL to define your database structure, MkSQL will enforce integrity constraints on all update, insert and delete statements.

Note that MkSQL is not a database server. MetaKit is an embedded database, and MkSQL does nothing to change that.

Further Reading

User's Guide
The Python DBI interface, and a MkSQL's referential integrity implementation.
The SQL Grammar
The dialect of SQL that MkSQL understands.

Installation

Download the Windows zip file or the tar.gz file. The current release is 0a0.

Unzip the archive, and from the top level directory, execute python setup.py install.

For a quick demo, see the MkSQL/tests/testdbi.py script.

copyright 1999-2002
McMillan Enterprises, Inc.