pg_clickhouse 0.3.2: Ready For Postgres 19
What’s new in the latest release of the pg_clickhouse, the interface for querying ClickHouse from Postgres.
Just a Theory
Periodically irregular technology and culture blogging since 2002. By David E. Wheeler.
Latest posts
pg_clickhouse 0.3.1: Now With More C
Big changes for a minor release.
What’s New in pg_clickhouse
Bit of a news catchup on the pg_clickhouse project.
pg_clickhouse 0.2.0
I guess this is a pg_clickhouse announcement blog, now.
pg_clickhouse 0.1.10
Hi, it’s me with another update to pg_clickhouse.
pg_clickhouse 0.1.6
Another bug fix and pushdown-improving release of the foreign data wrapper.
pg_clickhouse 0.1.5
New maintenance release of pg_clickhouse: v0.1.5.
pg_clickhouse v0.1.4
A quick note on the release of pg_clickhouse v0.1.4.
🛠️ PGXN Tools v1.7
Just released the PGXN test and build OCI image upgraded to Trixie and improving PGXS build parallelization.
Welcome dmjwk
I wrote a dead simple demo IDP server. Never use it for real workloads. But you might find it useful to demo services that require Bearer Token authentication.
🐏 Taming PostgreSQL GUC “extra” Data
For the ClickHouse blog I wrote up learning how to work with C data structures and memory allocation within the tight constraints of the Postgres “GUC” API.
Introducing pg_clickhouse
Introducing pg_clickhouse, a PostgreSQL extension that runs your analytics queries on ClickHouse right from PostgreSQL without rewriting any SQL.
Sqitch 1.6.0: Now with ClickHouse!
Sqitch 1.6.0, out today, adds support for managing ClickHouse databases.
Postgres Extensions: Use PG_MODULE_MAGIC_EXT
Details for extension authors for how to use the new PG_MODULE_MAGIC_EXT macro introduced in PostgreSQL 18.
Adventures in Extension Packaging
Narrative version of a PGConf.dev talk covering the many issues I stumbled upon while designing a universal packaging format for PostgreSQL extensions, maintaining pgt.dev packages, and experimenting with CloudNativePG immutability.
Auto-Release PostgreSQL Extensions on PGXN
Step-by-step instructions to publish PostgreSQL extensions and utilities on the PostgreSQL Extension Network (PGXN).
Mini Summit 5 Transcript: Improving the PostgreSQL Extensions Experience in Kubernetes with CloudNativePG
At the final Mini-Summit of 2025, Gabriele Bartolini gave an overview of PostgreSQL extension management in CloudNativePG.
CBOR Tag for JSON Number Strings
Use the new IANA-registered tag to preserve JSON numbers represented as strings when encoding in Concise Binary Object Representation.
2025 GSOC: Mankirat Singh — ABI Compliance Reporting
Please welcome 2025 Google Summer of Code contributor Mankirat Singh, who will be developing an ABI compliance checker for the PostgreSQL maintenance branches.
Mini Summit 5: Extension Management in CNPG
The last Mini-Summit of the year features Gabriele Bartolini talking about extension management in CloudNativePG.
Mini Summit 4 Transcript: The User POV
Last week Floor Drees moderated a panel on “The User POV” at the fourth Extension Mini-Summit. Read on for the transcript and link to the video.
Update Your Control Files
Suggestions to PostgreSQL extension maintainers to make some tweaks to your .control files and Makefile s.
Mini Summit 4: The User POV
Join our fine panel on Wednesday at Extension Mini Summit #4 to hear all about “The User POV” — for better and for worse!
Fix Postgres <code>strchrnul</code> Compile Error on macOS 15.4
A fix for the error: 'strchrnul' is only available on macOS 15.4 or newer Postgres compile error.
Mini Summit 3 Transcript: Apt Extension Packaging
Last week Christoph Berg, who maintains PostgreSQL’s APT packaging system, gave a very nice talk on that system. Herein lie the transcript and links to the slides and video.
Mini Summit 3: APT Extension Packaging
Join us at PostgresSQL Extension Mini Summit #3 this week, where PostgreSQL Debian packaging maintainer Christoph Berg will takes on a tour of APT extension packaging.
2025 Postgres Extensions Mini Summit Two
A transcript of from the second PostgreSQL Extension Mini Summit, “Implementing an Extension Search Path”, by Peter Eisentraut.
Mini Summit 2: Extension Search Path Patch
Join us at PostgresSQL Extension Mini Summit #2 this week, where PostgreSQL committer Peter Eisentraut will discuss the extension search path patch.
2025 Postgres Extensions Mini Summit One
A rough transcript of my talk “State of the Extension Ecosystem”.
Extension Ecosystem Summit 2025
We’re doing it again! The PostgreSQL Extension Ecosystem Summit returns to PGConf.dev. We’ll again be looking at indexing, discovery, packaging, and core support. And we’ll once again be hosting a series of “Mini Summits” leading up to the event. Join us!
Sqitch 1.5.0
Sqitch v1.5.0: out now in all the usual places!
Should URI::mysql Switch to DBD::MariaDB?
Should Sqitch and URI::mysql use DBD::MariaDB instead of DBD::mysql? If so, what are the implications for Sqitch deployment and usage?