The native Mac app for PostgreSQL all new again

Stream, transform, and route PostgreSQL data in real-time. - shayonj/pg_flo

pg_flo is a powerful PostgreSQL data replication tool that enables real-time streaming, table routing, data transformation, and secure data masking between databases.

Open-source Snowflake and Fivetran alternative bundled together

Pongo - Mongo but on Postgres and with strong consistency benefits - event-driven-io/Pongo

We're Sequin, an open source message stream like Kafka, but built on Postgres. Like any Postgres maxi, we tend to find ourselves down a Postgres rabbit hole a couple times per month. This is one of those times :) Who doesn't like to go a little overboard with Postgres? Extensions like

Check what features you are missing in the version of Postgres you are using.

When dealing with very large PostgreSQL tables (we're talking 15TB+), sometimes routine maintenance like archiving very old data can become surprisingly challenging

Querying your database across associations can become a bottleneck in your Rails application. Julian Rubisch, our first guest author, explains why and suggests an efficient solution.

With all these LLMs flying around, PDFs have become popular data sources again. Wait, can a blob of binary be considered a data source, just because human eyes can interpret it visually? Well, no. Unless you can run SQL queries on top of them. This post discusses that.

This canary-based partitioning strategy is a safer, more controlled way to handle large-scale database partitioning and query optimization. Get real-time statistics and gradual optimization, reducing the risks with traditional partitioning processes.

Copy to/from Parquet in S3 from within PostgreSQL.

Understand the recommended data types, storage requirements, and pros and cons of each for various use cases

Just out in Postgres 17, the Postgres release notes now link to git commit messages!

This article describes the problem of endless trigger recursion in PostgreSQL and shows how to deal with it and get good performance.

Paul shows you how to easily load JSON into Postgres relational format with JSON_TABLE, just released in Postgres 17.

Open Source Oracle compatible PostgreSQL

Should a DBMS mend query structure ?

Introduction 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.\n

This blog post debunks six common myths surrounding pg_vector, a popular Postgres extension for storing and querying vectors, which is often misunderstood. It clarifies that while vector indexes can enhance performance, they are not always necessary, and different types of vector indexes serve distinct purposes. The post also addresses misconceptions about the limitations on vector dimensions, the evolving nature of pg_vector, and its compatibility with sparse vectors like BM25. Through practical examples, the post highlights how pg_vector offers flexibility in vector storage and retrieval, making it a powerful tool beyond just RAG applications.

Contains PostgreSQL functions which I regularly needed. - sjstoelting/pgsql-tweaks

Photo by Caterina sanders on Unsplash "You know what's weird? Day by day, nothing seems to change, but pretty soon...everything's different." – Bill Watterson Note: if you need the upgrade steps for version 15 to 16, you can find them here, and if you need the steps for 14 to 15, you can find

In this post, we explore the limits of single-node Postgres and what optimizations can extend its usefulness as a primary application database before requiring more advanced scaling solutions. Monolithic ecommerce app on RDS PostgreSQL Let's use a real-world scenario, a monolith web application that uses PostgreSQL as the application database running on AWS RDS. The RDS instance is a 2xlarge. The resources are: * 8 vCPUs * 64 GB Memory * 20,000 Max I/O operations per second (IOPS) In ou

PostgreSQL v17 has been released. If the list of new features does not inspire you, this article will try to change your mind.