4 ms·
The big difference is that every Windows computer (in a professional environment) comes with a very nice GUI tool for easily editing Excel files. A tool that ba
by dagw 3y ago
The big difference is that every Windows computer (in a professional environment) comes with a very nice GUI tool for easily editing Excel files. A tool that basically everybody know how to use. The same cannot be said for SQLite.
SQLite is great for storing application state and config options set from within the app, but it is a pretty terrible format for end users to edit.
- johannes1234321 3y agoWhile I'm not sure I'd be happy about "end users" to edit the Excel files as config. Somehow they get the cells mixed up and you get utter mess. And then excel confuses some value for a date and stores some other mess ... For a somewhat trained audience however it can be quite interesting for some specific problem domain ...
- eternityforest 3y agoWhy doesn't Microsoft just add SQLite to Excel, so your formulas can query it?
- btreecat 3y agoBecause how else would they push MS Access?
- btreecat 3y ago>SQLite is great for storing application state and config options set from within the app, but it is a pretty terrible format for end users to edit. I think you are conflating the file with the workflow. A proper UI is the solution to making something not "terrible for end users to edit".