Researching Titanium Mobile development, I want to create a database application and I need a database framework or ORM (Object-Relational Mapper) to manage my entities without troubling with SQL.
Many available ORM frameworks written by JavaScript is capable of dealing with SQLite database that can worked with HTML5, Google Gears, and Titanium Mobile, and Joli.js is the one I found that is more suitable when used with Titanium Mobile.
Joli.js provides simplistic way to create database query, like amazing Query constructs (query().select(“tablename”).where(“name = ?”, “age”).execute()), and easier / extensible way to define the model entities. It is enough for simple application development. However, it does not support relationship association between entities (one-to-one, one-to-many) such like ActiveRecord did originally.