What you need to know about this demo of the new azure_ai extension to Azure Database for PostgreSQL – Flexible Server.

Brian steps through reviewing WAL history files and a sample recovery scenario.

Explore the transformative synergy of CloudNativePG, an operator bridging PostgreSQL and Kubernetes. This article reveals how this open-source stack liberates organizations from vendor lock-in, fostering a seamless microservice database environment and elevating innovation, operational efficiency, and velocity.

Zero-abstraction Postgres for TypeScript: a non-ORM database library - jawj/zapatos

PGlite - Postgres in WASM. Contribute to electric-sql/pglite development by creating an account on GitHub.

A PostgreSQL client library for Ruby. Contribute to ged/ruby-pg development by creating an account on GitHub.

Anonymization and Data Masking with PostgreSQL

Learn how to implement Change Data Capture with Neon's serverless Postgres, Debezium, and Upstash Redis

In many applications it’s a requirement to keep track of when a record was created and updated the last time. Often, this is implemented by having columns such as created_at and updated_at within each table. To make things as simple as possible for application developers, the database itself should take care of maintaining these values automatically when a record gets inserted or updated.

Postgres 16 introduces quite a few improvements to the query planner and makes many SQL queries run faster than they did on previous versions of PostgreSQL. This post is a deep dive into 10 of the improvements, including code blocks and comparisons of query plan output between Postgres 15 & Postgres 16.

Forgot how to connect to your Postgres services? You can use the .pg_service.conf file, or if you're a Timescale user, just click one button.

This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war. I have deci…

Tembo data warehouse

Understand how using UUIDs as primary keys can affect PostgreSQL performance, and how to tweak your index to avoid UUID performance pitfalls.

Previously for Extreme Learning, I discussed all the ways I've broken production using healthchecks. In this post I'll do the same for PostgreSQL.

Database Package Registry for Postgres. Contribute to supabase/dbdev development by creating an account on GitHub.

Experimental extension that brings OpenAI API to your PostgreSQL to run queries in human language. - GitHub - cloudquery/pg_gpt: Experimental extension that brings OpenAI API to your PostgreSQL to ...

null

IntegreSQL manages isolated PostgreSQL databases for your integration tests.

We take a look at how column ordering affects storage size, how you can play column tetris to optimize it, and the big benefits that array-based storage can yield for some workloads.

There's no official support for system-versioned tables in Postgres yet, and the temporal extensions aren't supported on Azure/AWS/GCP. Let's implement it ourselves with 3 triggers and an index.

Postgres is Enough · GitHub

Build Postgres Extensions with Rust! Contribute to pgcentralfoundation/pgrx development by creating an account on GitHub.

A truly Open Source MongoDB alternative, built on Postgres FerretDB allows you to use MongoDB drivers seamlessly with PostgreSQL as the database backend. Use all tools, drivers, UIs, and the same query language and stay open-source.

extension-ecosystem-jobs-tools.md · GitHub

The PostgreSQL Security team is pleased to announce that PostgreSQL is now a CVE Numbering Authority (CNA). A CNA has …

Backup / restore solution for PostgreSQL. Contribute to pgmoneta/pgmoneta development by creating an account on GitHub.

pgmoneta is a backup / restore solution for PostgreSQL.

Background