LuaSQL-SQLite3 example

useSqlite3.lua

#!./bin/lua

local driver = require('luasql.sqlite3')
local env = driver.sqlite3()
local db = env:connect('db.sqlite')

db:execute[[
  CREATE TABLE generic(
    key varchar(50),
    value varchar(150)
  )
]]

db:execute[[
  INSERT INTO generic VALUES('nome', 'coisa')
]]

local results = db:execute[[
  SELECT * FROM generic
]]

local key,value = results:fetch()
while key do
  print(key ..': '.. value)
  key,value = results:fetch()
end

results:close()
db:close()
env:close()

Excellent, the only one that really worked