DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. Faircom DB vs. LokiJS vs. Percona Server for MongoDB vs. XTDB

System Properties Comparison AlaSQL vs. Faircom DB vs. LokiJS vs. Percona Server for MongoDB vs. XTDB

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonFaircom DB infoformerly c-treeACE  Xexclude from comparisonLokiJS  Xexclude from comparisonPercona Server for MongoDB  Xexclude from comparisonXTDB infoformerly named Crux  Xexclude from comparison
DescriptionJavaScript DBMS libraryNative high-speed multi-model DBMS for relational and key-value store data simultaneously accessible through SQL and NoSQL APIs.In-memory JavaScript DBMSA drop-in replacement for MongoDB Community Edition with enterprise-grade features.A general purpose database with bitemporal SQL and Datalog and graph queries
Primary database modelDocument store
Relational DBMS
Key-value store
Relational DBMS
Document storeDocument storeDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.51
Rank#256  Overall
#40  Document stores
#118  Relational DBMS
Score0.29
Rank#304  Overall
#43  Key-value stores
#136  Relational DBMS
Score0.49
Rank#260  Overall
#42  Document stores
Score0.60
Rank#246  Overall
#39  Document stores
Score0.18
Rank#332  Overall
#46  Document stores
Websitealasql.orgwww.faircom.com/­products/­faircom-dbgithub.com/­techfort/­LokiJSwww.percona.com/­mongodb/­software/­percona-server-for-mongodbgithub.com/­xtdb/­xtdb
www.xtdb.com
Technical documentationgithub.com/­AlaSQL/­alasqldocs.faircom.com/­docs/­en/­UUID-7446ae34-a1a7-c843-c894-d5322e395184.htmltechfort.github.io/­LokiJSdocs.percona.com/­percona-distribution-for-mongodbwww.xtdb.com/­docs
DeveloperAndrey Gershun & Mathias R. WulffFairCom CorporationPerconaJuxt Ltd.
Initial release20141979201420152019
Current releaseV12, November 20203.4.10-2.10, November 20171.19, September 2021
License infoCommercial or Open SourceOpen Source infoMIT-Licensecommercial infoRestricted, free version availableOpen SourceOpen Source infoGPL Version 2Open Source infoMIT License
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScriptANSI C, C++JavaScriptC++Clojure
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)AIX
FreeBSD
HP-UX
Linux
NetBSD
OS X
QNX
SCO
Solaris
VxWorks
Windows infoeasily portable to other OSs
server-less, requires a JavaScript environment (browser, Node.js)LinuxAll OS with a Java 8 (and higher) VM
Linux
Data schemeschema-freeschema free, schema optional, schema required, partial schema,schema-freeschema-freeschema-free
Typing infopredefined data types such as float or datenoyes, ANSI SQL Types, JSON, typed binary structuresnoyesyes, extensible-data-notation format
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonononono
Secondary indexesnoyesyes infovia viewsyesyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.yes, ANSI SQL with proprietary extensionsnonolimited SQL, making use of Apache Calcite
APIs and other access methodsJavaScript APIADO.NET
Direct SQL
JDBC
JPA
ODBC
RESTful HTTP/JSON API
RESTful MQTT/JSON API
RPC
JavaScript APIproprietary protocol using JSONHTTP REST
JDBC
Supported programming languagesJavaScript.Net
C
C#
C++
Java
JavaScript (Node.js and browser)
PHP
Python
Visual Basic
JavaScriptActionscript
C
C#
C++
Clojure
ColdFusion
D
Dart
Delphi
Erlang
Go
Groovy
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Perl
PHP
PowerShell
Prolog
Python
R
Ruby
Scala
Smalltalk
Clojure
Java
Server-side scripts infoStored proceduresnoyes info.Net, JavaScript, C/C++View functions in JavaScriptJavaScriptno
Triggersyesyesyesnono
Partitioning methods infoMethods for storing different data on different nodesnoneFile partitioning, horizontal partitioning, sharding infoCustomizable business rules for table partitioningnoneShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyes, configurable to be parallel or serial, synchronous or asynchronous, uni-directional or bi-directional, ACID-consistent or eventually consistent (with custom conflict resolution).noneSource-replica replicationyes, each node contains all data
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual Consistency
Immediate Consistency
Tunable consistency per server, database, table, and transaction
noneEventual Consistency
Immediate Consistency
Foreign keys infoReferential integrityyesyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storagetunable from ACID to Eventually Consistentno infoatomic operations within a single collection possiblenoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageYes, tunable from durable to delayed durability to in-memoryyes infoSerialization of a DB in a Node.JS/Cordova/PhoneGap environment. Usage of the IndexedDB-API in a browser.yesyes, flexibel persistency by using storage technologies like Apache Kafka, RocksDB or LMDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyes infovia In-Memory Engine
User concepts infoAccess controlnoFine grained access rights according to SQL-standard with additional protections for filesnoAccess rights for users and roles

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
AlaSQLFaircom DB infoformerly c-treeACELokiJSPercona Server for MongoDBXTDB infoformerly named Crux
DB-Engines blog posts

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

show all

Recent citations in the news

HarperDB - How and Why We Built It From The Ground Up on NodeJS
28 February 2021, hackernoon.com

Create a Marvel Database with SQL and Javascript, the easy way
2 July 2019, Towards Data Science

Multi faceted data exploration in the browser using Leaflet and amCharts
3 May 2020, Towards Data Science

provided by Google News

FairCom kicks off new era of database technology USA - English
10 November 2020, PR Newswire

World's First Converged IIoT Hub to be Showcased at IoT Tech Expo
3 September 2021, Automation.com

provided by Google News

LokiJS - A JavaScript Database
18 November 2014, iProgrammer

provided by Google News

There are lots of ways to put a database in the cloud – here's what to consider
15 September 2023, The Register

FerretDB goes GA: Gives you MongoDB, without the MongoDB...
15 May 2023, The Stack

The essential guide to MongoDB security
2 February 2017, InfoWorld

The Case Against the Server Side Public License (SSPL)
11 October 2022, The New Stack

Supercharge your Amazon RDS for MySQL deployment with ProxySQL and Percona Monitoring and Management ...
12 October 2018, AWS Blog

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here