Show HN: PLJS – JavaScript for Postgres

7•jerrysievert•3h ago

PLJS is a new, modern JavaScript trusted language extension, bundling QuickJS, a small and fast JavaScript runtime with Postgres, providing fast type conversion between Postgres and JavaScript, fast execution, and a very light footprint.

Here are bencharks that show how it compares to PLV8: https://github.com/plv8/pljs/blob/main/docs/BENCHMARKS.md

This is the first step toward a truly light-weight, fast, and extensible JavaScript runtime embedded inside of Postgres. The initial roadmap has been published at https://github.com/plv8/pljs/blob/main/docs/ROADMAP.md

You can join the discussion by joining the PLV8 Discord: https://discord.gg/XYGSCfVNBC

You can find PLJS at https://github.com/plv8/pljs

Comments

timz•2h ago

Amazing.. Would be nice to have something like that for Redis to replace Lua

phartenfeller•2h ago

Interesting. This is now the second DB next to Oracle[1] that can do JS (that I know of). pgSQL and PL/SQL of course still stay relevant but in the Oracle spehere the argument is that you can reuse existing code from NPM. Like this blog post [2] describes how to run an GraphQL endpoint from within the DB.

[1] https://docs.oracle.com/en/database/oracle/oracle-database/2... [2] https://blogs.oracle.com/developers/post/creating-a-graphql-...

jerrysievert•1h ago

PLV8 (the predecessor to this project) was released in June of 2012. It provided JavaScript as a trusted language extension to Postgres 9.2.

PLJS is a newer generation.

oulipo•2h ago

What would be the typical use-case? Light data transformation?

Is there a significant advantage over Rust-based embedded Postgres language like https://github.com/tcdi/plrust which is compiled and a bit more type-safe?

tehlike•1h ago

A lot of logic just becomes easier with javascript. If you have complex-ish trigger logic, or a procedure etc - doing these in pl/pgsql is just hard if not intracatable. Also allows up reuse of a lot of code that people have built with npm - even if not directly with require(), it becomes possible to bundle compiled binary.

I used this for storing patches of data (to save space, compression is a pain in Postgres) and applying runtime to show full version etc. It's fun.

The scam that is Visa Account Updater

Project Indigo, a Google Pixel-like computational photography camera app

The Tail at Scale

Fred Espenak, Astrophysicist Known as Mr. Eclipse, Dies at 73

Show HN: Anagnorisis, local data-management with trainable recommendation engine

Ultimadownloader

The Hollow Men of Hims

A Clean Break: A New Strategy for Securing the Realm

Roblox's back end scales to 30M concurrent players and over 21M for a experience

Why Did the Novel-Reading Man Disappear?

AI job replacement: Is the apocalypse coming for IT work?

Getting Gemini CLI to multitask safely [video]

Why AGI Is Impossible

Grete Hermann

Asana Picks Launch Darkly CEO Dan Rogers to Replace CEO Dustin Moskovitz

Cellular Entity Between Virus and Cell, encodes replication/not metabolism

The Implementation of Postgres (1990) [pdf]

Skeet – Hosted MCP Tools for Coding

After a week, Trump Mobile drops claim that Trump phone is "made in the USA"

This month in Servo: color inputs, SVG, embedder JavaScript, and more

Improving River Simulation

The AI Boom's Multi-Billion Dollar Blind Spot [video]

How is this not a grift?

Extended security patches for Windows 10 for Microsoft reward points

Show HN: Linux tool to save and recall memories quickly

Privacy Tools vs. Online Child Exploitation and Abuse

IBM's Dmitry Krotov wants to crack the 'physics' of memory

Disposable vapes may be more toxic than cigarettes, study finds

Show HN: A Go library that replaces sensitive data with realistic fakes

Scientists Retrace 30k-Year-Old Sea Voyage, in a Hollowed-Out Log