3 ms·
Since free relational DBs like sqlite & mysql came along, only optimal use I see of spreadsheets "in the wild" now is psychological (i.e. real-time "massaging"
by krautburglar 1mo ago
Since free relational DBs like sqlite & mysql came along, only optimal use I see of spreadsheets "in the wild" now is psychological (i.e. real-time "massaging" of the numbers to overcome objections). For things that are more objective, we have so many superior options. Not just databases either. Jupyter & various other REPLs are also great.
- mannycalavera42 1mo agothis isn't how it works. Most of the people doing tech work are not tech-savvy That's why excel is the most used software in the world
- krautburglar 1mo ago> only optimal use
- lo0dot0 29d ago> Not tech savvy. Excel is tech , too.
- lo0dot0 29d agoAnecdotal evidence but when I used duckdb and Python and Pycharm the Pycharm table viewer was not working as well as Excel. The rendering was messed up. Could be related to the remote desktop rendering but still not as flawless as Excel. The patchwork of multiple software from different vendors needed to replace Excel with database plus viewer plus Code has downsides compared to the single app single file solution that is Excel.
- krautburglar 28d agoPersonal experience is opposite. Doing stats on millions of rows in any SQL is a one-liner. Working with more than a few screenfuls of data in Excel is a misery.