timescale/timescaledb on Hacker News

There’s an issue tracking TimescaleDB JSONB compression: https://github.com/timescale/timescaledb/issues/2978

comment by PaulWaldman · 2026-06-15 · in How TimescaleDB compresses time-series data

Also https://github.com/timescale/timescaledb I've found it very useful for storing geospatial data over time.

comment by Zambyte · 2026-05-08 · in GeoJSON

Even for timeseries there is https://github.com/timescale/timescaledb . Haven't used it, just knew it existed.

comment by freilanzer · 2025-05-15 · in Migrating to Postgres

…2 https://github.com/hydradatabase/columnar/blob/v1.1.2/LICENS... - Timescale is mostly Apache 2 https://github.com/timescale/timescaledb/blob/2.18.2/LICENSE

comment by mdaniel · 2025-02-23 · in Reliably replicating data between Postgres and ClickHouse

…like[1] or[2]. [1] https://github.com/lemire/FastPFor/blob/master/headers/simpl... [2] https://github.com/timescale/timescaledb/blob/403782a5899c75...

comment by jcgrillo · 2024-10-24 · in Everything I built with Claude Artifacts this week

> based on the time period Is it the kind of thing where the TimescaleDB extension would make sense? https://github.com/timescale/timescaledb

comment by justinclift · 2024-09-11 · in K1 Buys MariaDB

▲ 1

TimescaleDB: PostgreSQL Extension for Fast Time-Series Data

story by CatalystCoder · 2024-08-11 · 0 comments

Compression and other features use the non-Apache license: https://github.com/timescale/timescaledb/tree/main/tsl

comment by pmeira · 2024-05-21 · in pg_timeseries: Open-source time-series extension for PostgreSQL

…red flags in the apache variant of timescale, just constant pleading to try their hosted option. https://github.com/timescale/timescaledb/blob/main/LICENSE-A...

comment by eyegor · 2024-05-21 · in pg_timeseries: Open-source time-series extension for PostgreSQL

▲ 2

TimescaleDB: An open-source time-series SQL database

story by tosh · 2024-02-06 · 0 comments

…or petabyte range, then you probably need something like a distributed VictoriaMetrics setup. https://github.com/timescale/timescaledb

comment by tutfbhuf · 2024-02-06 · in PostgreSQL is enough

…you did something like create table xyz(...) using orioledb; select create_hypertable(xyz, ts); [0] https://github.com/timescale/timescaledb

comment by eyegor · 2023-07-16 · in PostgreSQL: No More Vacuum, No More Bloat

…https://github.com/Logflare/logflare_logger_backend [3]: https://github.com/citusdata/citus [4]: https://github.com/timescale/timescaledb edit: Ah looks like Chase answered as well :)

comment by lyziinc · 2023-04-11 · in Supabase Logs: open-source logging server

As far as I know, this is v2 of https://github.com/timescale/timescaledb

comment by yencabulator · 2022-11-16 · in Bottomless, consumption-based storage for PostgreSQL built on Amazon S3

I do want to note Timescale's license is extremely generous: https://github.com/timescale/timescaledb/blob/main/tsl/LICEN... There's a marked difference between what they allow you vs Mongo (SSPL) and Elastic (Elastic license) -- see (b).…

comment by hardwaresofton · 2022-10-17 · in The Dead End

…"readonly" database :( Update/delete of current chunk data blocked during compression of old data https://github.com/timescale/timescaledb/issues/4432

comment by maierru · 2022-09-22 · in TimescaleDB 2.7 vs. PostgreSQL 14

…as a postgres extension, there's a GitHub project here if anyone is interested to check in on that https://github.com/timescale/timescaledb

comment by LoriP · 2022-07-27 · in SQLite Internals: Pages and B-trees

…creating a second continuous aggregate! If you haven't checked them out, please do! [2][3] [1]: https://github.com/timescale/timescaledb/issues/1400 [2]: https://www.timescale.com/blog/introducing-hyperfunctions-ne... [3]:…

comment by ryanbooz · 2022-06-21 · in How we made data aggregation on PostgreSQL better and faster

I appreciate the response! Here is the github issue https://github.com/timescale/timescaledb/issues/1446

comment by fourseventy · 2022-02-23 · in Timescale raises $110M Series C

Thanks for letting me know. Have you filed a Github issue? If so, could you point me to it? Thanks! https://github.com/timescale/timescaledb

comment by akulkarni · 2022-02-23 · in Timescale raises $110M Series C

…growing the teams aggressively! Fully remote & global. https://www.timescale.com/careers -- [0] https://github.com/timescale/timescaledb [1] https://www.timescale.com/blog/function-pipelines-building-f... [2]…

comment by mfreed · 2022-02-22 · in Timescale raises $110M Series C

Closed source? https://github.com/timescale/timescaledb/tree/master/tsl/src...

comment by Croftengea · 2021-11-03 · in TimescaleDB vs ClickHouse

…move nearly as fast. [1]: https://blog.timescale.com/blog/introducing-hyperfunctions-n... [2]: https://github.com/timescale/timescaledb-toolkit [3]: https://github.com/timescale/timescaledb [4]: https://github.com/zombodb/pgx

comment by djk447 · 2021-10-19 · in Function pipelines: Building functional programming into PostgreSQL

…or services"), this license wouldn't apply for non-Timescale code. [Timescale co-founder here] [0] https://github.com/timescale/timescaledb/blob/master/NOTICE

comment by mfreed · 2021-09-20 · in ClickHouse, Inc.

…was originally connected to the fact that they hypercubes as part of the partitioning logic: https://github.com/timescale/timescaledb/blob/master/src/hyp... Over time, that connection sort of got lost in favor of hypertables just being…

comment by djk447 · 2021-07-27 · in What time-weighted averages are and why you should care

…this can help find a good balance between stability and velocity, but feedback welcome! [1] https://github.com/timescale/timescaledb/releases/tag/0.11.0 [2] https://github.com/timescale/timescale-analytics/tree/main/e...

comment by mfreed · 2021-05-05 · in TimescaleDB raises $40M

…A good reference point for this to check out the `multinode` label in their github issues. https://github.com/timescale/timescaledb/labels/multinode One of the big items that stood out to me is the inability to be able to migrate data from…

comment by spmurrayzzz · 2021-05-05 · in TimescaleDB raises $40M

…more prominent): Apache-2 licensed binaries can be built by passing -DAPACHE_ONLY=1 to bootstrap. https://github.com/timescale/timescaledb

comment by akulkarni · 2021-04-21 · in Grafana, Loki, and Tempo will be relicensed to AGPLv3

…to build it yourself. It's important to us and we'll focus on completing that integration soon! https://github.com/timescale/timescaledb/pull/2498

comment by ryanbooz · 2020-12-03 · in TimescaleDB vs. Amazon Timestream

Except timescaledb is open source: https://github.com/timescale/timescaledb

comment by rattray · 2020-12-03 · in TimescaleDB vs. Amazon Timestream

Can you elaborate on what you mean by TimescaleDB not being open source? https://github.com/timescale/timescaledb

comment by grzm · 2020-11-10 · in InfluxDB is betting on Rust and Apache Arrow for next-gen data store

…that are built with timescale underneath but not offer the product itself as a service. [1]: https://github.com/timescale/timescaledb/blob/master/tsl/LIC...

comment by spockz · 2020-11-09 · in No More Free Work from Marak: Pay Me or Fork This

…:) Anyway, here's the link to license pointers in github, and you can find all code there: https://github.com/timescale/timescaledb/blob/master/LICENSE Source code in this repository is variously licensed under the Apache License Version…

comment by mfreed · 2020-09-26 · in An update to the Timescale license

…is a good thing! All of our source code (both Apache-2 and TSL) has always been public on github: https://github.com/timescale/timescaledb

comment by mfreed · 2020-09-24 · in An update to the Timescale license

…fact, I just tried it and it works. However, it currently requires an unmerged PR to work properly: https://github.com/timescale/timescaledb/pull/2082 , as well as further testing.

comment by enordstr · 2020-07-22 · in ListenBrainz moves to TimescaleDB

…is successfully dumped. also i can see the constraints, indexes are also copied successfully." https://github.com/timescale/timescaledb/issues/1835

comment by akulkarni · 2020-07-22 · in ListenBrainz moves to TimescaleDB

…is successfully dumped. also i can see the constraints, indexes are also copied successfully." https://github.com/timescale/timescaledb/issues/1835

comment by akulkarni · 2020-07-22 · in ListenBrainz moves to TimescaleDB

…want to love timescaledb, it's great.. except for the minor issue of not being able to back up. https://github.com/timescale/timescaledb/issues/1835

comment by thejosh · 2020-07-22 · in ListenBrainz moves to TimescaleDB

If I'm reading https://github.com/timescale/timescaledb/blob/master/tsl/LIC... right, then for a SaaS company -- not necessarily a database-as-a-service company -- section 3.11 states that SaaS company can't run Data Definition Language…

comment by lahaela · 2020-05-27 · in Multi-node TimescaleDB is now free

…commercial applications on top of Timescale Licensed software (while adhering to the license). [0] https://github.com/timescale/timescaledb/blob/master/tsl/LIC...

comment by akulkarni · 2020-05-22 · in Multi-node TimescaleDB is now free

Absolutely possibly to upstream changes. People have, and we welcome contributions: https://github.com/timescale/timescaledb/blob/master/CONTRIB...

comment by mfreed · 2020-05-22 · in Multi-node TimescaleDB is now free

…Interfaces, in a Timescale Database utilized by such Value Added Products or Services. [def] https://github.com/timescale/timescaledb/blob/master/tsl/LIC... What that means is that if you've defined the Heap schema, you have built the…

comment by mfreed · 2020-05-22 · in Multi-node TimescaleDB is now free

…a huge risk and without further clarification, makes me want to stay far away from TimescaleDB. [0] https://github.com/timescale/timescaledb/blob/master/tsl/LIC...

comment by malisper · 2020-05-22 · in Multi-node TimescaleDB is now free

…effort going in a private branch that had PRs and code review for each of the 226 commits :) https://github.com/timescale/timescaledb/pull/1923/commits

comment by mfreed · 2020-05-22 · in Multi-node TimescaleDB is now free

…of a massive amount of engineering effort over two years, as can be seen in this +67,000 line PR: https://github.com/timescale/timescaledb/pull/1923 We're thrilled to make this free so that more developers can use it.

comment by akulkarni · 2020-05-22 · in Multi-node TimescaleDB is now free

…join is still an open issue in their issue tracker so it is not usable as a time series database. https://github.com/timescale/timescaledb/issues/271

comment by snidane · 2020-05-03 · in Medium-hard SQL interview questions

…continuous aggregates (just on a cursory glance) don’t support stacked aggregates, for example: https://github.com/timescale/timescaledb/issues/1400

comment by benesch · 2020-02-19 · in Materialize: A Streaming Data Warehouse

…go into timescaleDB [2]. [1] https://github.com/real-logic/aeron/wiki/Java-Programming-Gu... [2] https://github.com/timescale/timescaledb

comment by platform · 2020-01-03 · in Apache Pulsar is an open-source distributed pub-sub messaging system

Still waiting for AWS RDS for PostgresSQL to support the TimescaleDB extension, 2 years and counting: https://github.com/timescale/timescaledb/issues/65

comment by hbcondo714 · 2019-08-21 · in Building a distributed time-series database on PostgreSQL

Still waiting for AWS RDS for PostgresSQL to support the TimescaleDB extension, 2 years and counting: https://github.com/timescale/timescaledb/issues/65

comment by hbcondo714 · 2019-07-10 · in Amazon Aurora with PostgreSQL Compatibility Supports Serverless