News for hackers. Stuff that matters.
Re:Timescale raises $16M from Benchmark, NEA, Two Sigma Vent... by mfreed on Wednesday January 24, 2018 @11:04AM (#16223713)
Influx is a NoSQL, non-relational database, written from scratch, that optimizes for properties like higher compression and column scans for specific label sets. While it supports something SQL-ish, the query language is fairly limited, and I think they are moving further away to a more declarative, non-SQL language.

On the other hand, TimescaleDB has figured out how to re-engineer PostgreSQL to make it scale for time-series data. In doing so, it:

- Supports full SQL, including complex WHERE predicates, secondary indexes, non-time based aggregates, sub-queries, window functions, CTEs, etc.

- Allows you to store regular relational tables alongside your time-series data and perform arbitrary JOINS.

- Supports both full schema-tized and JSON/JSONB data models.

- Inherits the full ecosystem of Postgres (visualization like Tableau or Grafana, ORMs like Ruby and Django, connectors like Kafka, etc.). If it speaks to Postgres, it speaks to TimescaleDB.

- Also works with other Postgres extensions, including things like postgis for geo-spatial analysis.

- Enjoys the reliability of Postgres, including streaming replication for HA, clustered read replicas, point-in-time recovery, incremental backups, etc.

For more details: http://docs.timescale.com/

There are no comments on this comment yet.