Logging

Not Supported

Foreign Keys

Supported

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.

Checkpoints

Not Supported

Concurrency Control

Not Supported

Concurrency control is not supported, nor is parallel execution.

Joins

Hash Join

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

Query Interface

SQL

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.

Storage Architecture

In-Memory

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