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 > BaseX vs. Citus vs. Ehcache vs. GeoSpock vs. SpatiaLite

System Properties Comparison BaseX vs. Citus vs. Ehcache vs. GeoSpock vs. SpatiaLite

Editorial information provided by DB-Engines
NameBaseX  Xexclude from comparisonCitus  Xexclude from comparisonEhcache  Xexclude from comparisonGeoSpock  Xexclude from comparisonSpatiaLite  Xexclude from comparison
GeoSpock seems to be discontinued. Therefore it will be excluded from the DB-Engines ranking.
DescriptionLight-weight Native XML DBMS with support for XQuery 3.0 and interactive GUI.Scalable hybrid operational and analytics RDBMS for big data use cases based on PostgreSQLA widely adopted Java cache with tiered storage optionsSpatial and temporal data processing engine for extreme data scaleSpatial extension of SQLite
Primary database modelNative XML DBMSRelational DBMSKey-value storeRelational DBMSSpatial DBMS
Secondary database modelsDocument storeTime Series DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.84
Rank#135  Overall
#4  Native XML DBMS
Score2.15
Rank#117  Overall
#56  Relational DBMS
Score4.64
Rank#68  Overall
#8  Key-value stores
Score1.63
Rank#146  Overall
#3  Spatial DBMS
Websitebasex.orgwww.citusdata.comwww.ehcache.orggeospock.comwww.gaia-gis.it/­fossil/­libspatialite/­index
Technical documentationdocs.basex.orgdocs.citusdata.comwww.ehcache.org/­documentationwww.gaia-gis.it/­gaia-sins/­spatialite_topics.html
DeveloperBaseX GmbHTerracotta Inc, owned by Software AGGeoSpockAlessandro Furieri
Initial release2007201020092008
Current release11.0, June 20248.1, December 20183.10.0, March 20222.0, September 20195.0.0, August 2020
License infoCommercial or Open SourceOpen Source infoBSD licenseOpen Source infoAGPL, commercial license also availableOpen Source infoApache Version 2; commercial licenses availablecommercialOpen Source infoMPL 1.1, GPL v2.0 or LGPL v2.1
Cloud-based only infoOnly available as a cloud servicenononoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaCJavaJava, JavascriptC++
Server operating systemsLinux
OS X
Windows
LinuxAll OS with a Java VMhostedserver-less
Data schemeschema-freeyesschema-freeyesyes
Typing infopredefined data types such as float or dateno infoXQuery supports typesyesyesyesyes
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.yes infospecific XML type available, but no XML query functionalitynonono
Secondary indexesyesyesnotemporal, categoricalyes
SQL infoSupport of SQLnoyes infostandard, with numerous extensionsnoANSI SQL for query only (using Presto)yes
APIs and other access methodsJava API
RESTful HTTP API
RESTXQ
WebDAV
XML:DB
XQJ
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
JCacheJDBC
Supported programming languagesActionscript
C
C#
Haskell
Java
JavaScript infoNode.js
Lisp
Perl
PHP
Python
Qt
Rebol
Ruby
Scala
Visual Basic
.Net
C
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Java
Server-side scripts infoStored proceduresyesuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.nonono
Triggersyes infovia eventsyesyes infoCache Event Listenersnoyes
Partitioning methods infoMethods for storing different data on different nodesnoneShardingSharding infoby using Terracotta ServerAutomatic shardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneSource-replica replication infoother methods possible by using 3rd party extensionsyes infoby using Terracotta Servernone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyTunable Consistency (Strong, Eventual, Weak)Immediate Consistency
Foreign keys infoReferential integritynoyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datamultiple readers, single writerACIDyes infosupports JTA and can work as an XA resourcenoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyes infousing a tiered cache-storage approachyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesnoyes
User concepts infoAccess controlUsers with fine-grained authorization concept on 4 levelsfine grained access rights according to SQL-standardnoAccess rights for users can be defined per tableno

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
BaseXCitusEhcacheGeoSpockSpatiaLite
DB-Engines blog posts

Spatial database management systems
6 April 2021, Matthias Gelbmann

show all

Recent citations in the news

XML Injection Attacks: What to Know About XPath, XQuery, XXE & More
18 May 2022, Hashed Out by The SSL Storeā„¢

9 Skills You Need to Become a Data Engineer
2 November 2022, KDnuggets

provided by Google News

Ubicloud wants to build an open source alternative to AWS
5 March 2024, TechCrunch

Ubicloud reels in $16M for its open-source cloud platform
5 March 2024, SiliconANGLE News

Microsoft acquires Citus Data, re-affirming its commitment to Open Source and accelerating Azure PostgreSQL ...
24 January 2019, blogs.microsoft.com

Distributed PostgreSQL Benchmarks: Azure Cosmos DB, CockroachDB, and YugabyteDB
8 July 2023, InfoQ.com

Microsoft Benchmarks Distributed PostgreSQL DBs
10 July 2023, Datanami

provided by Google News

Scaling Australia's Most Popular Online News Sites with Ehcache
6 December 2010, InfoQ.com

Atlassian asks customers to patch critical Jira vulnerability
22 July 2021, BleepingComputer

Critical Jira Flaw in Atlassian Could Lead to RCE
22 July 2021, Threatpost

DZone Coding Java JBoss 5 to 7 in 11 steps
9 January 2014, dzone.com

provided by Google News

How GeoSpock is supercharging geospatial analytics
23 February 2021, ComputerWeekly.com

nChain Leads Investment Round in Extreme-scale Data Firm GeoSpock
2 October 2020, AlexaBlockchain

Imagining an 'Everything Connected' World With Geospock | AWS Startups Blog
20 June 2019, AWS Blog

GeoSpock launches Spatial Big Data Platform 2.0
4 September 2019, VanillaPlus

GeoSpock launches pioneering new spatial Big Data platform
27 February 2019, Geospatial World

provided by Google News



Share this page

Featured Products

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

Neo4j logo

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

Present your product here