Re: Prepared statements in LuaSQL

[Matthew Wild <mwild1@...>]

On 26 January 2012 15:57, Joshua Jensen <josh.jjensen@gmail.com> wrote:
> ----- Original Message -----
> From: Tomas Guisasola Gorham
> Date: 1/26/2012 5:02 AM
>>
>>    Hi Jay
>>
>>> (Lua SQL still makes me very sad by lacking parameterized queries
>>> though. Yes, it's better than nothing, Which backends can't support a
>>> norrmalized form for the most common statements?
>>
>>    I think LuaSQL should not define any of these forms, thus exposing
>> the incompatibilities between the databases.  Anyway, to offer an API
>> for prepared statements, LuaSQL must define a _standard_ way to declare,
>> bind the values and execute a prepared statement.  We have discussed that
>> before, but anyone had time to spend on that front :-(
>>
> LuaDBI [1] has prepared statements support built into the API.  For the
> couple databases I have used in on, it appears to work great for me.
>

Prosody is using LuaDBI, almost exclusively for the fact that it
supports prepared statements (and was actively developed at the time).

Unfortunately the LuaDBI author appears to have become unresponsive
some time ago (I have had no reply to emails after months, whereas
originally he was replying within days, often with fixes for our
problems). I hate to say it but it may end up as another library I
take maintainership of if it doesn't return to life.

Either way, as things stand, know that at least one large project is
depending on this library... so we're ensuring it gets tested in the
wild, and that (one way or another) bugs shall be fixed :)

Regards,
Matthew