Creating a Postgres Foreign Data Wrapper(dolthub.com)
dolthub.com
Creating a Postgres Foreign Data Wrapper
https://www.dolthub.com/blog/2022-01-26-creating-a-postgres-foreign-data-wrapper/
6 comments
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
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.