On 10/05/2010 02:14 PM, Robert Calco wrote:
> The following are some pseudo-random thoughts about putting some spry
> in LuaSQL's steps:
>
> 1. Better make/install procedure. By better I mean detection of
> available driver libraries should be automatic or at least
> semiautomatic and all the desired/available drivers should be compiled
> and installed with one command on either unix or windows, by whatever
> means necessary.

I think this is what LuaRocks is for, and most the drivers have
rockspecs. You'll never get an easy single command Windows compile
though, better left for the Lua for Windows distribution.

[snip]

> 4. Support additional drivers, e.g., interbase/firebird

Check the repository, there is a FB driver that should (in theory) also
handle older Interbase stuff too.

> 5. (Long term!) A common SQL dialect with some escape sequences for
> notoriously divergent data types (datetime!). The driver chosen would
> 'reinterpret' the SQL into the native tongue of its RDBMs for the
> developer. See:

I think one idea was to treat the LuaSQL drivers as the base and have a
pure Lua wrapper on top to handle the differences.

To add to the list:

6. Parametrised queries (partly ties in with point 5 above and the
nightmare of the SQL non-standard).

7. BLOB support, a data type with ability to load/save binary data
to/from files and be used by LuaSQL in queries.

Scott



_______________________________________________
Kepler-Project mailing list
Kepler-Project@lists.luaforge.net
http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project
http://www.keplerproject.org/

Reply via email to