AlaSQL is a relational DBMS designed to run in web browsers and JavaScript-based application servers (Node.js). It supports both relational tables and document-oriented collections (JSON).
- Website
- http://alasql.org[01]
- Source Code
- https://github.com/AlaSQL/alasql[02]
- Developer
- Country of Origin
- RU
- Start Year
- 2014
- Project Type
- Open Source
- Written in
- JavaScript
- Supported Languages
- JavaScript
- License
- MIT License
AlaSQL is a relational DBMS designed to run in web browsers and JavaScript-based application servers (Node.js). It supports both relational tables and document-oriented collections (JSON).
History[02]
The author of AlaSQL is Andrey Gershun, a Russian developer. The initial commit for AlaSQL on Github was on October 26, 2014.
Data Model[04]
AlaSQL supports the relational model, but can also act as a document store. Most standard SQL data types are supported, in additional to a number of JavaScript data types, like JSON objects.
Indexes[06]
AlaSQL uses hash tables for its indexes. Upon index creation, all entries in the table are hashed and stored in a JavaScript object.
Joins[07]
All SQL join types are supported. Prior to executing a join, both tables are pre-indexed, and WHERE predicates are evaluated.
Storage Architecture[01]
AlaSQL is an in-memory database that is intended for Node.js and in-browser usage.
HarperDB
Citations
7 sources- Home Page alasql.org
- GitHub - AlaSQL/alasql: AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel. · GitHub github.com
- https://github.com/agershun/alasql/wiki github.com
- Data Types · AlaSQL/alasql Wiki · GitHub github.com
- Foreign Key · AlaSQL/alasql Wiki · GitHub github.com
- alasql/src/65createindex.js at develop · AlaSQL/alasql · GitHub github.com
- Speed · AlaSQL/alasql Wiki · GitHub github.com