#pgxn

• POC: PGXN Binary Distribution Format

  https://justatheory.com/2024/06/trunk-poc

  A proof of concept for “trunk”, the proposed binary distribution format for Postgres extensions.

• Mini Summit Five

  https://justatheory.com/2024/05/mini-summit-five

  Links, notes, and commentary from Yurii Rashkovskii’s presentation, “Universally Buildable Extensions: Dev to Prod,” at the fifth Postgres Extension Ecosystem Mini-Summit on May 1, 2024.

• PGXN v2: Go or Rust?

  https://justatheory.com/2024/03/pgxn-language-choices

• Release: pgxn_meta v0.1.0

  https://justatheory.com/2024/08/pgxn_meta_release

  Today I released pgxn_meta v0.1.0, a Rust crate and executable for validating PGXN Meta v1 and v2 META.json files.

• PGXN V2 Architecture

  https://justatheory.com/2024/04/pgxn-v2-architecture

  I’ve written and published a document outlining the vision and strategy for the next iteration of PGXN. It includes diagrams. Everybody loves diagrams.

• Test Postgres Extensions With GitHub Actions

  https://justatheory.com/2020/06/test-extensions-with-github-actions

  I finally made the jump from Travis CI to GitHub Actions for my Postgres extensions. Here’s how you can, too.

• Mini Summit Four

  https://justatheory.com/2024/04/mini-summit-four

  Links, notes, and commentary from Jonathan Katz’s presentation at the fourth Postgres Extension Ecosystem Mini-Summit, “Trusted Language Extensions for PostgreSQL”.

• PGXN Language Poll Result

  https://justatheory.com/2024/05/pgxn-language-poll-result

  Results of the Postgres community poll for building PGXN v2 in Go, Rust, or both.

• 🏔 Extension Ecosystem Summit 2024

  https://justatheory.com/2024/06/extension-ecosystem-summit

  A brief report on the PostgreSQL Extension Ecosystem Summit at PGConf.dev 2024 in Vancouver, Canada.

• POSETTE 2024

  https://justatheory.com/2024/06/posette

  I attended and gave a presentation at POSETTE, an event for Postgres. This post highlights some talks and the slides for my own.

• Mini Summit Three

  https://justatheory.com/2024/04/mini-summit-three

  A rough transcript of my Devrim Gündüz’s talk, “Overview of {yum,zypp}.postgresql.org, and the challenges around RPMifying extensions”, along with interspersed chat comments.

• Test and Release pgrx Extensions with pgxn-tools

  https://justatheory.com/2024/04/pgxn-tools-pgrx

  The v1.6.0 release of the pgxn-tools Docker image adds a new command to efficiently build and test pgrx extensions on a wide variety of Postgres versions.

• Contemplating Decentralized Extension Publishing

  https://justatheory.com/2024/02/decentralized-extension-publishing

  The Go package ecosystem uses distributed publishing to release modules without authentication or uploads. Could we do something similar for Postgres extensions?

• Extension Ecosystem Summit 2025

  https://justatheory.com/2025/03/extension-ecosystem-summit

  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!

• Mini Summit One

  https://justatheory.com/2024/03/mini-summit-one

  A rough transcript of my talk “State of the Extension Ecosystem”, along with interspersed chat comments and appearances by Bagel.

• PGXN Challenges

  https://justatheory.com/2024/01/pgxn-challenges

  Some thoughts on the challenges for PGXN’s role in the ideal PostgreSQL extension ecosystem of the future.

• The History and Future of Extension Versioning

  https://justatheory.com/2024/02/extension-versioning

  What versioning standard should be used for Postgres extension distribution? Some context from PostgreSQL and PGXN, a survey of the version standard landscape today, and a recommendation.

• PGConf.dev 2024

  https://justatheory.com/2024/06/pgconf-future-ecosystem

  At PGConf.dev, I attended some great talks, made one of my own, and enjoyed the commearderie of fellow PostgreSQL extension authors and core developers. A brief report.

• ⛰️ Postgres Ecosystem Summit EU

  https://justatheory.com/2024/10/postgres-ecosystem-summit-eu

  The sequel to the successful PGConf.dev event, the Extension Ecosystem Summit EU will showcases some exemplary extension use cases.

• RFC: PGXN Metadata Sketch

  https://justatheory.com/2024/03/rfc-pgxn-metadata-sketch

  Request for comments on a sketch of a new metadata standard for Postgres extension packaging, distribution, and delivery, building on the PGXN Meta Spec to address its shortcomings and emerging use cases 12 years on.

• Extension Ecosystem Summit 2024

  https://justatheory.com/2024/02/extension-ecosystem-summit

  Some pals and I organized a summit at PGConf.dev on May 28 to work together as a community toward comprehensive indexing, discovery, and binary distribution, as well as a speaker series “mini summit” leading up to the event.

• Mini Summit Two

  https://justatheory.com/2024/03/mini-summit-two

  A rough transcript my Ian Stanton’s talk, “Building Trunk: A Postgres Extension Registry and CLI”, along with interspersed chat comments.

• Extension Registry Namespacing RFC

  https://justatheory.com/2024/03/extension-namespace-rfc

  A proposal for an additional level of name uniqueness for Postgres extension packaging and distribution, based on URIs.

• POC: Distributing Trunk Binaries via OCI

  https://justatheory.com/2024/06/trunk-oci-poc

  Would it be possible to distribute Postgres extension binaries via Open Container Registries? Tune in to find out!

• Mini Summit Six

  https://justatheory.com/2024/05/mini-summit-six

  A rough transcript of the sixth and final Extension Ecosystem Mini-Summit, in which we review potential topics for the in-person summit at PGConf.dev and discuss how to organize it.

Follow #pgxn on RSS or use the

curl -X GET \
  -H "Content-type: application/json" \
  -H "Accept: application/json" \
  "https://octothorp.es/~/pgxn"