Back to browse
GitHub Repository

A PostgreSQL extension that adds TypeScript as a procedural language

9 starsRust

pg_typescript, a Postgres extension for writing functions in TypeScript

by idd2·Mar 16, 2026·2 points·0 comments

AI Analysis

●●SolidNiche GemBig Brain

TypeScript in Postgres beats plv8's plain JavaScript with actual type safety.

Strengths
  • Deno's permission model provides sandboxing without sacrificing Node.js API compatibility.
  • npm packages cached at CREATE FUNCTION time avoids runtime dependency hell.
  • Automatic type mapping between PostgreSQL composite types and JavaScript objects.
Weaknesses
  • Alpha status with explicit production warnings limits immediate adoption.
  • V8 runtime cold-start requires shared_preload_libraries configuration.
Target Audience

PostgreSQL developers, backend engineers writing database functions

Similar To

plv8 · pg_js

Similar Projects