Python supports connections to numerous SQL databases - have a look at the Special Interests Group section on http://www.python.org to find out about the Python DB API.

Gadfly is a pure Python SQL database handler that's great for learning and small tasks ... I've been sorting out the "wood from the trees" today and have two short example programs - one of which initialised Gadfly and sets up tables, the other which looks at the data storded via a select command:

Code:

import sys import gadfly conn = gadfly.gadfly() conn.startup("demo","datadir") th = conn.cursor() th.execute("Create table people (id integer, name varchar)"); th.execute("Insert into people(id, name) values (1,'Graham')"); th.execute("Insert into people(id, name) values (2,'Lisa')"); th.execute("Insert into people(id, name) values (3,'Charlie')"); conn.commit()

and

Code:

import sys import gadfly conn = gadfly.gadfly("demo","datadir") th = conn.cursor() th.execute("select * from people") for x in th.fetchall():     print x

---