6 ms·
I work in a big, dumb enterprise with too many spreadsheets and Access databases. What made me move away from Excel spreadsheets: 1) As in the infamous case,
by tomlock 12y ago
I work in a big, dumb enterprise with too many spreadsheets and Access databases.
What made me move away from Excel spreadsheets:
1) As in the infamous case, its too easy to miss extending a range when you add new data[1]
2) There's no good way to manage concurrent access
3) Doing aggregates of aggregates is really hard
What made me then move away from Access databases:
1) Excel and Access attempt to guess the "type" of cell contents automatically, and this creates issues (Is 060E2 a product, or a scientific number? Of course, its 6000. Is 3/6/2015 a US date? Access will figure it out without you.)
2) There's still no good way to manage concurrent access
3) Storage limits still aren't that great if you want to deal with more than a few GB of data
For me the ideal spreadsheet would solve all these problems :) I moved to Postgres, instead.
[1]http://www.bloomberg.com/bw/articles/2013-04-18/economists-spreadsheet-error-upends-the-debt-debate http://www.bloomberg.com/bw/articles/2013-04-18/economists-s...