Python - SQLite

To do operating with sqlite, you need

>>> import sqlite3

>>> con = sqlite3.connection('data.db')

>>> cur = con.cursor()

>>> cur.execute('''CREATE TABLE data (name TEXT, age INT, city TEXT)''')

>>> cur.execute('''INSERT INTO data VALUES('lady gaga', 24, 'luna maya')''')

>>> cur.execute('''INSERT INTO data VALUES('luna maya', 27, 'denpasar')''')

>>> cur.execute('''INSERT INTO data VALUES('barack obama', 49, 'white house')''')

>>> con.commit()

>>> cur.close()

To display it, just do
>>> cur.execute('''SELECT * FROM data''')

>>> for row in cur:

       print row

Python - SQLite