lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]

On Mon, Feb 16, 2009 at 7:43 PM, Neil Richardson <> wrote:
> Website:
> Wiki:
> LuaDBI is a database interface library for Lua. It is designed to provide a
> RDBMS agnostic API for handling database operations. LuaDBI also provides
> support for prepared statement handles, placeholders and bind parameters for
> all database operations.
> Currently LuaDBI supports DB2, Oracle, MySQL, PostgreSQL and SQLite
> databases with native database drivers.
> This in an initial alpha release - all features should work as specified but
> there may be bugs still inside. All bug reports are greatly appreciated.
> LuaDBI has been built and tested on Linux and OSX but not Windows.
Great!  It's good to see more competing implementations of Lua SQL interfaces.

One thing I noticed that is missing (and seems to be missing from
most) is a way to define what type you are binding.
This is particularly important for SQLite where a column can take on
multiple types for a given column and two types map to one Lua type:

 * Blob == string
 * Text == string

If it is bound as the incorrect one, then there can be problems...

Thomas Harning Jr.