Hacker News new | past | comments | ask | show | jobs | submit login

I would argue that it is not much harder than using Excel.

But there are good reasons where you don’t want random people running sql queries on production database or having direct access to the data.




About 90% of Excel spreadsheets contain errors according to some evidence:

https://www.zdnet.com/article/excel-errors-microsofts-spread...

I have seen this multiple times. Got called into a corp. audit once because CFO's spreadsheet didn't match reports from database. His SUM() function was missing some rows, ZIP Codes got converted to scientific notation and he didn't know why, that kind of thing.


Seems like that’s my point making excel calculations correctly is at least as hard as doing calculations with SQL.

If you get experienced db guy to do excel I bet he will do it correctly.

If you get “data jockey”, whatever tool he gets it will be a mess.


Maybe I’m misreading, but “not much harder than” implies SQL and Excel aren’t that hard to learn. “At least as hard as” implies both are similarly difficult.


I would say that yes they are similarly difficult.

Getting basic queries or basic calculations in spreadsheet a person can learn in couple hours.

Somewhere after that comes zone "proficient enough to shoot himself in the foot".

Then there is level of excel or SQL where without months of experience you simply don't know what is happening.




Consider applying for YC's Summer 2025 batch! Applications are open till May 13

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: