纯JavaScript快速的客户端SQL数据库：Alasql.js
jopen
10年前
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