News for hackers. Stuff that matters.

A comment on Show HN: PRQL in PostgreSQL. Parent comment

Re:Show HN: PRQL in PostgreSQL by davedx on Monday February 19, 2024 @07:41AM (#39429118)
SQL is pretty great, but for some things (I thought the example in the readme was decent) it can be quite cumbersome. Stored procedures are very imperative (and hard to debug, depending on the platform IME). This seems like a more functional approach to stored procedures.

I don't think it's suggested that this replaces SQL. Use the right tool (and abstraction) for the job?

[ Parent | on HN ]
Re:Show HN: PRQL in PostgreSQL by lkuty on Monday February 19, 2024 @07:52AM (#39429221)
Maybe. I already think in terms of transformations (relational algebra and its closure property) when I write SQL and use a lot of CTEs. But I guess the functional way might help people see what's going on.
[ Parent | on HN ]
Re:Show HN: PRQL in PostgreSQL by CuriouslyC on Monday February 19, 2024 @08:46AM (#39429653)
I think the debuggability is the #1 issue with database-as-a-platform. Using notices to debug functions is such a poor workflow that even though I'm bullish on putting stuff in PG I avoid writing complex code might need to be debugged as an integrated unit.
[ Parent | on HN ]