Automated database platform for PostgreSQL® — the open-source alternative to cloud-managed databases. - vitabaks/autobase

Version 17 of PostgreSQL has been released for a while. One of the many features is a change by Tom Lane called “Rearrange pg_dump’s handling of large objects for better efficiency”. In the past, we have seen our customers have several problems with a large number of large objects being a performance issue for dump/restore. […]

Lightweight WASM Postgres

How to reduce complexity and move faster? Just Postgres for everything. - Olshansk/postgres_for_everything

Dive deep into the architecture of pg_karnak, PostgreSQL extension, metadata store and transaction coordinator designed for reliable and scalable schema migrations across many tenants and Postgres instances. This post explores PostgreSQL internals, including extension hooks, transaction lifecycle, and locking mechanisms, offering insights into building scalable, reliable systems for distributed applications.

Postgres re-engineered for multi-tenant apps. Build secure, scalable and AI-native multi-tenant applications with world-class developer experience.

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. During that education, I found that the official documentation typically proved to be the most helpful.

In-browser Postgres sandbox with AI assistance

In-browser Postgres sandbox with AI assistance (formerly postgres.new) - supabase-community/database-build

Utilising statistics to optimise GROUP-BY

Quickly spin up a temporary PostgreSQL test databases - eradman/ephemeralpg

Run tests on an isolated, temporary PostgreSQL database

Let’s say you created a Go program that stores data in PostgreSQL — you installed PostgreSQL, wrote the Go code, and everything works; great! But after writing a test for your code, you wonder: how do you best provide PostgreSQL to your automated tests?

Upgrades between PostgreSQL major versions are famously annoying. You can’t just install the server binaries and restart, because the format of the data directory is incompatible. Why is that? Why can’t we just keep the data format compatible?

See what PostgreSQL batch ingest method is right for your use case: in this article, we benchmark INSERT (VALUES and UNNEST) vs. COPY (text and binary).

Spot vulnerabilities in postgres SQL scripts. Contribute to timescale/pgspot development by creating an account on GitHub.

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. As you may or may not know, I recently acquired fireside.fm,

Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved. - frectonz/pglite-fusion

Paul shows you how to use a new OpenAI API extension for working with LLMs in Postgres.

Postgres is already great, surely - even “too popular” one could complain with a twist…as this broadcast “was” actually supposed to be my Lightning Talk at last month’s pgConf.eu in Athens 🙂 But indeed, seems Postgres has in an awesome way gotten so big that it’s not like that anymore...

Read how you can double your Postgres INSERT performance using the UNNEST function.

A new point version was released on Nov 14th for 17.1, 16.5, 15.9, and others. This included an update to the Postgres ABI potentially breaking extensions. Craig digs into the change and what you need to know.

Postgres to Elasticsearch/OpenSearch sync.

psql is a CLI editor that ships with Postgres. It’s incredibly powerful for working with Postgres, and doesn’t take too much of a learning curve to start to get comfortable so you can really feel like an expert working with your database. Just a rundown of a few things to get you started:

A key aspect of maintaining backup integrity is understanding data checksums. Without proper checksum validation, detecting data corruption becomes virtually impossible. Therefore, we will start with The...

Official PostgreSQL port of Sqids. Generate short unique IDs from numbers. - sqids/sqids-postgresql