3 ms·

It's also easy to create C language user defined functions: www.postgresql.org/docs/9.0/xfunc-c.html

• codetrotter 8y ago
  Since a lot of languages have FFIs for C this made me wonder, did anyone try to write a PostgreSQL extension in... Rust? Turns out a few people have been working on doing just that. * JSONDC, a PostgreSQL extension written in Rust. Latest commit about a month ago. 161 commits in total. Authors say “It is written in Rust and, being short, is a good skeleton project for other would be plugin authors who'd like to use Rust to write Postgres extensions”. https://github.com/instructure/jsoncdc https://github.com/instructure/jsoncdc * pgxr. Latest commit 20 days ago. 23 commits in total. “Write PostgreSQL extension functions (as stored procedures) using Rust.”. https://github.com/clia/pgxr https://github.com/clia/pgxr * RPGFFI. Latest commit about a year ago. 33 commits in total. “Imagine being able to create postgresql extensions in rust. We generate bindgen (0.29.1) pg apis for [...]”. https://github.com/posix4e/rpgffi/ https://github.com/posix4e/rpgffi/ * postgres-extension.rs. Latest commit over 2 years ago. 23 commits in total. “Library to write Postgres extensions in Rust! Overall, the Postgres codebase has some pretty narly C macros everywhere, so we have to work around them a little bit.” https://github.com/thehydroimpulse/postgres-extension.rs https://github.com/thehydroimpulse/postgres-extension.rs