News for hackers. Stuff that matters.
Re:Creating a Postgres Foreign Data Wrapper by timClicks on Wednesday January 26, 2022 @02:43PM (#30090638)
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
Re:Creating a Postgres Foreign Data Wrapper by latenightcoding on Wednesday January 26, 2022 @03:23PM (#30091209)
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 by reltuk on Wednesday January 26, 2022 @03:38PM (#30091429)
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 by antman on Thursday January 27, 2022 @01:04AM (#30096766)
I think the easiest is python https://github.com/Segfault-Inc/Multicorn
Re:Creating a Postgres Foreign Data Wrapper by frafra on Thursday January 27, 2022 @08:49AM (#30100508)
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.
Re:Creating a Postgres Foreign Data Wrapper by Tostino on Tuesday February 01, 2022 @04:33PM (#30169668)
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.