Show HN: Hydra - Open-Source Columnar Postgres

1. columnar

   1 31 2,933 5.4 C

   Postgres-native columnar storage extension

   

   github repo: https://github.com/hydradatabase/hydra

   you may have seen hydra 1.0 beta release in August, past release notes [here](https://www.notion.so/Release-notes-0332c439427b4e7e92ec2a2b...). For 1.0 GA release, aggregate queries are over *60% faster* than Hydra beta due to aggregate vectorization. Spatial indexes (gin, gist, spgist, and rum indexes) and pg_hint_plan are now enabled for performance optimization.

   postgres is great, but aggregates can take minutes to hours to return results on large data sets. long-running analytical queries hog database resources and degrade performance. use hydra to run much faster analytics on postgres without changing code.

   for testing, try the hydra free tier to create a column postgres instance on the cloud. https://dashboard.hydra.so/signup

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. thc-hydra

   2 18 10,324 8.1 C

   hydra

   

   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 facebook went ahead and named their config tool hydra https://github.com/facebookresearch/hydra on top of it. Like we get it, hydra popular mythology but we could use more original naming for tools

4. hydra

   3 16 9,226 7.8 Python

   Hydra is a framework for elegantly configuring complex applications (by facebookresearch)

   

   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 facebook went ahead and named their config tool hydra https://github.com/facebookresearch/hydra on top of it. Like we get it, hydra popular mythology but we could use more original naming for tools

5. hydra

   4 17 2,291 6.1 JavaScript

   Livecoding networked visuals in the browser (by hydra-synth)

   

   Or https://github.com/hydra-synth/hydra (Livecoding networked visuals in the browser, since 2017)

6. citus

   5 1 2 10.0 C

   Discontinued Distributed PostgreSQL as an extension (by hydradatabase)

   

   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 numbers directly to users, like "how many people visited my listing", which regular row-level postgres is not suited to answer. To do this now we need a to get that data from our DW, which is slow for single queries, so we need a cache, which we need to keep in sync, which is complexity I don't want. It would be amazing if I could do user-facing analytics queries directly in my main app db.

   What put me off after a quick scroll:

   Installing the extension changes the default table type to be columnar. I don't want an installed extension to do that, my main workload is still row oriented oltp, I only want specific tables to be columnar and I don't want to change all my normal migrations to specify `USING heap`. IMO timescale does this really well, it's an extension, not a new database. At least that's how I would want it to be.

   It also seems like you're trying to claim postgres foreign data wrappers as "hydra external tables", implying it's a new feature? Postgres does this (reading other databases and external files) out of the box and it feels sneaky to try and brand that.

   Also the FAQ says "Hydra is not a fork." When the engine clearly is: https://github.com/hydradatabase/citus I realize you want to monetize this as a bigger platform and that's completely fair, but it strikes me as dishonest to deny the citus originins in the FAQ.

7. InfluxDB

   influxdata.com featured

   InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

   

Suggest a related project