python 으로 sqlite 하기

# python
>>> import sqlite
>>> dbconnection =  sqlite.connect('test.db')
>>> dbconn2 = sqlite.connect(':memory:')
>>> c = dbconnection.cursor()
>>> c.execute('CREATE TABLE sampletable (name VARCHAR(10), desc TEXT, regtime TIMESTAMP)')
>>> dbconnection.commit()
>>> dbconnection.close()

데이터 타입에 관한 글 : http://www.sqlite.org/datatypes.html