Ruby <-> SQLite3

sqlite_basics.rb

fn="test.sqlite"
exit(1) if File.exist?(fn)

require 'rubygems'
require 'sqlite3'

db=SQLite3::Database.new(fn)
db.execute("CREATE TABLE testable (t1 INTEGER PRIMARY KEY, data TEXT, num DOUBLE, time DATE)")
db.execute(%^INSERT INTO testable (data,num,time) VALUES ('This is sample data',#{rand},"#{Time.now}")^)
puts db.execute("SELECT * FROM testable")
db.execute("DROP TABLE testable")
File.delete(fn)