Sitemap

MkSQL

• Introduction
• Prerequisites
• Further Reading
• Installation
• License
• Sponsorship
• Reporting Bugs

Introduction

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.

MkSQL can be used to create, query or update MetaKit databases. It can even query MetaKit subviews (although it cannot create or update subviews).

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.

Prerequisites

MkSQL requires:

• Python 2.1 (or later).
• MetaKit 2.4 including the metakit.py wrapper.
• mx.TextTools from the egenix mxBase package.

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.

Changes

Version 0b1 [June 6, 2003]

• Added LIKE
• Added IF(cond, trueresult, falseresult)
• Added extensions for querying Metakit subviews:
  • SELECT ... FROM FLATTEN(view.subview)
  • SELECT ... FROM outer WHERE ( SELECT .... FROM subview ... )
• Fixed some case (in)sensitivity bugs (with help from Brian Kelley - thanks, Brian!).
• Numerous other bug fixes.

Installation

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

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.

License

This code is licensed under the MIT license. Please see license.txt.

Sponsorship

Please show your appreciation and help fund continued development of MkSQL by making a contribution.

Reporting Bugs

Report bugs (or feature requests) here. Please make sure you set Product to MkSQL. (If you choose not to become a registered user, please include some contact information in the report itself.)