Re:The next generation of spreadsheets will be a database
by andybak on Wednesday June 03, 2015 @06:57AM
(#9651709)
You're both correct and slightly missing the point.
Normal people use spreadsheets. These spreadsheets then grow into monsters.
What's needed is an invisible migration path so that people use what they understand but have somewhere to grow when they start abusing formulae to do what a real RDMS would do naturally.
It's essentially a UX problem - to all extents and purposes a database == a spreadsheet with multiple sheets - as soon as you start defining relationships between the sheets.
Normal people use spreadsheets. These spreadsheets then grow into monsters.
What's needed is an invisible migration path so that people use what they understand but have somewhere to grow when they start abusing formulae to do what a real RDMS would do naturally.
It's essentially a UX problem - to all extents and purposes a database == a spreadsheet with multiple sheets - as soon as you start defining relationships between the sheets.