Re:Timescale Announces New Database Cloud
by CameronNemo on Wednesday October 06, 2021 @02:20AM
(#28769829)
There are a lot of interesting postgres front ends that could be useful. Supabase, metabase, postgrest, hasura.
Of course grafana too, but that goes beyond just PostgreSQL.
Re:Timescale Announces New Database Cloud
by Aarvay on Wednesday October 06, 2021 @04:11AM
(#28770461)
Unfortunately Timescale's license is the blocker - https://news.ycombinator.com/item?id=25299128
Re:Timescale Announces New Database Cloud
by kiwicopple on Wednesday October 06, 2021 @06:08AM
(#28771196)
yes, we'd love to offer Timescale as an extension, but still waiting for buy-in from the Timescale team on this.
If we can't manage we'll eventually do something else for timeseries data - eg, we could do a Foreign Data Wrapper to Clickhouse tables
Re:Timescale Announces New Database Cloud
by qoega on Wednesday October 06, 2021 @06:28AM
(#28771350)
Why use FDW if you can work with ClickHouse directly? What is the use case?
By the way I can see there are some already but I do not use them https://github.com/Infinidat/infi.clickhouse_fdw/ https://github.com/adjust/clickhouse_fdw
Re:Timescale Announces New Database Cloud
by kiwicopple on Wednesday October 06, 2021 @07:23AM
(#28771756)
> Why use FDW
It would be beneficial to couple transactional data (Postgres) with OLAP data (CH). There are a few other things coming in PG which might mitigate the need for CH too (pluggable storage, zheap), so we're not going to rush this part.
Supabase as an add on to Timescale Cloud or Timescale as a supported alternate provider for Supabase would be compelling for get-it-done devs and teams out there