######octothorp.es

#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"