Scott: On Tue, Oct 5, 2010 at 2:40 PM, Scott Morgan <bl...@blueyonder.co.uk> wrote:
> 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. > Well at the very least must get it to play nice with luarocks. > [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. > I didn't see it in the latest download from luaforge... do you have a link to the repository? > > > 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. > That's one way to do it. :) > > To add to the list: > > 6. Parametrised queries (partly ties in with point 5 above and the > nightmare of the SQL non-standard). > Right, agree! > > 7. BLOB support, a data type with ability to load/save binary data > to/from files and be used by LuaSQL in queries. > Yeah that's another notorious 'differently supported' feature from RDBMS to RDBMS. Agree it should be on the roadmap. :) - Bob > Scott > > > > _______________________________________________ > Kepler-Project mailing list > Kepler-Project@lists.luaforge.net > http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project > http://www.keplerproject.org/ > -- Bob Calco DBA Softcraft Solutions bob.ca...@softcraft-solutions.com
_______________________________________________ Kepler-Project mailing list Kepler-Project@lists.luaforge.net http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project http://www.keplerproject.org/
