Hacker News with Generative AI: Postgres

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
94 points by tbatchelli 23 hours ago | 17 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 22 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 35 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 60 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 70 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 71 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 72 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 73 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 78 days ago | 7 comments
Pg_parquet – Postgres to Parquet Interoperability (i-programmer.info)
Databases, Data Formats, Postgres, Parquet
4 points by plaur782 84 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 84 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 87 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 101 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 105 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 113 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 119 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 126 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 132 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 134 days ago | 25 comments
Optimizing Postgres table layout for maximum efficiency (r.ena.to)
When modeling a Postgres database, you probably don’t give much thought to the order of columns in your tables. After all, it seems like the kind of thing that wouldn’t affect storage or performance. But what if I told you that simply reordering your columns could reduce the size of your tables and indexes by 20%? This isn’t some obscure database trick — it’s a direct result of how Postgres aligns data on disk.
Databases, Postgres, Optimization, Performance
204 points by napsterbr 137 days ago | 68 comments
Deep Dive into Postgres Write-Ahead Logs (artie.com)
Write-ahead logs are one of four components required for logical replication. They are used to ensure data durability, meaning your data is consistent and protected against data loss. Even if a server machine fails, write-ahead logs ensure your changes persist.
Databases, Postgres, Data Durability
35 points by j-cheong 149 days ago | 5 comments
A few secure, random bytes without `pgcrypto` (brandur.org)
In Postgres it’s common to see the SQL random() function used to generate a random number, but it’s a pseudo-random number generator, and not suitable for cases where real randomness is required critical. Postgres also provides a way of getting secure random numbers as well, but only through the use of the pgcrypto extension, which makes gen_random_bytes available.
Security, Postgres, Databases
57 points by surprisetalk 149 days ago | 38 comments
Real World Performance Gains with Postgres 17B-Tree Bulk Scans (crunchydata.com)
With RC1 freshly cut, the release of Postgres 17 is right on the horizon, giving us a host of features, improvements, and optimizations to look forward to.
Databases, Performance Optimization, Postgres, New Releases
4 points by craigkerstiens 150 days ago | 0 comments
Why avoid where id in with variable number of bind parameters on Postgres (kaveland.no)
In my post about batch operations, I used the where id = any(:ids) pattern, with ids bound to a JDBC array. I’ve gotten questions about that afterwards, asking why I do it like that, instead of using in (:id1, :id2, ...). Many libraries can take care of the dynamic SQL generation for you, so often you can just write in (:ids), just like the array example.
Postgres, SQL, Databases, Performance, Programming
7 points by rkaveland 151 days ago | 0 comments
Building RAG with Postgres (anyblockers.com)
Postgres is a powerful tool for implementing Retrieval-Augmented Generation (RAG) systems. Its versatility and robustness make it an excellent choice for this task. By diving deep into a technology you’re already familiar with, you can experience a significant productivity boost. As the saying goes, “stick with the tools you know.” Using Postgres for RAG allows you to reason about the system more easily, cutting through the hype and focusing on building something great.
Postgres, Databases, AI, Productivity
13 points by ecz 154 days ago | 1 comments
YugabyteDB with Enhanced Postgres Compatibility (yugabyte.com)
We are thrilled to announce powerful new capabilities and architectural enhancements — collectively called enhanced Postgres compatibility — that allow a broader range of Postgres apps to run on YugabyteDB.
Databases, Postgres, Open Source, Cloud Computing, Software
12 points by 3littlefish 154 days ago | 1 comments
Building RAG with Postgres (anyblockers.com)
Postgres is a powerful tool for implementing Retrieval-Augmented Generation (RAG) systems. Its versatility and robustness make it an excellent choice for this task. By diving deep into a technology you’re already familiar with, you can experience a significant productivity boost. As the saying goes, “stick with the tools you know.” Using Postgres for RAG allows you to reason about the system more easily, cutting through the hype and focusing on building something great.
Postgres, Database
4 points by sebg 154 days ago | 0 comments
Show HN: Selectable – mobile-friendly Postgres client (getselectable.com)
The Selectable app lets you access your Postgres database with a beautiful mobile-optimised experience that lets you write complex SQL queries without breaking a sweat.
Databases, Mobile Development, Software, Postgres
94 points by yen223 155 days ago | 46 comments
Window Functions for Data Analysis with Postgres (crunchydata.com)
SQL makes sense when it's working on a single row, or even when it's aggregating across multiple rows. But what happens when you want to compare between rows of something you've already calculated? Or make groups of data and query those? Enter window functions.
SQL, Databases, Postgres, Data Analysis, Window Functions
6 points by craigkerstiens 156 days ago | 0 comments
Rainfrog – a database management TUI for Postgres (github.com/achristmascarl)
🐸 a database management tui for postgres
Databases, Tools, Postgres
192 points by achristmascarl 157 days ago | 49 comments