Re:Show HN: Pg_replicate – Build Postgres replication applic...
by imor80 on Saturday August 10, 2024 @11:12PM
(#41213759)
Agree, Rust and Postgres and a perfect match. It feels so much more productive to write Postgres tooling in Rust. E.g. we already have extensions like pg_graphql[0], pg_jsonschema[1] and wrappers[2] which use pgrx. We don't have plrust on the platform yet though.
Full disclosure: I'm a Rust Engieer at Supabase.
[0] https://github.com/supabase/pg_graphql [1] https://github.com/supabase/pg_jsonschema [2] https://github.com/supabase/wrappers
There's external tooling like his project, but postgres extensions in Rust are exciting.
Full extensions via pgrx have been cool to see, but plrust + pg_tle is also starting to show up.
If you aren't familiar with TLE (Trusted Language Extensions), it is a postgres extension from AWS that created some privileged interfaces for procedural languages (used for user-defined functions) to do some extra stuff. Right now it's mostly auth-related hooks but my hope is that it expands in the future.
Plrust is a procedural language extension for Rust, allowing user defined functions written in Rust.
The combination of those two could open up a world of rich extensions usable in managed hosted environments like RDS.