"In the world of data, CSV is the cockroach of file formats."
12 comments
@neauoire I even have an app for editing it: ModernCSV: https://www.moderncsv.com it's pretty pretty good and saves the round trip of import/export in other apps @neauoire And Excel is the database ~everyone (in white collar world especially) already knows how to use. (disclaimer for the reply guys: yes I know SQL isn't *that* bad, I love and use the hell out of PostgreSQL and SQLite too, but Excel is accessible even to accountants, which is the point) @neauoire I often tell the story of a CSV data exchange format that survived both the original systems that it was used to transfer between. There were fields in there that nobody knew what the source was or what it was used for downstream but just in case they keep the same value in there. The transport even changed from CSV files sent over FTP to a message queue, but inside the message json was the same old CSV formatted data. @neauoire it's a way to make poetry @neauoire honestly I love the stupidity of it haha. I use tsv where possible but have modules for both in lua. We use them for the translations in arco as it allowed the translation teams to use Excel which is their normal process. |
@neauoire I´ve heard it said that CSV is the AK47 of file formats.
It´s messy and capricious to handle, but it´ll always work.