News for hackers. Stuff that matters.

A comment on PL/Rust 1.0: now a trusted language for Postgres. Parent comment

Re:PL/Rust 1.0: now a trusted language for Postgres by asah on Sunday April 09, 2023 @06:49PM (#35507237)
no seriously, PL/pgsql is pretty horrible and obscure. But aside from subjective comments, there's very few algorithms available for it, approximately 0% of engineers know it and it's not taught in school, has little tooling compared with a first class programming language, you can't run pl/pgsql code outside of PostgreSQL, and (tell me when to stop)

PL/PGSQL is fine for "a bit more than a SELECT statement" and for very simple algorithms of <50 LOC. Anything more and please use a first class language like plrust, plv8, etc.

[ Parent | on HN ]
Re:PL/Rust 1.0: now a trusted language for Postgres by ttfkam on Sunday April 09, 2023 @10:47PM (#35508683)
The decision between pl/pgsql and something like plv8 isn't LOC. It's whether the solution best fits a set-oriented model or a procedural model. Both are valid, just different use cases.

There are a lot of cases where plv8 will thrash back and forth between the internals of Postgres and C and its v8 engine. These are usually the cases where set theory dominates the solution space.

On the flip side, if you're doing a lot of filter/map/reduce on large JSON payloads, plv8 is demonstrably better than pl/pgsql.

Right tool. Right job.

[ Parent | on HN ]
Re:PL/Rust 1.0: now a trusted language for Postgres by pjmlp on Monday April 10, 2023 @03:08AM (#35509883)
The same engineers that use to rave about NoSQL a couple of years ago?
[ Parent | on HN ]