Pgrx: Build Postgres Extensions with Rust
95 points - last Saturday at 8:16 AM
SourceAmazing project that spawned entire companies. We used it to build postgresml[0] and most Postgres extensions are built on top of it these days.
[0] https://github.com/postgresml/postgresml
Amazing, I didn't know this existed.
I built https://github.com/k0nserv/plid with Pgrx and had a great time. I did have to scale back some of the magic (dropping derive PostgresType etc), but even so the support pgrx provides is excellent. I also talked to the maintainers a bit in discord and they were super helpful.
The one downside of custom extensions is that you arenβt, AFAIK, able to use them with many hosted Postgres installs, notably AWS RDS.
Or rather β one of the downsides of many hosted Postgres installs, notably AWS RDS, is that you're not able to use the extensions you want.
Indeed, that's a much better formulation.