pgrx

hey hn, supabase ceo here this one might be more in of a “Show HN” because it’s a pre-release - something that you might want to try yourself or contribute to. The GitHub repo is here: https://github.com/supabase/wrappers For context, Postgres has Foreign Data Wrappers (FDW) [0]. These allow you to connect one Postgres database to another, and then query the secondary database directly in the first. CREATE FOREIGN TABLE other_database_table ( id integer, title text ) SERVER other_database; The data does not need to be “moved” to the primary database - it stays in the secondary and is fetched when you run a select query: select * from other_database_table; Our release today is a framework which extends this functionality to other databases/systems. If you’re familiar with Multicorn[1] or Steampipe[2], then

You might want to have a look at Pgx: https://github.com/tcdi/pgx

I love sqlite and rust extension which author has given gets me excited. Last week saw a similar project in rust to built Postgres extensions https://github.com/tcdi/pgx Hope I can play something interesting during vacations

For quick viewing, here's how it works in Postgres (using Yjs): create table posts ( id serial primary key, content crdt.ydoc default crdt.new_ydoc() ); insert into posts (content) values (crdt.new_ydoc()); update posts set content = content || crdt.new_ydoc() where id = 1; The heavy-lifting is done by the teams at Yjs[0] and Automerge[1], who have re-implemented their JS libs in Rust. This made it possible for us to wrap them into a Postgres extension using pgx[2] (which is fast becoming a de-facto tool at supabase) [0] Yjs: https://github.com/yjs/yjs [1] Automerge: https://github.com/automerge/automerge [3] pgx: https://github.com/tcdi/pgx

There's https://github.com/tcdi/pgx for writing extensions in rust.

> That thread led me to a project/product idea where you take an existing Postgres instance used for normal products or whatever, replicate it to various read only clusters with a custom search extension loaded and some orchestrator sitting on top (I’ve written most of one in rust that uses 0mq to communicate with it’s nodes) and create drop in search from existing databases with a nice guided web gui for automatic tuning suitable for most business use cases. Very interesting idea -- just want to add one thing, write it in rust (with pgx?[0]) :) [0]: https://github.com/tcdi/pgx

Hey HN, It turns out choosing a good database-optimized UUID (and deciding whether to use serial, etc) isn't quite so simple, and I finally got a chance to do some exploration, write about it[0]. One of the reasons Postgres is the best open source database out there is it's extensibility -- so I hacked up a small extension for generating some of the more exotic (but crucially, lexicograhically sortable) UUID generation mechanisms: https://github.com/t3hmrman/pg_idkit This idea has been bumbling around my head for a while, but I finally got a chance to build it while working with Supabase on a post about IDs[0]! Most of the heavy lifting is done by pgx[1] which is an amazing framework for building Postgres extensions in Rust. I think we are very early to the trend of amazing postgres extensions built in Rust, and it's yet another reason th

we used Oban for a very early product (which we put on ice) called Supabase Workflows: https://supabase.com/blog/supabase-workflows The reason we paused it was the realisation that it's far more powerful to co-locate this sort of product with the data. In this case, Workflows would be more powerful as a Postgres extension - you can store the workflows into your database, create them using SQL, and the workflows would have direct access to your operational data. We'll probably re-write this using pgx[0] at some stage (if anyone is reading this and wants to attempt this, please reach out). [0] pgx: https://github.com/tcdi/pgx

This is awesome -- really excited that Supabase is picking this up with their commitment to open source in general and PG in particular. Some prior art: - https://github.com/gavinwahl/postgres-json-schema (mentioned in the repo) - https://github.com/furstenheim/is_jsonb_valid pgx[0] is going to be pretty revolutionary for the postgres ecosystem I think -- there is so much functionality that would benefit from happening inside the database and I can't think of a language I want to use at the DB level more than Rust. [0]: https://github.com/tcdi/pgx

Yes! We've been exploring https://github.com/tcdi/pgx internally so we'd be able to re-work the hotspots in rust. We haven't decided to go that route yet but its been incredibly easy to work with & I'm psyched about what options it could open up like: - Stateless requests (no schema cache) - Subscriptions (via a background worker)

I wince a little whenever I see an introductory tutorial for Postgres extensions using C. pgx allows you to write Rust, and has lots of features to make your code type safe https://github.com/zombodb/pgx