Alasql favicon

Alasql

Alasql.js - is a lightweight client-side in-memory SQL database designed to work in browser and Node.js. It supports SQL and has some of NoSQL functionality. It is efficient for JavaScript arrays and objects manipulation with all power of SQL language. Alasql was written with pure JavaScript and does not use browser WebSQL database.It is fully functional compact SQL server with JOINs, GROUPs, UNIONs, PRIMARY KEYs, ANY, ALL, IN, subqueries, ROLLUP(), CUBE() and GROUPING SETS() functions.It uses optimization methods for SELECT. Alasql works with all modern versions of desktop and mobile browsers, it can operate with JSON objects like JavScript and NoSQL databases