Links

DB

Couchbase vs CouchDB

Couchbase Server
Apache CouchDB
Topology
Distributed
Replicated
Automatic failover
Yes
No
Integrated cache
Yes
No
Memcached compatible
Yes
No
Query language
Yes, N1QL (SQL for JSON)
No

API Query

key-value

Time Series DBs

Elastic, InfluxDB, MongoDB, Cassandra, Couchbase, Graphite, Prometheus, ClickHouse, OpenTSDB, DalmatinerDB, KairosDB, RiakTS.

TimescaleDB

https://github.com/timescale/timescaledb packaged as a PostgreSQL extension
docker run -d --name timescaledb -p 5432:5432 timescale/timescaledb
CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;
SELECT create_hypertable('conditions', 'time');
-- backgroud:
CREATE INDEX conditions_time_idx
ON public.conditions USING btree
("time" DESC)
TABLESPACE pg_default;
-- additionally partition the data on another
-- dimension (what we call 'space partitioning').
-- E.g., to partition `location` into 4 partitions:
SELECT create_hypertable('conditions', 'time', 'location', 4);
SELECT time_bucket('5 minutes', time) AS time_range,
location, COUNT(*),
MAX(temperature) AS max_temp,
MAX(humidity) AS max_hum
FROM conditions
WHERE time > NOW() - interval '3 hours'
GROUP BY time_range, location
ORDER BY time_range DESC, max_temp DESC;
time_range | location | count | max_temp | max_hum
------------------------+----------+-------+----------+---------
2018-02-23 17:00:00+00 | office | 3 | 70 | 50
2018-02-23 16:35:00+00 | garage | 1 | 77 | 65.2
2018-02-23 16:35:00+00 | office | 2 | 70.1 | 50.1
2018-02-23 16:35:00+00 | basement | 1 | 66.5 | 60
2018-02-23 16:25:00+00 | office | 1 | 70 | 50
(5 rows)

Riak TS

http://docs.basho.com/riak/ts/ Riak TS is a distributed NoSQL key/value store optimized for time series data.
Last modified 1yr ago