Join the DZone community and get the full member experience.Join For Free
Learn how error monitoring with Sentry closes the gap between the product team and your customers. With Sentry, you can focus on what you do best: building and scaling software that makes your users’ lives better.
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.
Opinions expressed by DZone contributors are their own.