Checkpoints

Not Supported

Concurrency Control

Not Supported

Concurrency control is not supported, nor is parallel execution.

Data Model

Relational Document / XML

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.

Foreign Keys

Supported

Indexes

Hash Table

AlaSQL uses hash tables for its indexes. Upon index creation, all entries in the table are hashed and stored in a JavaScript object.

Joins

Hash Join

All SQL join types are supported. Prior to executing a join, both tables are pre-indexed, and WHERE predicates are evaluated.

Logging

Not Supported

Query Interface

SQL

Currently, AlaSQL is only available for JavaScript. AlaSQL uses standard SQL interfaces. However, like many other database management systems, AlaSQL is not fully compliant with any revisions of the SQL database query language. For example, the ALLOCATE keyword, which is available since SQL-92, is not supported by AlaSQL.

Storage Architecture

In-Memory

AlaSQL is an in-memory database that is intended for Node.js and in-browser usage.