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. HarperDB vs. KeyDB vs. Oracle vs. Sqrrl

System Properties Comparison AlaSQL vs. HarperDB vs. KeyDB vs. Oracle vs. Sqrrl

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonHarperDB  Xexclude from comparisonKeyDB  Xexclude from comparisonOracle  Xexclude from comparisonSqrrl  Xexclude from comparison
Sqrrl has been acquired by Amazon and became a part of Amazon Web Services. It has been removed from the DB-Engines ranking.
DescriptionJavaScript DBMS libraryA distributed database focused on speed and ease of use. It has an intuitive REST API, and supports NoSQL and SQL including joins. HarperDB leverages standard interfaces, and users can be up and running in minutes.An ultra-fast, open source Key-value store fully compatible with Redis API, modules, and protocolsWidely used RDBMSAdaptable, secure NoSQL built on Apache Accumulo
Primary database modelDocument store
Relational DBMS
Document storeKey-value storeRelational DBMSDocument store
Graph DBMS
Key-value store
Wide column store
Secondary database modelsDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.60
Rank#226  Overall
#35  Document stores
#110  Relational DBMS
Score0.66
Rank#212  Overall
#31  Document stores
Score0.32
Rank#268  Overall
#40  Key-value stores
Score1281.74
Rank#1  Overall
#1  Relational DBMS
Websitealasql.orgharperdb.iogithub.com/­JohnSully/­KeyDB
keydb.dev
www.oracle.com/­databasesqrrl.com
Technical documentationgithub.com/­agershun/­alasqlharperdb.io/­developers/­documentation/­overviewdocs.keydb.devdocs.oracle.com/­en/­database
DeveloperAndrey Gershun & Mathias R. WulffHarperDBEQ Alpha Technology Ltd.OracleAmazon infooriginally Sqrrl Data, Inc.
Initial release20142017201919802012
Current release3.1, August 202119c, February 2019
License infoCommercial or Open SourceOpen Source infoMIT-Licensecommercial infofree community edition availableOpen Source infoBSD-3commercial inforestricted free version is availablecommercial
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.
HarperDB Cloud: Get To Market Faster, For Less Money Using Our Built-in API.
Implementation languageJavaScriptNode.jsC++C and C++Java
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)Linux
OS X
LinuxAIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Linux
Data schemeschema-freedynamic schemaschema-freeyes infoSchemaless in JSON and XML columnsschema-free
Typing infopredefined data types such as float or datenoyes infoJSON data typespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexesyesyes
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 indexesnoyesyes infoby using the Redis Search moduleyesyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.SQL-like data manipulation statementsnoyes infowith proprietary extensionsno
APIs and other access methodsJavaScript APIJDBC
ODBC
React Hooks
RESTful HTTP/JSON API
WebSocket
Proprietary protocol infoRESP - REdis Serialization ProtocoJDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Accumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
Supported programming languagesJavaScript.Net
C
C#
C++
ColdFusion
D
Dart
Delphi
Erlang
Go
Haskell
Java
JavaScript (Node.js)
Lisp
MatLab
Objective C
Perl
PHP
PowerShell
Prolog
Python
R
Ruby
Rust
Scala
Swift
C
C#
C++
Clojure
Crystal
D
Dart
Elixir
Erlang
Fancy
Go
Haskell
Haxe
Java
JavaScript (Node.js)
Lisp
Lua
MatLab
Objective-C
OCaml
Pascal
Perl
PHP
Prolog
Pure Data
Python
R
Rebol
Ruby
Rust
Scala
Scheme
Smalltalk
Swift
Tcl
Visual Basic
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
Server-side scripts infoStored proceduresnoCustom Functions infosince release 3.1LuaPL/SQL infoalso stored procedures in Java possibleno
Triggersyesnonoyesno
Partitioning methods infoMethods for storing different data on different nodesnoneA table resides as a whole on one (or more) nodes in a clusterShardingSharding, horizontal partitioningSharding infomaking use of Hadoop
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyes infothe nodes on which a table resides can be definedMulti-source replication
Source-replica replication
Multi-source replication
Source-replica replication
selectable replication factor infomaking use of Hadoop
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono infocan be realized in PL/SQLyes
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyEventual Consistency
Strong eventual consistency with CRDTs
Immediate ConsistencyImmediate Consistency infoDocument store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.
Foreign keys infoReferential integrityyesnonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageAtomic execution of specific operationsOptimistic locking, atomic execution of commands blocks and scriptsACID infoisolation level can be parameterizedAtomic updates per row, document, or graph entity
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyes, using LMDByes infoConfigurable mechanisms for persistency via snapshots and/or operations logsyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'
User concepts infoAccess controlnoAccess rights for users and rolessimple password-based access control and ACLfine grained access rights according to SQL-standardCell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)
More information provided by the system vendor
AlaSQLHarperDBKeyDBOracleSqrrl
Specific characteristicsHarperDB is the first distributed database with hybrid SQL & NoSQL functionality...
» more
Competitive advantagesBy combining the functionality of the best SQL, NoSQL, and NewSQL products on the...
» more
Typical application scenariosUse cases where HarperDB is a better fit than other solutions include: Rapid app...
» more
Key customersA few highlighted customers include: US Army, US Airforce, Chelan PUD, TATA, & Lumen....
» more
Market metrics6,800 + npm downloads 1,600 + on Docker Hub 2,600 + cloud & local signups
» more
Licensing and pricing modelsHarperDB follows a freemium/premium model . A database is only as powerful as it...
» more

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
3rd partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» more

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

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

More resources
AlaSQLHarperDBKeyDBOracleSqrrl
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Recent citations in the news

Meet AlaSQL, a speedy SQL database for JavaScript
15 January 2019, JAXenter

provided by Google News

Ori Industries Announces Edgehog Day, Bringing the Latest in Edge Computing
6 December 2021, Business Wire

HarperDB Announces New Custom Functions Feature
21 September 2021, EIN News

Build a Hacker News Clone using React and HarperDB
18 October 2021, SitePoint

Equinix Brings the Latest Arm and AI Technology to Bare Metal Platform for Cloud Builders
7 December 2021, HPCwire

HarperDB: An underdog SQL / NoSQL database
7 February 2018, ZDNet

provided by Google News

MySQL a 'pretty poor database' says departing Oracle engineer
6 December 2021, The Register

Ready for Oracle E-Business Release 12.2 by new year 2022?
7 December 2021, ComputerWeekly.com

Quest Releases SharePlex 10.1.2 to Help Customers Get More
22 November 2021, GlobeNewswire

Sponsored post: How Deutsche Bank stays nimble amid the fintech boom
3 December 2021, TechCrunch

Deloitte acquires Oracle cloud integrator
6 December 2021, Washington Technology

provided by Google News

Amazon's cloud business acquires Sqrrl, a security start-up with NSA roots
23 January 2018, CNBC

AWS beefs up threat detection with Sqrrl acquisition
24 January 2018, TechCrunch

SQRRL: Helping young Indians save and grow their money
25 January 2021, The Financial Express

Amazon Web Services Buys Threat Hunting Startup Sqrrl
24 January 2018, CRN

AWS acquires threat hunting startup Sqrrl
24 January 2018, CyberScoop

provided by Google News

Job opportunities

Applications Developer
Axle Informatics, Rockville, MD

Developer
Axle Informatics, Rockville, MD

Engineering Manager
Akamai, Cambridge, MA

Oracle Database Engineer
NEOGOV, Remote

Oracle PL/SQL Developer
Princeton IT Services, Boston, MA

Oracle PL Developer
Intellibus, Irving, TX

ORACLE DATABASE ADMINISTRATOR
STAND 8, New York, NY

Manual Tester
Sun-Net Inc., Remote

jobs by Indeed



Share this page

Featured Products

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Neo4j logo

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

Present your product here