Show HN: A Postgres Extension to Write PostgreSQL Functions in TypeScript

1 point

2 months ago

Hi everyone! This is a PostgreSQL extension I've been working on that adds TypeScript procedural language support using the Deno runtime. It draws some inspiration from https://github.com/plv8/plv8 but aims to support full compatibility with TypeScript including es6 imports, async/await, and the entire node API surface area. It's written in Rust with pgrx.

Because it uses Deno under the hood, we get sandboxing "for free", and can enable or disable various features (filesystem, network etc...) via superuser Postgres GUCs.

It's still alpha quality software, but works reliably in my testing and I've implemented all of:

- Typescript support

- NPM Packages via deno import urls

- Complex Postges types like Record and JSONB

- An interface for calling back into Postgres

Try it out and open an issue with any feedback!