4 ms·
Sometimes people need to be saved from themselves. E.g. spreadsheets can have mistakes very quickly when people treat them as databases and start copying column
by HKH2 2y ago
Sometimes people need to be saved from themselves. E.g. spreadsheets can have mistakes very quickly when people treat them as databases and start copying columns between spreadsheets assuming that the primary keys (e.g. in one column) are identical while they happily add rows and move rows around.
- StableAlkyne 2y agoTo be fair, there are no good, accessible database tools around for your average non programmer user. Access tried to be this a decade ago, until MS started to let it die. So now, your only option is basically Excel. There's a reason it's the main thing people gravitate into.
- wuming2 2y agoClaris FileMaker was that tool. Easy to understand and provided clear separation between data and the rest. Bundled with Mac OS so everyone used it. It is now an expensive enclave.
- pjerem 2y ago> Access tried to be this a decade ago three decades ago :)
- albrewer 2y agoFor really simple databases, I've had limited success getting people to use a UI in front of SQLite: https://sqlitebrowser.org/ https://sqlitebrowser.org/