Python2.5からSQLiteが標準装備なんだ

使い方間違ってるかも知んないけどメモっとく。

import sqlite3

con=sqlite3.connect(':memory:')
try:
	con.execute('create table person(name, age)')
	con.execute('insert into person values("hoge","11")')
	con.execute('insert into person values("piyo","22")')
	con.commit()
	cur=con.execute('select * from person')
	for row in cur:
		print row
except Exception, ex:
	print ex
finally:
	con.close()