4 ms·
The sane thing would be to ban Excel and promote SQLite. Excel is often used for tabulated text (issue tracking) not calculations. Perfect use case for a relati
by hermitShell 5mo ago
The sane thing would be to ban Excel and promote SQLite. Excel is often used for tabulated text (issue tracking) not calculations. Perfect use case for a relational db
- frollogaston 5mo agoExcel is made for calculations. But if you make it hard to make a DB, people will abuse Excel as a DB.
- TJSomething 5mo agoI mean, it might have been at first, but Microsoft figured out that the majority of users for lists without formulas in 1993 and they've strategized around that. IMHO, the biggest concession to this was when they added Power Query to core Excel in 2016.
- rswail 5mo agoExcel has sheets for tables, columns and rows, primary keys (UNIQUE), foreign key references etc if you squint. It doesn't require you use all of that properly, but it's there.
- 0123456789ABCDE 5mo agoand excel has gui for forms
- rantingdemon 5mo agoOnly where VBA is available. Not available for MacOs versions if I'm correct?
- nereye 5mo agoVBA is just there for backward compatibility. The modern alternative is to use JavaScript/TypeScript, which makes such solutions cross platform (including MacOs, web etc.): https://learn.microsoft.com/en-us/office/dev/add-ins/overview/office-add-ins https://learn.microsoft.com/en-us/office/dev/add-ins/overvie...
- harvie 5mo agoor reimplement excel with sqlite as a backend :-D BTW sqlite can run SQL queries on CSV files with relatively simple one-liner command...
- euroderf 5mo agoWell heck can't someone make an SQLite extension that is basically just a simplified Excel ?