Re: Automatic Mapping Lua tables to a database tables

[Benjamin von Ardenne <benjamin.von.ardenne@...>]

Hi,

this reminds me of the feature in orbit where database tables can be accessed via simple table access and there also is a save() function.

Maybe the orbit code helps you as well: https://github.com/keplerproject/orbit/blob/master/src/orbit/model.lua

Regards,

Ben

On Fri, Jan 31, 2014 at 3:49 PM, Milind Gupta <milind.gupta@gmail.com> wrote:

Hi,

      I have started work on a small module to map lua tables directly to sqlite database using luasql. The aim is that if you are using lua tables to store all your data then that is all you do. You use them like normal lua tables and in the end just do a save command and the changes get saved to a database.

       The database structure is generated by creating the database tables from the template of the table so it accommodates the intended structure specifically. If however there are extra elements or type mismatches it accommodates for them as well. So this would help by removing the burden of always designing database for every project and just deciding on the Lua table structure should be enough and no need to go though all the SQL statements and testing it.

        If this sounds interesting to anyone I could use some help in testing the module out, or some coding help would also be great.

Regards,
Milind