David WheelerApr 15

RE2 Postgres extension: ClickHouse-compatible regex functions using RE2

https://pgxn.org/dist/re2

#PostgreSQL #re2 #pgxn

re2: ClickHouse-compatible regex functions using RE2 / PostgreSQL Extension Network

Search all indexed extensions, distributions, users, and tags on the PostgreSQL Extension Network.

PGXN: PostgreSQL Extension Network
David WheelerMay 20, 2025

Blogged step-by-step instructions for publishing PostgreSQL extension source releases on PGXN.

https://justatheory.com/2025/05/release-on-pgxn/

#postgresql #pgxn #github #cicd

Auto-Release PostgreSQL Extensions on PGXN

Step-by-step instructions to publish PostgreSQL extensions and utilities on the PostgreSQL Extension Network (PGXN).

❖ Just a Theory
TemboSep 14, 2024
Interested in getting involved with #PGXN v2? Look at the project's milestones and pick up a task: https://github.com/pgxn/planning/milestones?direction=asc&sort=due_date&state=open #PostgreSQL
Milestones - pgxn/planning

Dummy repo to assign Organization Project items to - Milestones - pgxn/planning

GitHub
Show threadDavid WheelerSep 13, 2024

Turns out JWS-JS is nice: Include all the payload you want and sign it! Example I just ginned up for #pgxn:

https://gist.github.com/theory/ee1345659a3973365673cb7f3ccf926e

PGXN Release Metadata as JWS-JS object

PGXN Release Metadata as JWS-JS object. GitHub Gist: instantly share code, notes, and snippets.

Gist
TemboSep 13, 2024
It's been a while since the last update (5 months, not like we're counting) but there's been useful development on #PGXN and the Postgres core! The lowdown: https://tembo.io/blog/pgxn-v2-update
What’s New on the PGXN v2 Project | Tembo

A lot has happened in he five months since the last PGXN v2 update. The time has been used for continuing community discussions, planning, designs, and the start of implementation. Read on for a full accounting.

TemboSep 13, 2024
David Wheeler wrote an update on where the #PGXN v2 project is now. Spoiler: he's doubling down on Rust: https://tembo.io/blog/pgxn-v2-update #PostgreSQL
What’s New on the PGXN v2 Project | Tembo

A lot has happened in he five months since the last PGXN v2 update. The time has been used for continuing community discussions, planning, designs, and the start of implementation. Read on for a full accounting.

Show threadDavid WheelerMar 21, 2024

Video's up!

https://www.youtube.com/watch?v=k3VC_RFL1bQ&list=PL11N188AYb_aT6ulbJfrQJJziWb012jG3&index=2

#pgxn #postgres #extensions

Postgres Extensions Ecosystem Mini-Summit - March 20, 2024

YouTube
David WheelerFeb 22, 2024

The History and Future of Extension Versioning

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

#postgres #postgresql #pgxn

The History and Future of 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.

❖ Just a Theory
David WheelerFeb 20, 2024

RFC: Extension Metadata Typology

https://justatheory.com/2024/02/extension-metadata-typology/

#postgres #postgresql #pgxn

RFC: Extension Metadata Typology

Thinking through the PostgreSQL extension metadata use cases and recognizing the types of information they need.

❖ Just a Theory
Andreas ScherbaumJan 30, 2024

The #PostgreSQL #PGXN extension ecosystem is facing challenges, and David E. Wheeler (@theory) wants to tackle those. He needs your input!

Join the #extensions Slack channel and share your opinions.

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

PGXN Challenges

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

❖ Just a Theory