Re: ANN: SQLiteManager 4 - Working with sqlite databases will never be the same!

[Pierre-Yves Gérardy <pygy79@...>]

On Thu, Dec 13, 2012 at 12:08 AM, David Favro <lua@meta-dynamic.com> wrote:
> That's not exactly the same thing as adding "Lua-based stored procedures to
> SQLite," is it?  Amongst other things, the C SDK for cubeSQL does not
> provide the sqlite3 API (or does it)?  So applications built on sqlite3 will
> not automatically run on cubeSQL.
>
> At any rate, Lua stored procedures are already in PostGreSQL via PL/Lua.

PL/Lua hasn't been updated since 2008... Is it compatible with v9.2?

> But the more important question is, since the advantage of a stored
> procedure in a RDMS is typically that it runs directly on the server without
> having to move data back and forth over a serialized (and typically network)
> connection... but sqlite is typically run with the database accessed locally
> by the client, so why not just write your procedure directly in the "client"
> in Lua, accessing the DB through whichever is your preferred adapter to
> sqlite3?
>
> -- David
>

-- Pierre-Yves