DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > GigaSpaces vs. RRDtool vs. SingleStore vs. SQLite

System Properties Comparison GigaSpaces vs. RRDtool vs. SingleStore vs. SQLite

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameGigaSpaces  Xexclude from comparisonRRDtool  Xexclude from comparisonSingleStore infoformer name was MemSQL  Xexclude from comparisonSQLite  Xexclude from comparison
DescriptionHigh performance in-memory data grid platform, powering three products: Smart Cache, Smart ODS (Operational Data Store), Smart Augmented TransactionsIndustry standard data logging and graphing tool for time series data. RRD is an acronym for round-robin database. infoThe data is stored in a circular buffer, thus the system storage footprint remains constant over time.MySQL 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 typeWidely used embeddable, in-process RDBMS
Primary database modelDocument store
Object oriented DBMS infoValues are user defined objects
Time Series DBMSRelational DBMSRelational DBMS
Secondary database modelsGraph DBMS
Search engine
Document store
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.95
Rank#179  Overall
#31  Document stores
#7  Object oriented DBMS
Score2.52
Rank#117  Overall
#7  Time Series DBMS
Score7.03
Rank#62  Overall
#36  Relational DBMS
Score138.87
Rank#10  Overall
#7  Relational DBMS
Websitewww.gigaspaces.comoss.oetiker.ch/­rrdtoolwww.singlestore.comwww.sqlite.org
Technical documentationdocs.gigaspaces.com/­latest/­landing.htmloss.oetiker.ch/­rrdtool/­docdocs.singlestore.comwww.sqlite.org/­docs.html
DeveloperGigaspaces TechnologiesTobias OetikerSingleStore Inc.Dwayne Richard Hipp
Initial release2000199920132000
Current release15.5, September 20201.7.2, May 20197.6, November 20213.39.1  (13 July 2022), July 2022
License infoCommercial or Open SourceOpen Source infoApache Version 2; Commercial licenses availableOpen Source infoGPL V2 and FLOSScommercial infofree developer edition availableOpen Source infoPublic Domain
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.
SingleStore Managed Service: 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 languageJava, C++, .NetC infoImplementations in Java (e.g. RRD4J) and C# availableC++, GoC
Server operating systemsLinux
macOS
Solaris
Windows
HP-UX
Linux
Linux info64 bit version requiredserver-less
Data schemeschema-freeyesyesyes infodynamic column types
Typing infopredefined data types such as float or dateyesNumeric data onlyyesyes infonot rigid because of 'dynamic typing' concept.
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.no infoXML can be used for describing objects metadatano infoExporting into and restoring from XML files possiblenono
Secondary indexesyesnoyesyes
SQL infoSupport of SQLSQL-99 for query and DML statementsnoyes infobut no triggers and foreign keysyes infoSQL-92 is not fully supported
APIs and other access methodsGigaSpaces LRMI
Hibernate
JCache
JDBC
JPA
ODBC
RESTful HTTP API
Spring Data
in-process shared library
Pipes
Cluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
ODBC
ADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
Supported programming languages.Net
C++
Java
Python
Scala
C infowith librrd library
C# infowith a different implementation of RRDTool
Java infowith a different implementation of RRDTool
JavaScript (Node.js) infowith a different implementation of RRDTool
Lua
Perl
PHP infowith a wrapper library
Python
Ruby
Bash
C
C#
Java
JavaScript (Node.js)
Python
Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl
Server-side scripts infoStored proceduresyesnoyesno
Triggersyes, event driven architecturenonoyes
Partitioning methods infoMethods for storing different data on different nodesShardingnoneSharding infohash partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication infosynchronous or asynchronous
Source-replica replication infosynchronous or asynchronous
noneSource-replica replication infostores two copies of each physical data partition on two separate nodesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoMap-Reduce pattern can be built with XAP task executorsnono infocan define user-defined aggregate functions for map-reduce-style calculationsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency infoConsistency level configurable: ALL, QUORUM, ANYnoneImmediate Consistency
Foreign keys infoReferential integritynononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoby using the rrdcached daemonyes, multi-version concurrency control (MVCC)yes infovia file-system locks
Durability infoSupport for making data persistentyesyesyes 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.yesyesyesyes
User concepts infoAccess controlRole-based access controlnoFine grained access control via users, groups and rolesno
More information provided by the system vendor
GigaSpacesRRDtoolSingleStore infoformer name was MemSQLSQLite
Specific characteristicsGigaSpaces, the pioneer of In-Memory Computing , drives enterprise digital transformation...
» more
SingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» more
Competitive advantages​ AI Driven Autonomous Operations – GigaSpaces’ unique AI driven technology simplifies...
» more
SingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» more
Typical application scenariosApplication Acceleration, Smart Caching, BI Acceleration on Fresh Data, Digital Integration...
» more
Driving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» more
Key customersMorgan Stanley, Bank of America, Goldman Sachs, PriceRunner, Cerner, Societe Generale,...
» more
IEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» more
Market metricsForrester has positioned GigaSpaces as a strong performer in The Forrester Wave™:...
» more
Customers in various industries worldwide including US and International Industry...
» more
Licensing and pricing modelsGigaSpaces offers both open source and commercial editions with annual subscriptions....
» more
F 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 partiesNavicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.
» more

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

More resources
GigaSpacesRRDtoolSingleStore infoformer name was MemSQLSQLite
DB-Engines blog posts

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

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

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

Conferences and events

SingleStore: Join the Real-Time Data [r]evolotion
Virtual Event, 13 July 2022 (finished)

Recent citations in the news

Checklist: A Five-Point Data Modernization Roadmap to Consider
1 August 2022, Solutions Review

GigaSpaces Announces Version 16.0 with Breakthrough Data Integration Tools to Ease Enterprises' Digital Transformation Challenges
3 November 2021, PR Newswire

In-Memory Computing Market to Rise at CAGR of 18.4% During Forecast Period (2021-2028) | Latest Analysis By Emergen Research
11 August 2022, Digital Journal

In-Memory Tech at the Heart of Digital Integration Hub
31 January 2022, Datanami

GigaSpaces Embraces Kubernetes Alternative for DataOps
24 April 2020, DevOps.com

provided by Google News

How to install and use RRDTool to speed up MRTG monitoring
24 June 2009, TechTarget

How To Install Cacti monitoring Debian 11 Bullseye
10 March 2022, Linux Shout

NaviSec Discovers Critical Zero-Day Exploit for Cacti Services
9 April 2022, PR Web

How to install lighttpd web server on Debian 11 Bullseye or Ubuntu 20.04
22 October 2021, Linux Shout

provided by Google News

SingleStore on AWS unifies workloads into a single, real-time database
15 July 2022, SiliconANGLE News

SingleStore Reaches Unicorn Status as a Leader in Cloud SQL Database Management
26 July 2022, The Software Report

SingleStore Selects AppDirect to Power Real-Time Marketplace
4 August 2022, Business Wire

Neon nabs $30M to build a scalable cloud service for Postgres databases
26 July 2022, TechCrunch

SingleStore Outshines Major Database Competitors in TCO Study
15 June 2022, Business Wire

provided by Google News

In Praise Of SQLite
28 July 2022, iProgrammer

Never Too Rich Or Thin: Compress Sqlite 80%
1 August 2022, Hackaday

Using SQL & Python — The Pocket Guide | by Dhaval Thakur | Aug, 2022
14 August 2022, Medium

How to Use SQL Databases in a NestJS Application With TypeORM - MUO
30 July 2022, MakeUseOf

Why SQLite may become foundational for digital progress
20 May 2022, VentureBeat

provided by Google News

Job opportunities

Sales Director
GigaSpaces, New York, NY

Pre-Sale Engineer
GigaSpaces, New York, NY

Pre-Sale Engineer
GigaSpaces, New York, NY

Sales Director
GigaSpaces, New York, NY

DevOps Development Engineer
Trax Group, Dallas, TX

Systems Engineer
Domeyard LP, Boston, MA

Technical Support Engineer/Unix Admin
DigiLink, Marina del Rey, CA

Full Stack Lead Developer
Verizon, Irving, TX

Full Stack Lead Developer
Verizon, Temple Terrace, FL

Principal Software Engineer (Prisma Cloud Data Security)
Palo Alto Networks, Santa Clara, CA

Manager Data Interface & Analytics
Western Asset, Pasadena, CA

Oracle PL/SQL Developer
Integration Developer Network LLC, Remote

Full Stack Developer
Web Services, Remote

Software Developer: Delphi
Mackin Book Company, Burnsville, MN

iOS Developers
Broadwave Studios Agency, Los Angeles, CA

Xamarin Developer (100% )
Computer Staff, Remote

Data Science Assistant
United Nations, New York, NY

jobs by Indeed



Share this page

Featured Products

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

The right graph database.
Not a graph add-on.
Free forever.
Start solving 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.

Redis logo

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

Present your product here