DB-EnginesExtremeDB: the hard real time dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > LokiJS vs. QuestDB vs. Sadas Engine vs. SAP SQL Anywhere

System Properties Comparison LokiJS vs. QuestDB vs. Sadas Engine vs. SAP SQL Anywhere

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameLokiJS  Xexclude from comparisonQuestDB  Xexclude from comparisonSadas Engine  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparison
DescriptionIn-memory JavaScript DBMSA high performance open source SQL database for time series dataSADAS Engine is a columnar DBMS specifically designed for high performance in Data warehouse environmentsRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelDocument storeTime Series DBMSRelational DBMSRelational DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.57
Rank#228  Overall
#34  Document stores
Score1.19
Rank#161  Overall
#12  Time Series DBMS
Score0.00
Rank#354  Overall
#152  Relational DBMS
Score5.61
Rank#72  Overall
#40  Relational DBMS
Websitegithub.com/­techfort/­LokiJSquestdb.iowww.sadasengine.comwww.sap.com/­products/­sql-anywhere.html
Technical documentationtechfort.github.io/­LokiJSquestdb.io/­docs/­introductionwww.sadasengine.com/­index.php/­downloads/­documentation-columnar-dbhelp.sap.com/­sql-anywhere
DeveloperQuestDB LimitedSADAS s.r.l.SAP infoformerly Sybase
Initial release2014201420061992
Current release8.017, July 2015
License infoCommercial or Open SourceOpen SourceOpen Source infoApache 2.0commercial infofree trial version availablecommercial
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScriptJavaC++
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)Linux
macOS
Windows
AIX
Linux
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemeschema-freeyes infoschema-free via InfluxDB Line Protocolyesyes
Typing infopredefined data types such as float or datenoyesyesyes
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.nononoyes
Secondary indexesyes infovia viewsnoyesyes
SQL infoSupport of SQLnoSQL-like query languageyesyes
APIs and other access methodsJavaScript APIHTTP REST
InfluxDB Line Protocol (TCP/UDP)
JDBC
JDBC
ODBC
Proprietary protocol
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesJavaScriptC infoPostgreSQL driver
C++
Go
Java
JavaScript (Node.js)
Python
Rust infoover HTTP
.Net
C
C#
C++
Groovy
Java
PHP
Python
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresView functions in JavaScriptnonoyes, in C/C++, Java, .Net or Perl
Triggersyesnonoyes
Partitioning methods infoMethods for storing different data on different nodesnonehorizontal partitioning (by timestamps)horizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneConfigurable consistency for N replicasnoneSource-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoatomic operations within a single collection possibleACID for single-table writesACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infoSerialization of a DB in a Node.JS/Cordova/PhoneGap environment. Usage of the IndexedDB-API in a browser.yesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infothrough memory mapped filesyes infomanaged by 'Learn by Usage'yes
User concepts infoAccess controlnoAccess rights for users, groups and roles according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
LokiJSQuestDBSadas EngineSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
Specific characteristicsRelational model with native time series support Column based storage and time partitioned...
» more
Competitive advantagesReal-time data ingestion and istant SQL queries for time series High performance...
» more
Typical application scenariosApplication metrics Financial market data and algo trading DevOps monitoring Real-time...
» more
Licensing and pricing modelsApache 2.0.
» more
News

QuestDB's multi-threaded SQL filters compared to Clickhouse and TimescaleDB
26 May 2022

QuestDB 6.3 Release Highlights
9 May 2022

Time Series Data Analytics with QuestDB and Cube
26 April 2022

Demo of live crypto data streamed with QuestDB and Grafana
12 April 2022

Calling on our community members to help us support Ukraine
7 March 2022

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
LokiJSQuestDBSadas EngineSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
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

LokiJS - A JavaScript Database
18 November 2014, iProgrammer

Fast, Lightweight Data Storage for Cordova Apps with LokiJS
26 January 2016, SitePoint

provided by Google News

QuestDB snares $12M Series A with hosted version coming soon
3 November 2021, TechCrunch

Read the Pitch Deck Database Startup QuestDB Used to Raise $12 Million
11 November 2021, Business Insider

Build a Real-time Stock Price Dashboard With Python, QuestDB and Plotly
6 November 2021, hackernoon.com

QuestDB nabs $2.3M seed to build open source time series database
2 July 2020, TechCrunch

Q&A: Nicolas Hourcard, QuestDB: The advantages of a time-series database
3 December 2020, Developer News

provided by Google News

SAP SQL Anywhere
21 March 2022, TechTarget

SAP gives SQL Anywhere a new IoT injection
16 July 2015, Computerworld

Top Data Management Platforms & Systems 2022 | ESF
22 July 2021, Enterprise Storage Forum

AWS, GCP, Oracle, Azure, SAP lead cloud DBMS market: Gartner
15 February 2022, CRN Australia

SAP administration / development Definitions - SearchSAP
21 March 2022, TechTarget

provided by Google News

Job opportunities

Product Manager
NXLog, Remote

Developer Relations Engineer
QuestDB, United States

Senior Backend Engineer (Python)
QuestDB, United States

Core Database Engineer
QuestDB, United States

Cloud Engineer
QuestDB, United States

Software Engineer III
Live Nation, Chantilly, VA

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Neo4j logo

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

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here