DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ArcadeDB vs. Atos Standard Common Repository vs. ClickHouse vs. Lovefield vs. SQL.JS

System Properties Comparison ArcadeDB vs. Atos Standard Common Repository vs. ClickHouse vs. Lovefield vs. SQL.JS

Editorial information provided by DB-Engines
NameArcadeDB  Xexclude from comparisonAtos Standard Common Repository  Xexclude from comparisonClickHouse  Xexclude from comparisonLovefield  Xexclude from comparisonSQL.JS  Xexclude from comparison
This system has been discontinued and will be removed from the DB-Engines ranking.
DescriptionFast and scalable multi-model DBMS, originally forked from OrientDB but most of the code has been rewrittenHighly scalable database system, designed for managing session and subscriber data in modern mobile communication networksA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.Embeddable relational database for web apps written in pure JavaScriptPort of SQLite to JavaScript
Primary database modelDocument store
Graph DBMS
Key-value store
Time Series DBMS infoin next version
Document store
Key-value store
Relational DBMSRelational DBMSRelational DBMS
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.10
Rank#358  Overall
#48  Document stores
#38  Graph DBMS
#52  Key-value stores
#35  Time Series DBMS
Score15.55
Rank#38  Overall
#23  Relational DBMS
Score0.33
Rank#286  Overall
#131  Relational DBMS
Score0.63
Rank#241  Overall
#112  Relational DBMS
Websitearcadedb.comatos.net/en/convergence-creators/portfolio/standard-common-repositoryclickhouse.comgoogle.github.io/­lovefieldsql.js.org
Technical documentationdocs.arcadedb.comclickhouse.com/­docsgithub.com/­google/­lovefield/­blob/­master/­docs/­spec_index.mdsql.js.org/­documentation/­index.html
DeveloperArcade DataAtos Convergence CreatorsClickhouse Inc.GoogleAlon Zakai infoenhancements implemented by others
Initial release20212016201620142012
Current releaseSeptember 20211703v24.4.1.2088-stable, May 20242.1.12, February 2017
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialOpen Source infoApache 2.0Open Source infoApache 2.0Open Source
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.
  • ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.
  • Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
Implementation languageJavaJavaC++JavaScriptJavaScript
Server operating systemsAll OS with a Java VMLinuxFreeBSD
Linux
macOS
server-less, requires a JavaScript environment (browser, Node.js) infotested with Chrome, Firefox, IE, Safariserver-less, requires a JavaScript environment (browser, Node.js)
Data schemeschema-freeSchema and schema-less with LDAP viewsyesyesyes
Typing infopredefined data types such as float or dateyesoptionalyesyesyes
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.noyesnonono
Secondary indexesyesyesyesyes
SQL infoSupport of SQLSQL-like query language, no joinsnoClose to ANSI SQL (SQL/JSON + extensions)SQL-like query language infovia JavaScript builder patternyes infoSQL-92 is not fully supported
APIs and other access methodsJDBC
MongoDB API
OpenCypher
PostgreSQL wire protocol
Redis API
RESTful HTTP/JSON API
TinkerPop Gremlin
LDAPgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
JavaScript API
Supported programming languagesJavaAll languages with LDAP bindingsC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Rust
Scala info3rd party library
JavaScriptJavaScript
Server-side scripts infoStored proceduresnoyesnono
TriggersyesnoUsing read-only observersno
Partitioning methods infoMethods for storing different data on different nodesSharding infocell divisionkey based and customnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.nonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configurationImmediate Consistencynone
Foreign keys infoReferential integrityyes inforelationship in graphsnonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDAtomic execution of specific operationsnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes, by using IndexedDB or the cloud service Firebase Realtime Databaseno infoexcept by serializing a db to a file
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes infousing MemoryDByes
User concepts infoAccess controlLDAP bind authenticationAccess rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.nono

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
3rd partiesAiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» more

DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more

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

More resources
ArcadeDBAtos Standard Common RepositoryClickHouseLovefieldSQL.JS
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

Why Clickhouse Should Be Your Next Database
6 July 2023, The New Stack

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28 November 2023, AWS Blog

Intel Xeon 6766E/6780E Sierra Forest vs. Ampere Altra Performance & Power Efficiency Review
5 June 2024, Phoronix

A 1000x Faster Database Solution: ClickHouse’s Aaron Katz
1 November 2023, GrowthCap

From Open Source to SaaS: the Journey of ClickHouse
16 January 2024, InfoQ.com

provided by Google News

9 Best JavaScript and TypeScript ORMs for 2024 — SitePoint
22 March 2023, SitePoint

Execute millions of SQL statements in milliseconds in the browser with WebAssembly and Web Workers.
14 January 2017, hackernoon.com

SQLite On The Web: Absurd-sql
24 August 2021, Hackaday

In Praise Of SQLite
28 July 2022, iProgrammer

10 Low-Code Rules for Serious Coders
21 November 2022, Embedded Computing Design

provided by Google News



Share this page

Featured Products

Neo4j logo

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

Milvus logo

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

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

Present your product here