DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Dragonfly vs. GeoMesa vs. PostgreSQL vs. SingleStore vs. TerarkDB

System Properties Comparison Dragonfly vs. GeoMesa vs. PostgreSQL vs. SingleStore vs. TerarkDB

Editorial information provided by DB-Engines
NameDragonfly  Xexclude from comparisonGeoMesa  Xexclude from comparisonPostgreSQL  Xexclude from comparisonSingleStore infoformer name was MemSQL  Xexclude from comparisonTerarkDB  Xexclude from comparison
DescriptionA drop-in Redis replacement that scales vertically to support millions of operations per second and terabyte sized workloads, all on a single instanceGeoMesa is a distributed spatio-temporal DBMS based on various systems as storage layer.Widely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQLMySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table typeA key-value store forked from RocksDB with advanced compression algorithms. It can be used standalone or as a storage engine for MySQL and MongoDB
Primary database modelKey-value storeSpatial DBMSRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.Relational DBMSKey-value store
Secondary database modelsDocument store
Graph DBMS infowith Apache Age
Spatial DBMS
Vector DBMS infowith pgvector extension
Document store
Spatial DBMS
Time Series DBMS
Vector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.49
Rank#261  Overall
#38  Key-value stores
Score0.86
Rank#205  Overall
#4  Spatial DBMS
Score636.25
Rank#4  Overall
#4  Relational DBMS
Score5.38
Rank#62  Overall
#35  Relational DBMS
Score0.08
Rank#367  Overall
#56  Key-value stores
Websitegithub.com/­dragonflydb/­dragonfly
www.dragonflydb.io
www.geomesa.orgwww.postgresql.orgwww.singlestore.comgithub.com/­bytedance/­terarkdb
Technical documentationwww.dragonflydb.io/­docswww.geomesa.org/­documentation/­stable/­user/­index.htmlwww.postgresql.org/­docsdocs.singlestore.combytedance.larkoffice.com/­docs/­doccnZmYFqHBm06BbvYgjsHHcKc
DeveloperDragonflyDB team and community contributorsCCRi and othersPostgreSQL Global Development Group infowww.postgresql.org/­developerSingleStore Inc.ByteDance, originally Terark
Initial release202320141989 info1989: Postgres, 1996: PostgreSQL20132016
Current release1.0, March 20235.0.0, May 202416.3, May 20248.5, January 2024
License infoCommercial or Open SourceOpen Source infoBSL 1.1Open Source infoApache License 2.0Open Source infoBSDcommercial infofree developer edition availablecommercial inforestricted open source version available
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.
  • PostgreSQL Flex @ STACKIT offers managed PostgreSQL Instances with adjustable CPU, RAM, storage amount and speed and several extensions available, in enterprise grade to perfectly match all application requirements. All 100% GDPR-compliant.
  • Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
SingleStoreDB Cloud: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilities
Implementation languageC++ScalaCC++, GoC++
Server operating systemsLinuxFreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Linux info64 bit version required
Data schemescheme-freeyesyesyesschema-free
Typing infopredefined data types such as float or datestrings, hashes, lists, sets, sorted sets, bit arraysyesyesyesno
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.nonoyes infospecific XML-type available, but no XML query functionality.nono
Secondary indexesnoyesyesyesno
SQL infoSupport of SQLnonoyes infostandard with numerous extensionsyes infobut no triggers and foreign keysno
APIs and other access methodsProprietary protocol infoRESP - REdis Serialization ProtocolADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Cluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
MongoDB API
ODBC
C++ API
Java API
Supported programming languagesC
C#
C++
Clojure
D
Dart
Elixir
Erlang
Go
Haskell
Java
JavaScript (Node.js)
Lisp
Lua
Objective-C
Perl
PHP
Python
R
Ruby
Rust
Scala
Swift
Tcl
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Bash
C
C#
Java
JavaScript (Node.js)
Python
C++
Java
Server-side scripts infoStored proceduresLuanouser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.yesno
Triggerspublish/subscribe channels provide some trigger functionalitynoyesnono
Partitioning methods infoMethods for storing different data on different nodesdepending on storage layerpartitioning by range, list and (since PostgreSQL 11) by hashSharding infohash partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationdepending on storage layerSource-replica replication infoother methods possible by using 3rd party extensionsSource-replica replication infostores two copies of each physical data partition on two separate nodesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnono infocan define user-defined aggregate functions for map-reduce-style calculationsno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistencydepending on storage layerImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of command blocks and scriptsnoACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayes, strict serializability by the serveryesyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesyesyesyes infoAll updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.yes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesdepending on storage layernoyesyes
User concepts infoAccess controlPassword-based authenticationyes infodepending on the DBMS used for storagefine grained access rights according to SQL-standardFine grained access control via users, groups and rolesno
More information provided by the system vendor
DragonflyGeoMesaPostgreSQLSingleStore infoformer name was MemSQLTerarkDB
Specific characteristicsSingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» more
Competitive advantagesSingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» more
Typical application scenariosDriving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» more
Key customersIEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» more
Market metricsCustomers in various industries worldwide including US and International Industry...
» more
Licensing and pricing modelsF ree Tier and Enterprise Edition
» 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 partiespgDash: In-Depth PostgreSQL Monitoring.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
» more

Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today!
» more

SharePlex is the reliable and affordable data replication solution for PostgreSQL migrations, high availability and more.
» more

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
» more

Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
» more

Instaclustr: Fully Hosted & Managed PostgreSQL
» more

Redgate webinars: A series of key topics for new PostgreSQL users.
» more

CYBERTEC is your professional partner in PostgreSQL topics for over 20 years. As our main aim is to be your single-source all-in-one IT service provider, we offer a wide range of products and services. Visit our website for more details.
» more

Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
» more

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

More resources
DragonflyGeoMesaPostgreSQLSingleStore infoformer name was MemSQLTerarkDB
DB-Engines blog posts

Spatial database management systems
6 April 2021, Matthias Gelbmann

show all

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Turbocharge Your Application Development Using WebAssembly With SingleStoreDB
17 October 2022,  Akmal Chaudhri, SingleStore (sponsor) 

Cloud-Based Analytics With SingleStoreDB
9 June 2022,  Akmal Chaudhri, SingleStore (sponsor) 

SingleStore: The Increasing Momentum of Multi-Model Database Systems
14 February 2022,  Akmal Chaudhri, SingleStore (sponsor) 

show all

Recent citations in the news

DragonflyDB Announces $21m in New Funding and General Availability
21 March 2023, Business Wire

DragonflyDB reels in $21M for its speedy in-memory database
21 March 2023, SiliconANGLE News

DragonflyDB Raises $21M in Funding
21 March 2023, FinSMEs

Dragonfly 1.0 Released For What Claims To Be The World's Fastest In-Memory Data Store
20 March 2023, Phoronix

Intel Linux Kernel Optimizations Show Huge Benefit For High Core Count Servers
29 March 2023, Phoronix

provided by Google News

Timescale unveils high-performance AI vector database extensions for PostgreSQL
11 June 2024, SiliconANGLE News

PostgreSQL is Now Faster than Pinecone, 75% Cheaper, with New Open Source Extensions
11 June 2024, PR Newswire

PostgreSQL Tutorial: Definition, Commands, & Features
4 June 2024, Simplilearn

Raise the bar on AI-powered app development with Azure Database for PostgreSQL
5 June 2024, Microsoft

A New Era AI Databases: PostgreSQL with pgvectorscale Outperforms Pinecone and Cuts Costs by 75% with New Open-Source Extensions
12 June 2024, MarkTechPost

provided by Google News

Building a Modern Database: Nikita Shamgunov on Postgres and Beyond
18 April 2024, Madrona Venture Group

SingleStore CEO sees little future for purpose-built vector databases
24 January 2024, VentureBeat

SingleStore Announces Real-time Data Platform to Further Accelerate AI, Analytics and Application Development
24 January 2024, Business Wire

SingleStore adds indexed vector search to Pro Max release for faster AI work – Blocks and Files
29 January 2024, Blocks and Files

SingleStore update adds new tools to fuel GenAI, analytics
24 January 2024, TechTarget

provided by Google News

A Chinese company is making the cloud 200x faster · TechNode
3 July 2017, TechNode

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