Hello, writing database queries in Corona is painful, we spent many time writing sqls and such. To solve that I’ve made a library which adds support for ORM-like (hibernate, rails active record and such) to Corona. Also it implements Active Record pattern, so you can easily do CRUD operations with one call. Plus, you will have a Object Oriented syntax for managing objects (thanks to 30log project). It is very simple to use:
local Person = Model:extend("Person", { columns = { age = {}, surname = { notNull=true }}} ) local aPerson = Person({age=30, surname="Soares"}) aPerson:save()
Voilá, you have a table created and inserted a row without writing a single line of SQL.
Also, it has support for relationships one to one and one to many. Project is on GITHUB: https://github.com/lsoaresesilva/crate_orm
I have to update the readme, create more examples, and such. But it is very easy to use. I will keep updating it over the time. I will push the unit tests sooner.
Enjoy.