Creating a Postgres Foreign Data Wrapper

Creating a Postgres Foreign Data Wrapper(dolthub.com)

35 points by reltuk 4 years ago | 6 comments

timClicks 4 years ago |

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

latenightcoding 4 years ago | |

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.

reltuk 4 years ago | |

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.

antman 4 years ago |

I think the easiest is python https://github.com/Segfault-Inc/Multicorn

frafra 4 years ago | |

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.

Tostino 4 years ago | | |

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.