Frank admits that SQLite isn't as fast as SQLite, but it's "a handy alternative for small amounts of data." He goes on to say:
Developers who are familiar with SQL should be able to easily pick up SQLike. It supports a multitude of language elements including SELECT, JOIN, EXCEPT, UPDATE, JOIN (implicit), SELECT DISTINCT, INTERSECT, and more. It also uses aggregate functions such as COUNT, SUM, and AVERAGE.
Because SQLike consists of ECMA-262 code, all of the code inside function q is identical and has been compressed by the YUI compressor. The only difference in languages is at the beginning lines defining SQLike as:
- JS object
- AS2 class
- AS3 class inside a package
Here are some examples of SQLike's SQL-like syntax:
YQL provides the same functionality using web services, but SQLite does it in-memory.
Read more about SQLike in this blog or try a demo and short reference.