We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)

Re:We’re happy with SQLite and not urgently interested in a ... by Someone1234 on Friday May 04, 2018 @02:11PM (#16996801)

I'm talking about business to business transactions, as in automated transactions on VANs and similar data interchanges.

The industry doesn't really use XLSX or XLS because they're unreliable to parse without Microsoft's Office libraries which require Windows licenses, and the two formats have a huge amount of overhead compared to XML formats and CSV (which costs money on VANs).

This is a space where plain text files and binary is still king. Formats like EDI are still massive. In many ways CSV and XML are the new kids on the block.

Only end users are sending Excel formatted files (and PDFs) to one another.

[ Parent | on HN ]

Re:We’re happy with SQLite and not urgently interested in a ... by merb on Friday May 04, 2018 @04:46PM (#16998166)

> The industry doesn't really use XLSX or XLS because they're unreliable to parse without Microsoft's Office libraries

XLS yes, however XLSX is just easy to parse if you document only contains simple types. of course with embedded mathml/wordml it gets a little bit wierd.

[ Parent | on HN ]