pgrx

pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL `SQLITE` type is stored as a CBOR-encoded `Vec<u8>`. When a query is made, this `Vec<u8>` is written to a random file in the `/tmp` directory. SQLite then loads the file, performs the query, and returns the result as a table containing a single row wi

These days, for writing extensions/FFI pgrx[0] is the best crate. [0] https://github.com/pgcentralfoundation/pgrx

He's referencing pgrx: https://github.com/pgcentralfoundation/pgrx To be fair pgrx was mentioned in OP under a positive light, and OP did say he likes avoiding coding in C, so it was something to bring up.

Postgres. I don't code in C if I can avoid it, since it often feels like an awful lot of extra typing while still having to worry about memory safety. But the Postgres codebase is extraordinarily well organized and respects the humans that work with it with its intelligent handling of memory and judicious use of macros. I consider the core Postgres codebase to be the gold standard in development even though it's in a language I do not prefer to write in if given the choice. Shout out to the pgrx folks. You're awesome! https://github.com/pgcentralfoundation/pgrx

Yet another amazing postgres plugin made possible by pgrx (https://github.com/pgcentralfoundation/pgrx) It's really crazy how some projects just instantly enable a whole generation of new possibilities. If you are impressed like this and want to build something like it -- check out pgrx, it's a pretty great experience.

Consider also the companies and work behind pgrx [0] and pgzx [1]: [0] https://github.com/pgcentralfoundation/pgrx [1] https://github.com/xataio/pgzx

There is a separate project to build Postgres extensions with Rust: https://github.com/pgcentralfoundation/pgrx

If you like this (I do very much), you might also like pg_idkit[0] which is a little extension with a bunch of other kinds of IDs that you can generate inside PG, thanks to the seriously awesome pgrx[1] and Rust. [0]: https://github.com/VADOSWARE/pg_idkit [1]: https://github.com/pgcentralfoundation/pgrx

(disclosure, i work at supabase and have been developing TLEs with the RDS team) Trusted Language Extensions refer to an extension written in any trusted language. In this case Rust, but it also includes: plpgsql, plv8, etc. See [0] > PL/Rust is a more performant and more feature-rich alternative to PL/pgSQL This is only partially true. plpgsql has bindings to low-level Postgres APIs, so in some cases it is just as fast (or faster) than Rust. > Building a vector index (or any index for that matter) inside Postgres is a more involved process and can not be done via the UDF interface, be it Rust, C or PL/pgSQL Most PG Rust extensions are written with the excellent pgrx framework [1]. While it doesn't have index bindings right now, I can certainly imagine a future where this is possible[2]. All that said - I think there are a lot of hoops to