Hydra
Data
postgres extension
SHOW HN2023
122points
33comments
#519of 3,109 in 2023
Top 17%of 2023 by points
How HN took it
CuriousMostly questions and neutral comments
2 positive, 16 neutral or asking, 1 mixed, 6 critical, out of 25 comments about the project. Thread score -0.10.
Idea: 1 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful for slow analytical aggregates on Postgres without adding another database
From 2 comments
Congrats on the 1.0 Release, big milestone. I'm personally really excited about all of the recent tooling for postgres aggregates. Definitely a pain point for a lot of developers…
mlenhard on HNI've been using Hydra for the last ~2 months & genuinely love it. The team is really talented & it's so great to see the progress they've been making. Congrats on the 1.0 GA…
garysahota93 on HN
Congratulations on the 1.0 GA release
From 2 comments
I've been using Hydra for the last ~2 months & genuinely love it. The team is really talented & it's so great to see the progress they've been making. Congrats on the 1.0 GA…
garysahota93 on HNCongratulations! Please also add this info : #1. to the pgsql-announce list: https://www.postgresql.org/search/?m=1&ln=pgsql-announce&q=hydra "Your search for hydra returned no…
pella on HN
Objections
Name collides with existing Hydra projects and trademarks
From 2 comments
Nice tool, only unfortunate name, consider changing it. Already very well know security tool named hydra https://github.com/vanhauser-thc/thc-hydra been around since 2001. Then…
iepathos on HNWatch out. There used to be another Hydra project, a data repository with rich linked metadata, that changed its name after legal threat over trademark from Hydra Corporation.…
adultSwim on HN
Extension changes default table type, which was a misunderstanding per maker
From 2 comments
Big congrats on 1.0! Super exciting project. My dream scenario would be installing hydra as an extension into my main rails application database. My usecase is showing analytics…
efxhoy on HNThanks for calling these out, as these are just misunderstandings. We will certainly tweak the language around these. - Installing the extension itself does not change the…
wuputah on HN
Postgres foreign data wrapper features rebranded as Hydra External Tables
From 2 comments
Big congrats on 1.0! Super exciting project. My dream scenario would be installing hydra as an extension into my main rails application database. My usecase is showing analytics…
efxhoy on HNThanks for calling these out, as these are just misunderstandings. We will certainly tweak the language around these. - Installing the extension itself does not change the…
wuputah on HN
Citus fork not disclosed clearly in FAQ
From 1 comment
Big congrats on 1.0! Super exciting project. My dream scenario would be installing hydra as an extension into my main rails application database. My usecase is showing analytics…
efxhoy on HN
Requests
Clarify docs on update and delete support in columnar tables
From 2 comments
> Whenever possible, design data coming into the data warehouse as append-only. Hydra's columnar store only supports inserts. If you need to update or delete data, you will need…
gregwebs on HNthat is not the case at this point. updates, deletes, and vacuuming are all available.
jerrysievert on HN
Add Hydra to pgsql-announce and planet.postgresql.org
From 1 comment
Congratulations! Please also add this info : #1. to the pgsql-announce list: https://www.postgresql.org/search/?m=1&ln=pgsql-announce&q=hydra "Your search for hydra returned no…
pella on HN
Clarify license files in repo
From 1 comment
some previous discussions: https://news.ycombinator.com/item?id=37247945 https://news.ycombinator.com/item?id=36987920 and a relevant observation is that there are actually…
mdaniel on HN
Questions
How to keep heap and columnar tables in sync in real time
From 1 comment
What's the workflow for leveraging this extension in real-time for an existing database? Say I wanted to use this to create a high performance "aggregation" API of my existing…
cjonas on HN
How to add the extension to a Postgres Dockerfile
From 1 comment
> - Installing the extension itself does not change the default table type, this is only the case on Hydra Cloud and our Docker image. Ah cool, thanks! How would I go about…
efxhoy on HN
Whether it works on Azure Flexible Server for Postgres
From 1 comment
I have 2 questions. 1. Is this optimized for constantly adding and removing rows to the columnar table? 2. Is this supported by Microsoft Azure Flexible Server for Postgres?
I_am_tiberius on HN
How sharding works and whether it works with Citus
From 1 comment
How does sharding work? Can I use this with citus to scale horizontally?
winrid on HN
Alternatives named
ZomboDB
From 1 comment
You could use ETL tools like peerdb.io. This isn't "real time" but instead some refresh interval. ZomboDB uses ElasticSearch as an index that is transactionally consistent with…
gregwebs on HN
PeerDB
From 1 comment
You could use ETL tools like peerdb.io. This isn't "real time" but instead some refresh interval. ZomboDB uses ElasticSearch as an index that is transactionally consistent with…
gregwebs on HN
TimescaleDB
From 1 comment
Big congrats on 1.0! Super exciting project. My dream scenario would be installing hydra as an extension into my main rails application database. My usecase is showing analytics…
efxhoy on HN