4 ms·
> without it what would we have? In an ideal world, we would have pgsql (the PostgreSQL front-end) and AWK, and people who realize that thinking about the mode
by tuatoru 6y ago
> without it what would we have?
In an ideal world, we would have pgsql (the PostgreSQL front-end) and AWK, and people who realize that thinking about the model before you start playing with layouts and copy-pasting formulas is a good idea.
Edit: Excel is a Dunning-Kruger syndrome enabler. People think they can do data analysis because they can type "=sum(B1:B4)" into a spreadsheet.
- qayxc 6y agoWe seem to have wildly different definitions of the term "ideal"...
- hermitcrab 6y agoI last used AWK about 30 years ago. It seemed clunky then. Does it still output "Bailing out at line 1" regardless of the error?
- 7952 6y agoJust coincidentally I spent most of the last week converting a spreadsheet to Postgres. It is interesting how similar some of the formula functions are to SQL functions. All the functions are standalone and there are no methods on top of objects/types.