6 ms·
I built https://github.com/k0nserv/plid https://github.com/k0nserv/plid with Pgrx and had a great time. I did have to scale back some of the magic (dropping der
by K0nserv 5mo ago
I built https://github.com/k0nserv/plid 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.
- Wicher 5mo agoOr 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.
- K0nserv 5mo agoIndeed, that's a much better formulation.
- infogulch 5mo agoMaybe one of the reasons why hosted postgres often disallows extensions is due to security concerns from loading arbitrary machine code on a shared host. I wonder if pgrx changes the calculus here.
- phamilton 5mo agoFrom the same org as pgrx is https://github.com/pgcentralfoundation/plrust https://github.com/pgcentralfoundation/plrust, which _is_ supported on RDS (but not Aurora). Since it's a procedural language, you can't do things like create a new index implementation or something else super low level. But there's still a lot you _can_ do. Like implement a custom comparator for a custom type and then use that type in a btree index.