Hacker News with Generative AI: Postgres

(All) Databases Are Just Files. Postgres Too (tselai.com)
Dear reader: If you’re feeling an urge to comment solely based on the title, just be warned that too many have done so already.
Databases, Postgres, Data Storage
6 points by mooreds 6 days ago | 0 comments
Vertical Sharding Sucks (pgdog.dev)
Vertical sharding, sometimes called functional sharding, takes tables out of your main database and puts them somewhere else. Most of the time, it’s another Postgres database. This reduces load on the main DB and gives your app some breathing room to grow.
Database Design, Performance Optimization, Scaling, Postgres
20 points by samokhvalov 14 days ago | 13 comments
Show HN: AI-Driven Index Tuning With Postgres MCP Server (github.com/crystaldba)
Postgres Pro is an open source Model Context Protocol (MCP) server built to support you and your AI agents throughout the entire development process—from initial coding, through testing and deployment, and to production tuning and maintenance.
AI, Postgres, Database Tuning, Open Source, Software
11 points by jssmith 17 days ago | 4 comments
Postgres Language Server: Initial Release (github.com/supabase-community)
Postgres, Language Servers, Open Source, Databases
362 points by steinroe 28 days ago | 52 comments
Postgres to ClickHouse: Data Modeling Tips V2 (clickhouse.com)
It is becoming increasingly common for customers to use Postgres and ClickHouse together, with Postgres powering transactional workloads and ClickHouse powering analytics.
Databases, Data Modeling, ClickHouse, Postgres
3 points by saisrirampur 39 days ago | 0 comments
Making Postgres scale (pgdog.dev)
Postgres scales. No other two words that I’ve ever heard of, produced more controversy. At least in the circles I hang out in, in the company basement where infrastructure elves make the Rails app go brrr. A lot of people believe, against all odds, and marketing campaigns by Big NoSQL, that technology you know is better than the devil you just heard pitched at the Engineering Leadership meeting.
Databases, Postgres, Performance
225 points by levkk 43 days ago | 188 comments
Did u ever read so hard u accidentally wrote? (danslimmon.com)
Owning a production Postgres database is never boring.
Programming, Databases, Postgres
11 points by todsacerdoti 43 days ago | 2 comments
I replaced my entire tech stack with Postgres [video] (youtube.com)
Postgres, Databases, Technology, Video
13 points by garyclarke27 53 days ago | 0 comments
Show HN: PG-Capture – a better way to sync Postgres with Algolia (or Elastic) (onrender.com)
Schema-based Change-Data-Capture for Postgres
Databases, Postgres, Search, Open Source, SaaS
56 points by nick-keller 56 days ago | 19 comments
Postgres as a Graph Database: (Ab)Using PgRouting (supabase.com)
pgRouting is a Postgres extension. It's often used for finding the “shortest path” between two locations, however it's a hidden gem in Postgres and can be used for basic graph functionality.
Postgres, Graph Databases, Databases, pgRouting, Routing
164 points by michelpp 57 days ago | 44 comments
The Great Re-shard: adding Postgres capacity (again) with zero downtime (2023) (notion.com)
Earlier this year, we swapped out Notion’s live database cluster for a larger one without taking downtime.
Databases, Postgres, Downtime, Scaling, Technology
30 points by unchar1 61 days ago | 8 comments
A Language Server for Postgres (github.com/supabase-community)
A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.
Postgres, Databases, Language Servers, Developer Tools
99 points by tbatchelli 66 days ago | 22 comments
A major Postgres upgrade with zero downtime (instantdb.com)
Right before Christmas we discovered that our Aurora Postgres instance needed a major version upgrade. We found a great essay by the Lyft team, showing how they ran their upgrade with about 7 minutes of downtime.
Databases, Postgres, Upgrades
249 points by stopachka 87 days ago | 76 comments
"Just Use Postgres" Book (manning.com)
You probably don’t need a collection of specialty databases. Just use Postgres instead!
Databases, Postgres, Books
5 points by thunderbong 100 days ago | 1 comments
Reads Causing Writes in Postgres (jesipow.com)
It is good practice to regularly inspect the statements running in the hot path of your Postgres instance. One way to do this is to examine the pg_stat_statements view, which shows various statistics about the SQL statements executed by the Postgres server.
Database, Postgres, Performance Optimization, Monitoring, SQL
224 points by thunderbong 125 days ago | 28 comments
Shrinking a Postgres Table (johnnunemaker.com)
Ok folks, this is kind of a weird one. I'm going to put it in the "you won't ever need this, but if you do, you are going to be glad I wrote this up for ya" category.
Databases, Postgres, Optimization
5 points by plaur782 135 days ago | 0 comments
Django and Postgres for the Busy Rails Developer (andyatkinson.com)
About 10 years ago I wrote a post PostgreSQL for the Busy MySQL Developer, as part of switching from MySQL to Postgres for my personal and professional projects, wherever I could.
Django, Postgres, Rails, Web Development, Databases
180 points by plaur782 136 days ago | 120 comments
Running Durable Workflows in Postgres Using DBOS (supabase.com)
Michael Stonebraker is the inventor of Postgres and a Turing Award winner. His latest venture is DBOS, a three-year joint research project between Stanford and MIT. The DBOS team have built a Durable Workflow engine using Postgres. It's one of the of the more elegant designs I've seen, leveraging the features of Postgres to keep it lightweight and fast.
Databases, Workflow Engines, Postgres, Research
185 points by kiwicopple 137 days ago | 67 comments
Show HN: Performing a zero downtime major version upgrade on RDS Aurora Postgres (medplum.com)
Medplum is built on Postgres. Until recently, our hosted Medplum service was using an Amazon Web Services (AWS) RDS Aurora Postgres cluster running version 12.16. Since v12 is rather outdated and nearing the end of its standard support window on RDS, it was time to plan our upgrade to the newest version available on RDS, v16.4.
AWS, Databases, Postgres, Software
15 points by mattlong 138 days ago | 3 comments
Keyset cursors, not offsets, for Postgres pagination (sequinstream.com)
We're building Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. Efficient, correct pagination is paramount for our backfill process, so we use keyset cursors extensively.
Databases, Pagination, Postgres, Software Development, Streaming
66 points by todsacerdoti 143 days ago | 7 comments
Pg_parquet – Postgres to Parquet Interoperability (i-programmer.info)
Databases, Data Formats, Postgres, Parquet
4 points by plaur782 149 days ago | 0 comments
Shrinking a Postgres Table (johnnunemaker.com)
Ok folks, this is kind of a weird one. I'm going to put it in the "you won't ever need this, but if you do, you are going to be glad I wrote this up for ya" category.
Databases, Postgres, Optimization
11 points by todsacerdoti 149 days ago | 2 comments
Show HN: Neon-PostgREST – Build a Supabase-Like API/SDK DevX over Neon (github.com/zuplo-samples)
Are you using/considering Neon (or your own hosted Postgres) - but wish you had the ability to interact with your database via API/SDK like Supabase? Look no further! This project shows you exactly how to recreate the Supabase API and developer experience. Try the Demo.
Databases, API, Open Source, Software Development, Postgres
8 points by DataOverload 152 days ago | 2 comments
What I wish someone told me about Postgres (challahscript.com)
I’ve been working professionally for the better part of a decade on web apps and, in that time, I’ve had to learn how to use a lot of different systems and tools.
Databases, Postgres, Web Development
487 points by todsacerdoti 165 days ago | 191 comments
Show HN: BemiDB – Postgres read replica optimized for analytics (github.com/BemiHQ)
BemiDB is a Postgres read replica optimized for analytics, It consists of a single binary that seamlessly connects to a Postgres database, replicates the data in a compressed columnar format, and allows you to run complex queries using its Postgres-compatible analytical query engine.
Databases, Analytics, Postgres, Open Source, Software
209 points by exAspArk 170 days ago | 118 comments
Neon Authorize: Simplifying row-level security for Postgres (neon.tech)
Today we’re launching Neon Authorize, a tool that aims to simplify the usage of Postgres row-level security policies while enabling new deployment models for app developers.
Databases, Security, Postgres, Open Source, Software
10 points by carlotasoto 178 days ago | 0 comments
Graph Retrieval Using Postgres Recursive CTEs (sheshbabu.com)
Did you know you can use Postgres as a graph database for certain usecases?
Database, SQL, Graph Databases, Postgres
12 points by aleclarsoniv 183 days ago | 0 comments
Pg_parquet: An extension to connect Postgres and parquet (crunchydata.com)
Today, we’re excited to release pg_parquet - an open source Postgres extension for working with Parquet files.
Databases, Open Source, Postgres, Parquet
157 points by craigkerstiens 191 days ago | 25 comments
How we build forms in LiveView and LiveSvelte (sequinstream.com)
We're Sequin, an open source message stream built on Postgres. We have a console for managing tables and streams, and that console is built with LiveView + LiveSvelte.
Web Development, Open Source, LiveView, LiveSvelte, Postgres
6 points by learning_elixir 197 days ago | 0 comments
Putting a full power search engine in Ecto (moosie.us)
ParadeDB is a set of extensions that add pretty amazing search and analytics features to Postgres. In particular, ParadeDB embeds Tantivy as an extension via pgrx.
Databases, Search, Postgres, Ecto
144 points by philippemnoel 198 days ago | 25 comments