r/javascript • u/linuxhiker • 6d ago

GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql.

https://github.com/commandprompt/plx
2 Upvotes

75% Upvoted

2 comments sorted by

1

u/ppyyBest 3d ago

I’ve found transpiled PL/pgSQL layers most useful when the function logic is simple and the team already knows the source language. Once you hit a performance bug or a type mismatch, debugging through the generated SQL is much harder than writing native plpgsql from the start. I’d keep it for small glue code rather than complex stored procedures.

1

u/linuxhiker 3d ago

No doubt. The real purpose of this is to lower barrier of entry.