News for hackers. Stuff that matters.
Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by mr_toad on Sunday September 02, 2018 @10:43PM (#17899932)
A lot of data scientists and analysts favour PostgreSQL for ETL and heavy duty data manipulation. PL/pgSQL lets you perform fairly complex tasks on datasets that may be too large to handle in memory (e.g too big for R and pandas).

And unlike a lot of ETL and reporting tools it doesn’t involve a lot of pointing and clicking. You can put PL/pgSQL in version control along with your R and Python code. That’s very handy for repeatability.

There are no comments on this comment yet.