Hacker News with Generative AI: Postgres

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

483 points by todsacerdoti 9 days ago | 190 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 14 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 22 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 27 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 35 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 41 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 42 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 46 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 57 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 57 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 59 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 60 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 63 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 63 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 63 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 64 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 65 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 65 days ago | 49 comments

Ask HN: Where are you hosting your Postgres database in 2024? (ycombinator.com)
Ask HN: Where are you hosting your Postgres database in 2024?

Database Hosting, Postgres, 2024

15 points by pier25 69 days ago | 15 comments

ClickHouse Data Modeling for Postgres Users (clickhouse.com)
Last month, we acquired PeerDB, a company that specializes in Postgres CDC. PeerDB makes it fast and simple to replicate data from Postgres to ClickHouse. A common question from PeerDB users is how to model their data in ClickHouse after the replication process to maximize the benefits of ClickHouse.

ClickHouse, Databases, Postgres, Data Modeling, Data Replication

80 points by saisrirampur 72 days ago | 9 comments

Understanding Pgvector's HNSW Index Storage in Postgres (lantern.dev)

Databases, Postgres, Search

77 points by varik77 80 days ago | 11 comments

Postgres Webhooks with Pgstream (xata.io)

Postgres, Webhooks, Databases

160 points by mebcitto 81 days ago | 21 comments

Understanding the Postgres Hackers Mailing List (crunchydata.com)

Databases, Postgres, Community

7 points by plaur782 83 days ago | 0 comments

Scaling Rails and Postgres to millions of users at Microsoft (stepchange.work)