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.
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.