FR : bindings to sqlite3_clear_bindings

[arnaud-feldmann]

Hi, If I understand the SQLite doc correctly, there is a function that allows to clear bindings after a reset and hence get a fresh renewed prepared query. Right now, as far as I know, within RSQLité there is no way to keep a prepared query in memory. Could it be possible to make a function that calls reset and clear_bindings on the results without breaking the pointer ?

That would allow a simple way of dealing with prepared queries compiled at connection time, or as lazy singletons. That is, if your application relies on sophisticated queries that are always the same, you just upload/prepare them once.

Thanks, Arnaud