Live data from Hacker News

Creating a Postgres Foreign Data Wrapper

dolthub.com

1–7 of 7 posts

Re: Creating a Postgres Foreign Data Wrapper

#3

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.

Re: Creating a Postgres Foreign Data Wrapper

#4

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

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.

Re: Creating a Postgres Foreign Data Wrapper

#7
post #6
post #5

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.