#pgxn

• 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.

• 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.

• 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”.

• RFC: PGXN Meta Spec v2

  https://justatheory.com/2024/07/rfc-pgxn-meta-v2/

  PGXN Meta Spec v2 represents a significant reworking of the original spec for PGXN distributions. It would very much benefit from feedback from Postgres extension and developers.

• 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.

• 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.

• 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.

• 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.

• 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.

• PGXN Development Project

  https://justatheory.com/2010/06/pgxn-development-project/

  I’m pleased to announce the launch of the PGXN development project. I’ve written a detailed specification and pushed it through general approval on pgsql-hackers. I’ve written up a detailed project plan and estimated things at a highly reduced PostgreSQL Experts rate to come up with a fundraising goal: $25,000. And now, thanks to founding contributions from myYearbook.com, and PostgreSQL Experts, we have started the fundraising phase of the project.

• PGXN v2: Go or Rust?

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

  What programming language(s) should we use to build new and revamp existing PGXN services and tools: Rust or Go? Vote your preference!

• 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.

• 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.

• 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 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.

• 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.

• ⛰️ 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.

• Automate Postgres Extension Releases on GitHub and PGXN

  https://justatheory.com/2020/10/release-postgres-extensions-with-github-actions/

  Go beyond testing and fully automate the release of Postgres extensions on both GitHub and PGXN using GitHub actions.

• 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.

• 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 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.

Follow #pgxn on RSS or use the

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