Re: [ANN] LuaDBI initial alpha release

["Thomas Harning Jr." <harningt@...>]

On Mon, Feb 16, 2009 at 7:43 PM, Neil Richardson <nrich@ii.net> wrote:
> Website: http://code.google.com/p/luadbi/
> Wiki: http://code.google.com/p/luadbi/w/list
>
> 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.