Dev tools · September 19, 2023
Hydra - Open-Source Columnar Postgres
hi hn, hydra ceo here hydra is an open-source extension that adds columnar tables to Postgres for efficient analytical reporting. With Hydra, you can analyze billions of rows instantly without changing code. demo video (5 min): https://youtu.be/1yzxgb0Oyrw github repo: https://github.com/hydradatabase/hydra 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…
Hydra - Open-Source Columnar Postgres launched on September 19, 2023 with 122 votes, #471 of 4,228 launches that month and more than 95% of that year's launches.
In plain words
Hydra is an open-source Postgres extension that adds columnar tables for analytical reporting on large datasets. It allows users to run aggregate queries on billions of rows without modifying existing code. The 1.0 release includes aggregate vectorization for faster query performance and support for spatial indexes including gin, gist, spgist, and rum indexes. Hydra is designed for developers and data analysts who need efficient analytics on Postgres without the performance degradation typically caused by long-running queries on large datasets.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
hi hn, hydra ceo here hydra is an open-source extension that adds columnar tables to Postgres for efficient analytical reporting. With Hydra, you can analyze billions of rows instantly without changing code. demo video (5 min): https://youtu.be/1yzxgb0Oyrw github repo…
Does a similar job
all alternatives →
Hydra 1.0 – open-source column-oriented Postgres2023 · hydra-so.notion.site · ▲269hi hn, hydra ceo here hydra is an open source, column-oriented postgres. you can set up remarkably fast aggregates on your project in minutes to query billions of rows instantly. 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 making code changes. data is automatically loaded into columnar format and compressed. connect to hydra with your preferred postgres client (psql, dbeaver, etc). following 4 months…
Open Source PostgreSQL Studio2021 · supabase.com · ▲407Powerful PostgreSQL tool is now open source for self-hosting
- PNPostgresML, now with analytics and project management2022 · postgresml.org · ▲444
We've been hard at work for a few weeks and thought it's time for another update. In case you missed our first post, PostgresML is an end-to-end machine learning solution, running alongside your favorite database. This time we have more of a suite offering: project management, visibility into the datasets and the deployment pipeline decision making. Let us know what you think! Demo link is on the page, and also here: https://demo.postgresml.org
Postgres as a VectorDB GUI2024 · github.com · ▲162Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
More dev tools this month
the category →
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 27d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 25d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 22d ago · openbot.run
Talanoa▲341Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 20d ago · talanoa.email
CoreSpeed▲332One MCP for everything your agents need: apps, memory, tools
Dev tools · 28d ago · corespeed.io
Source: Show HN post ↗ · launch text quoted in part
