Postgresql

depesz.com·há 13 dias

Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ)

On 16th of March 2026, Peter Eisentraut committed patch: SQL Property Graph Queries (SQL/PGQ) Implementation of SQL property graph queries, according to SQL/PGQ standard (ISO/IEC 9075-16:2023). This a

cedardb.com·há 22 dias

Replicating from Aurora for PostgreSQL via Debezium

Debezium is a popular platform for Change Data Capture (CDC). This guide shows you how you can replicate tables from your transactional Amazon Aurora PostgreSQL to CedarDB, allowing you to do fast ana

share.transistor.fm·há 27 dias

Working on Postgres after 13 years on SQL Server with Panagiotis Antonopoulos

What happens when a database engineer spends 13 years on SQL Server and then starts working on Postgres? In Episode 41 of Talking Postgres, Distinguished Engineer Panagiotis “Panos” Antonopoulos of Mi

karenjex.blogspot.com·há 29 dias

How much do you really need to know about databases?

Slides and transcript from How much do you really need to know about databases? at EuroPython 2026 in Kraków, Poland on 15 July 2026. I will add a link to the recording once it's available. I've inclu

cedardb.com·há cerca de 1 mês

Use AWS DMS to replicate data from RDS PostgreSQL to CedarDB

Overview Set up a CedarDB instance in EC2 using whichever approach suits you. I prefer CloudFormation templates, for their repeatability. When the CedarDB instance is running, note its VPC and deploy

depesz.com·há cerca de 1 mês

Waiting for PostgreSQL 20 – Add min() and max() aggregate support for uuid.

On 1st of July 2026, Masahiko Sawada committed patch: Add min() and max() aggregate support for uuid. The uuid type already has a full set of comparison operators and a btree operator class, so it is

depesz.com·há cerca de 1 mês

Waiting for PostgreSQL 20 – Add backend-level lock statistics

On 30th of June 2026, Michael Paquier committed patch: Add backend-level lock statistics This commit adds per-backend lock statistics, providing the same information as pg_stat_lock. It is now possibl

psycopg.org·há cerca de 2 meses

Psycopg - PostgreSQL adapter for Python

Psycopg is the most popular PostgreSQL adapter for the Python programming language.