Alasql是一个轻量级的客户端内存SQL数据库，设计支持浏览器和Node.js。

• Alasql 采用纯JavaScript开发，并且没有使用浏览器 WebSQL 数据库。
• Alasql is fully functional compact sql server with JOINs, GROUPs, UNIONs, ANY, ALL, IN, subqueries and very limited transactions support.
• Alasql 支持 ROLLUP(), CUBE() and GROUPING SETS() functions
• Alasql 可用于大部分浏览器 (Chrome, Firefox, IE, Safari), Node.js, and mobile iOS and Android.

支持的SQL语句

• SELECT fields FROM tableid1 JOIN tableid2 ON oncond WHERE cond GROUP BY v1,v2 HAVING cond ORDER BY a,b, LIMIT number OFFSET number
• INSERT INTO table [ (field1, field2) ] VALUES (value1, value2), (value3, value4), ...
• INSERT INTO table SELECT subquery
• UPDATE table SET field = value1, field = value2 WHERE condition
• DELETE FROM table WHERE condition
• CREATE TABLE [IF NOT EXISTS] table
• DROP TABLE [IF EXISTS] table

项目主页：http://www.open-open.com/lib/view/home/1415688317196