A simple tutorial for calling webhooks on Postgres data and schema changes using pgstream.

PostgreSQL replication with DDL changes

Nautilus researchers have uncovered a new malware, that forces its way into PostgreSQL databases, delivers payloads to hide its operations.

As a general rule, every single command or query for the application use — I always wrap up in a PostgreSQL user-defined function!

Paul Ramsey has some great examples of Postgres network analysis and graph theory in this sample code for playing the Kevin Bacon game. Both pgRouting and recursive CTE are used to solve graphing relationships.

Performance issues in the PostgreSQL layer usually start to manifest only when your app reaches a certain scale. In this blog post, I'll discuss easy-to-miss database config tweaks and common problems that I've encountered in multiple Rails projects.

🐸 a database management tui for postgres.

こんにちは、デジスマチームでソフトウェアエンジニアをしている伊藤です。 この記事はデジスマチームブログリレーの8日目の記事です。 今回は我々が開発しているデジスマ診療 (以降、デジスマ) で、医療機関向けに提供しているユーザー検索機能のパフォーマンスを PostgreSQL の機能を活用して改善した話について紹介します…

こんにちは！ デジスマチームの山田です。これはデジスマチームのブログリレー4日目の投稿です。 事業が成長してユーザー数やトランザクションが増加すると、それに比例して扱うデータの量やバリエーションも増加します。サービス規模の拡大に伴い発生する課題の1つにスロークエリがありますが、デジスマ診療においてもサービスの成長とシス…

Just say when. Contribute to frectonz/pg-when development by creating an account on GitHub.

Matrix, the open protocol for secure decentralised communications

This post is a chronicle of the critical, hard-won lessons learned while maturing PostgreSQL into a highly performant and resilient queuing system.

I've recently automated a large portion of my Rails performance audits. In this tutorial, I'll describe how to configure an AI-powered PG performance debugging. We will cover using LLMs with custom MCP (model context protocol) n8n integration. We will also discuss the legal and security implications of connecting AI to the production database. There’s also a live demo available!

Learn how to run Postgres, MariaDB, and Redis as npm dependencies using Endor. No Docker needed - just npm install and start coding on any OS.

boundaries in funny places

PostgreSQL offers more than just traditional row storage. We benchmarked row store, column store, CSV, and Parquet across 144 million rows - see what storage really saves space and boosts performance.

Postgres LISTEN/NOTIFY can cause severe performance issues under high write concurrency due to a global lock during commit. Learn why it doesn't scale and how to avoid outages.

: Open source initiative aims to offer enterprise security feature without vendor lock-in

Over the last couple of years, I’ve helped dozens of users and organizations to build Change Data Capture (CDC) pipelines for their Postgres databases. A key concern in that process is setting up and managing replication slots, which are Postgres' mechanism for making sure that any segments of the write-ahead log (WAL) of the database are kept around until they have been processed by registered replication consumers. When not being careful, a replication slot may cause unduly large amounts of WAL segments to be retained by the database. This post describes best practices helping to prevent this and other issues, discussing aspects like heartbeats, replication slot failover, monitoring, the management of Postgres publications, and more. While this is primarily based on my experience of using replication slots via Debezium’s Postgres connector, the principles are generally applicable and are worth considering also when using other CDC tools for Postgres based on logical replication.

A follow up to my blog post exploring how often we pick the optimal query plan. Instructions how to reproduce it, why it happens and how to address it.

A story about a bug with logical replication slot creation on Postgres read replicas

This article tells you why SELECT FOR UPDATE is almost always the wrong lock and that you should use SELECT FOR NO KEY UPDATE instead.

Learn how to integrate PostgreSQL with DuckDB and MotherDuck for faster analytics. Compare DuckDB Postgres Extension, pg_duckdb, and CDC approaches with practical examples and best practices for each method. | Reading time: 10 min read

フューチャー株式会社が作成するエンタープライズ領域に特化したアーキテクチャガイドライン

PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite. - wey-gu/py-pglite

This post is maintained by Bytebase, an open-source database DevSecOps tool that can manage PostgreSQL. We will constantly update this post to include the lates...

At Bytebase, we work extensively with PostgreSQL and MySQL. Both databases have pros and cons. In this post, well highlight where PostgreSQL shines and MySQL fa...

Contribute to aws/pgactive development by creating an account on GitHub.

Vitess for Postgres. Contribute to multigres/multigres development by creating an account on GitHub.