LuaSQL is a simple interface from Lua to a DBMS. It enables a Lua program to:
- Connect to ODBC, ADO, Oracle, MySQL, SQLite, Firebird and PostgreSQL databases;
- Execute arbitrary SQL statements;
- Retrieve results in a row-by-row cursor fashion.
LuaSQL is free software and uses the same license as Lua 5.1.
LuaSQL can be installed via LuaRocks, using the driver for your database of choice:
luarocks install luasql-sqlite3 luarocks install luasql-postgres luarocks install luasql-mysql luarocks install luasql-sqlite luarocks install luasql-odbcSource code for LuaSQL can be downloaded from its GitHub repository.
Version 2.3 is just an adaptation of the code to work with Lua 5.0, 5.1 and 5.2.
Version 2.2 started a distributed development, with all project discussions happenign through the Kepler's mailing list. New developers: Hisham Muhammad, Ignacio Burgueño, Luis Eduardo Jason Santos, Marc Nijdam, Mauricio Bomfim and Scott Morgan.
Version 2.1 and 2.0 were redesigned by Roberto Ierusalimschy, André Carregal and Tomás Guisasola as part of the Kepler Project. The implementation was coded by Tomás Guisasola, Eduardo Quintão, Thiago Ponte, Fabio Mascarenhas and Danilo Tuler, with many contributions from Michael Broughton, Tiago Dionizio, Leonardo Godinho, Pedro Maia, Klaus Ripke, Michael Roth and others.
LuaSQL was originally designed by Pedro Miller Rabinovitch and Roberto Ierusalimschy. The first implementation was compatible with Lua 4.0a. Many modifications were made but not distributed by Diego Nehab (ODBC), Carlos Cassino, Tomás Guisasola and Eduardo Quintão (PostgreSQL).
LuaSQL development was sponsored by Fábrica Digital, FINEP and CNPq.
For more information please contact us. Comments are welcome!
You can also reach other Kepler developers and users on the Kepler Project mailing list.