[Sputnik-list] LuaSQL Versium Plugin

[Jim Whitehead II]

On Tue, Mar 4, 2008 at 5:38 AM, Jim Whitehead II <jnwhiteh at gmail.com> wrote:
> On Tue, Mar 4, 2008 at 4:20 AM, Yuri Takhteyev <qaramazov at gmail.com> wrote:
>  > Nice!  I got it running with Xavante myself and wrote up step-by-step
>  >  instructions at http://sputnik.freewisdom.org/en/SQL_Storage in case
>  >  someone else wants to try.
>  >
>  >  The somewhat unfortunate thing is that there is no rock for luasql, so
>  >  you have to use the Kepler installer and set --with-optional=luasql.
>  >  I'll beg for a rock on the Kepler list.
>
>  There is a rock for LuaSQL, it's just on the CVS repository:
>  http://luarocks.luaforge.net/rocks-cvs/
>
>
>  >  Will this is licensed under MIT/X?
>
>  Whatever is convenient for inclusion into sputnik/versium although
>  consider it public domain at this point.
>
>
>  >  A comment on the code:
>  >
>  >     function LuaSQLVersiumStorage:get_node_history(id, prefix)
>  >         ...
>  >         -- TODO: This doesn't return the raw representation at the moment
>  >         return history
>  >     end
>  >
>  >  I take responsibility for failing to provide a clear spec and sending
>  >  you and Sérgio to reverse engineer simple.lua... get_node_history()
>  >  does not _need_ to return the raw representation (which would be
>  >  implementation specific anyway and of no use to versium).
>  >  get_node_history() in simple.lua returns raw_representation as a
>  >  second parameter only so that it this function could be re-used when
>  >  saving the node.  In retrospect, that probably wasn't a good idea,
>  >  from the readability point of view.  I'll change it to two functions:
>  >  get_node_history() which would return just the history and local
>  >  _get_node_history_with_raw_representation().
>
>  Ah good, I was afraid I was missing out on something, but it worked :P
>
>
>  >  >  In theory this _should_ work with any of the LuaSQL drivers as long as
>  >  >  you specify the right driver and connection parameters.  Simply
>  >  >  install the correct rock from the CVS repository, and go go go!  I've
>  >  >  noticed quite a speed increase using even the unoptimized MySQL.
>  >
>  >  Which CVS repository?  They have a LuaSQL rock in CVS but not in the
>  >  luarocks repository?
>
>  See http://luarocks.luaforge.net/rocks-cvs/.

Another thought occurred to me.  Is there a small versium test suite
that could be written to validate a new plugin such as this?  I know
your time can probably be spent elsewhere, but it seems that would be
an easy way for a developer to verify their plugin works as sputnik
expects it's going to.

- Jim