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 > Amazon SimpleDB vs. SQLite vs. TimescaleDB

System Properties Comparison Amazon SimpleDB vs. SQLite vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonSQLite  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreWidely used embeddable, in-process RDBMSA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelKey-value storeRelational DBMSTime Series DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.94
Rank#123  Overall
#24  Key-value stores
Score133.86
Rank#9  Overall
#6  Relational DBMS
Score4.73
Rank#86  Overall
#5  Time Series DBMS
Websiteaws.amazon.com/­simpledbwww.sqlite.orgwww.timescale.com
Technical documentationdocs.aws.amazon.com/­simpledbwww.sqlite.org/­docs.htmldocs.timescale.com
DeveloperAmazonDwayne Richard HippTimescale
Initial release200720002017
Current release3.42.0  (16 May 2023), May 20232.6.0, February 2022
License infoCommercial or Open SourcecommercialOpen Source infoPublic DomainOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud serviceyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC
Server operating systemshostedserver-lessLinux
OS X
Windows
Data schemeschema-freeyes infodynamic column typesyes
Typing infopredefined data types such as float or datenoyes infonot rigid because of 'dynamic typing' concept.numerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types
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.noyes
Secondary indexesyes infoAll columns are indexed automaticallyyesyes
SQL infoSupport of SQLnoyes infoSQL-92 is not fully supportedyes infofull PostgreSQL SQL syntax
APIs and other access methodsRESTful HTTP APIADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
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
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresnonouser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersnoyesyes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationnoneyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesyesnoneSource-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate Consistency
Foreign keys infoReferential integritynoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes infovia file-system locksyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)nofine grained access rights according to SQL-standard

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

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

show all

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

show all

Recent citations in the news

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed Product On AWS
13 November 2013, TechCrunch

How to Install Adminer on Ubuntu - MUO
18 January 2023, MakeUseOf

How to install Adminer on Ubuntu 22.04 LTS
15 December 2022, linux.how2shout.com

Amazon Goes Back to the Future With 'NoSQL' Database
19 January 2012, WIRED

How to deploy the Adminer database admin tool on Ubuntu Server ...
11 August 2022, TechRepublic

provided by Google News

SQLite 3.42 Released With "Secure Delete" Command
16 May 2023, Phoronix

5 newer data science tools you should be using with Python
17 May 2023, InfoWorld

Relational Databases Software Market International Business ...
24 May 2023, Digital Journal

What Is SQLite? (Definition, Use, Example, Alternatives)
21 December 2022, Built In

How to recover Notes stored on your Mac
20 May 2023, AppleInsider

provided by Google News

Visualizing IoT Data at Scale With Hopara and TimescaleDB
16 May 2023, Embedded Computing Design

New TDengine Benchmark Results Show Up to 37.0x Higher
28 February 2023, GlobeNewswire

Timescale Announces Corporate Rebrand Reflecting Company's ...
17 May 2023, PR Newswire

InfluxDB 3.0 Time-Series Database Released
8 May 2023, iProgrammer

HiveMQ and United Manufacturing Hub Partner to Enable Industry ...
17 May 2023, PR Web

provided by Google News

Job opportunities

RedShift Database Engineer JD
GSB, Remote

Ruby Developer
element^n, New York, NY

PHP Developer
MyPhoneData, San Jose, CA

Laboratory Technical Support Specialist
Labcorp, Burlington, NC

iOS Engineer - Community, Cash App
Cash App, Seattle, WA

iOS Engineer - Community, Cash App
Cash App, New York, NY

System Developer
South Dakota State Government, Pierre, SD

Software Engineer - Data Processing and Machine Learning Platform
Hewlett Packard Enterprise, Andover, MA

Rust Engineers (Multiple Openings) - Remote
Keyrock, Remote

Software Engineer I
AllofE Solutions, Lawrence, KS

Staff Data Engineer, Real Time Analytics and Event Streaming
LTK USA, Dallas, TX

DevOps Engineer
Federal Reserve Bank of New York, New York, NY

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

Cassandra Forward online event

Want to level up your Cassandra game?
If you missed the event or would like to re-watch a session, replays are available now. Watch now!

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

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

Present your product here