$ sqlite3 dev.db
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> .quit

$ sqlite3 dev.db  "create table tb_host (id INTEGER PRIMARY KEY,url TEXT,datetime DATE);"

$ sqlite3 dev.db "insert into tb_host (url,datetime) values ('http://www.google.com/','DATETIME('NOW','LOCALTIME'));"

$ sqlite3 dev.db  "select * from tb_host;"

Python 2.5 is a minimum requirement.

import sqlite3
conn = sqlite.connect('dev.db')

c = conn.cursor()

c.execute("create table tb_host (id INTEGER PRIMARY KEY,url TEXT,datetime DATE)")

c.execute("insert into tb_host (url,datetime) values ('http://www.google.com/','DATETIME('NOW','LOCALTIME'))")

conn.commit()

conn.close()

1. http://freshmeat.net/articles/sqlite-tutorial
2. http://docs.python.org/library/sqlite3.html
3. http://www.halfcooked.com/presentations/osdc2006/python_databases.html