lua+sqlite3

require "luasql.postgres"

lrwxrwxrwx 1 root root 32 Сен 19 12:45 /usr/lib/i386-linux-gnu/lua/5.1/sqlite3.so -> ../../liblua5.1-sql-sqlite3.so.2

> require "luasql.sqlite3"
> env=luasql.sqlite3()
stdin:1: attempt to index global 'luasql' (a nil value)
stack traceback:
	stdin:1: in main chunk
	[C]: ?

$ objdump -T liblua5.1-sql-sqlite3.so.2 | grep luaopen

objdump -T liblua5.1-sql-sqlite3.so.2 | grep luaopen
00002f10 g    DF .text	000001ab  Base        luaopen_luasql_sqlite3

assert (package.loadlib("sqlite3.dll", "luaopen_luasql_sqlite3")) ()

-- create environment object
env = assert (luasql.sqlite3())

-- connect to data source
con = assert (env:connect ("databasename.sqlite3", "username", "password"))
...

stdin:1: attempt to index global 'luasql' (a nil value)
stack traceback:
	stdin:1: in main chunk
	[C]: ?

assert (package.loadlib("sqlite3.dll", "luaopen_luasql_sqlite3")) ()

-- create environment object
env = assert (sqlite3())

-- connect to data source
con = assert (env:connect ("databasename.sqlite3", "username", "password"))
...

assert (package.loadlib("/usr/lib/i386-linux-gnu/lua/5.1/sqlite3.so", "luaopen_luasql_sqlite3")) ()
> env = assert (sqlite3())
stdin:1: attempt to call global 'sqlite3' (a nil value)
stack traceback:
	stdin:1: in main chunk
	[C]: ?

local m = require "luasql.sqlite3"
for k,v in pairs(m) do print(k,v) end

Lua 5.1.5  Copyright (C) 1994-2012 Lua.org, PUC-Rio
> do
>> local m = require "luasql.sqlite3"
>> for k,v in pairs(m) do print(k,v) end
>> end
sqlite3	function: 0x8f53a30
_VERSION	LuaSQL 2.3.0
_DESCRIPTION	LuaSQL is a simple interface from Lua to a DBMS
_COPYRIGHT	Copyright (C) 2003-2012 Kepler Project

$ ./run.lua
Name: Jose das Couves, E-mail: jose@couves.com
Name: Manoel Joaquim, E-mail: manoel.joaquim@cafundo.com
Name: Maria das Dores, E-mail: maria@dores.com
$ cat run.lua
#!/usr/bin/lua

-- load driver
local m = require "luasql.sqlite3"
-- create environment object
env = assert (m.sqlite3())
-- connect to data source
con = assert (env:connect("luasql-test.sql"))
-- reset our table
res = con:execute"DROP TABLE people"
res = assert (con:execute[[
  CREATE TABLE people(
    name  varchar(50),
    email varchar(50)
  )
]])
-- add a few elements
list = {
  { name="Jose das Couves", email="jose@couves.com", },
  { name="Manoel Joaquim", email="manoel.joaquim@cafundo.com", },
  { name="Maria das Dores", email="maria@dores.com", },
}
for i, p in pairs (list) do
  res = assert (con:execute(string.format([[
    INSERT INTO people
    VALUES ('%s', '%s')]], p.name, p.email)
  ))
end
-- retrieve a cursor
cur = assert (con:execute"SELECT name, email from people")
-- print all rows, the rows will be indexed by field names
row = cur:fetch ({}, "a")
while row do
  print(string.format("Name: %s, E-mail: %s", row.name, row.email))
  -- reusing the table of results
  row = cur:fetch (row, "a")
end
-- close everything
cur:close()
con:close()
env:close()