alt Hacker NewsThe 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
Replies
rswail • today at 7:27 AM
Excel 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.
harvie • today at 8:53 AM
or reimplement excel with sqlite as a backend :-D
BTW sqlite can run SQL queries on CSV files with relatively simple one-liner command...
Excel is made for calculations. But if you make it hard to make a DB, people will abuse Excel as a DB.