Creating a Postgres Foreign Data Wrapper
dolthub.comI 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
I wince a little when someone suggests to throw away battle-tested solutions written in C just because someone wrote and unproven alternative in Rust.
Yeah, pgx is quite impressive and is a great set of bindings with very accessible examples, etc. Definitely something to be aware of for people that prefer building things in Rust. Thanks for pointing it out here.
I think the easiest is python https://github.com/Segfault-Inc/Multicorn
It does not work with recent versions of Postgres, it segfaults in some cases, and it has been mostly abandoned. Otherwise, it would be (and it has been) a great way to develop FDWs.
Yup, if someone picks up maintenance again then that can continue. But if that doesn't happen, we really need to stop mentioning/recommending it. I see it all over the damn internet, well after it became unmaintained.