LuaSQL
Database connectivity for the Lua programming language

Overview

LuaSQL is a simple interface from Lua to a DBMS. It enables a Lua program to:

  • Connect to ODBC, ADO, Oracle, MySQL, SQLite, JDBC, 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.0.

Status

LuaSQL version 2.0.2 (for Lua 5.0) is now available for download.

The PostgreSQL driver has been tested on Windows, Linux and MacOS X and is compatible with PostgreSQL 7.x and 8.x.

The ODBC driver has been tested on Windows (SQLServer and Microsoft Access drivers).

The MySQL driver has been tested on Windows and Linux and is compatible with versions 4.0, 4.1 and 5.0.

The Oracle driver has been tested on Windows and is compatible with OCI 8 API.

The SQLite driver has been tested on Windows and Linux and is compatible with versions 2.x.

The JDBC driver has been tested on Windows with LuaJava 1.0 and JDK 1.4 (MySQL driver).

The ADO driver has been tested on Windows with LuaCOM 1.3 (Microsoft Access driver).

Download

Source code for LuaSQL can be downloaded from the LuaForge page. If you are using LuaBinaries 5.0.2 Release 2, a Windows executable version of LuaSQL can be found at the same LuaForge page.

Credits

LuaSQL 2.0

Version 2.0 was redesigned by Roberto Ierusalimschy, André Carregal and Tomás Guisasola as part of the Kepler Project. The implementation is compatible with Lua 5.0 and was coded by Tomás Guisasola, Eduardo Quintão, Thiago Ponte, Fabio Mascarenhas and Danilo Tuler, with many priceless contributions from Michael Roth, Tiago Dionizio, Pedro Maia and Leonardo Godinho.

LuaSQL 1.0

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.

Contact us

For more information please contact us. Comments are welcome!

You can also reach other Kepler developers and users on the Kepler Project mailing list.

Valid XHTML 1.0!

$Id: index.html,v 1.21 2006/06/26 18:29:05 carregal Exp $