HN

Need help?
<- Back
Pgrx: Build Postgres Extensions with Rust

Pgrx: Build Postgres Extensions with Rust

luu

Comments (15)

  • dukepiki
    PlanetScale's internal extensions -- Insights, Traffic Control, and pg_strict -- are all built in pgrx.Number of memory unsafety and race conditions I've had to debug in production in a year of use: zero.pgrx is fantastic.
  • levkk
    Amazing 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
  • K0nserv
    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.
  • tracker1
    The maintainers for this project are pretty nice all around. Very knowledgeable and as helpful as anyone could ask.
  • awesomeMilou
    I thought this was abandoned?
  • jpshastri
    Supabase is an interesting middle ground here — it runs on managed Postgres but gives you access to a curated set of extensions (pg_cron, pgvector, unaccent, PostGIS etc.) without needing to build your own. We used unaccent + GIN indexes for fuzzy city search and it worked well. Still not the same as arbitrary custom extensions, but covers a lot of practical use cases that RDS won't touch.