#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
JSON API
curl -X GET \
-H "Content-type: application/json" \
-H "Accept: application/json" \
"https://octothorp.es/~/pgxn"