7 ms·
This is nice. But less space-efficient than CSV when its strictly tabular, since CSV has columns legend on first row allowing 'pure' rows, whereas JSON will hav
by alcover 5y ago
This is nice. But less space-efficient than CSV when its strictly tabular, since CSV has columns legend on first row allowing 'pure' rows, whereas JSON will have to key every field, on every row.
- severak_cz 5y agoyou can have json lines where each line is json array
- hnlmorg 5y agoYour use case is literally the first item in the link I shared (and the reason I shared that link too): ["Name", "Session", "Score", "Completed"] ["Gilbert", "2013", 24, true] ["Alexa", "2013", 29, true] ["May", "2012B", 14, false] ["Deloise", "2012A", 19, true]
- karteum 5y agoI don't understand why people keep using CSV today while SQLite is MIT-licenced and can be used everywhere, has a very portable and lightweight implementation, has a stable file format with long-term commitment, and a good compromise on the type system that gives enough flexibility to be on par with CSV if some entries happen to have a different type...
- genericacct 5y agoInstalled base. You can bet there are thousands of AS/400s and similar architectures putting out CSVs. Also you cant get more lightweight than CSV, i have several microcontroller projects that output CSV.
- mason55 5y agoAre you suggesting sending around SQLite dbs as a data interchange format? Or to replace some other csv use case?
- karteum 5y agoYes exactly. As a data interchange format I think it is much better than CSV (more compact, faster, more efficient, less error-prone, etc.)
- martin_a 5y agoSwitch from the developer world to the business world and everybody has Excel to open the CSV files with the article information, the sales numbers and so on and can work with that. How do you even read data from SQLite to Excel? VBA? Some obscure connector? With CSV it's "import" or even "open file".
- hnlmorg 5y agoIronically Excels implementation of CSV is terrible. It’s constantly destroying data (eg large numeric and pseudo-numeric fields) not to mention the whole issue around any cell bringing with an equal symbol being converted into a function.
- martin_a 5y agoIt totally is, but that is was most people know, next to the XLS/XLSX files themselves.
- msh 5y agoAnd some localizations of excel uses semi colon instead of comma! So no interoperability.
- hulitu 5y agoHaha. Wait to see when you receive a file made in a different language ( for example an excel file with formulas created on a japanese language computer).
- smackeyacky 5y agoSqlite has an odbc driver that excel can use
- tsimionescu 5y agoBecause if I want to do a graph from some data, it's much much easier to open the csv in Excel (or LO Calc) and create a graph from a sum of the subset of three columns VS a fourth column than it use to write an SQL query.
- throwaway984393 5y agoDoes Excel support SQL? Because I feel confident that Excel+SQL would 100% replace Tableau and save us a million dollars
- smackeyacky 5y agoYou have been able to include the results of sql queries in excel for decades.
- kbelder 5y agoPlus Excel includes PowerQuery with the M programming language which lets you do everything you can in SQL, just slower and with more verbosity.
- nicoburns 5y agoExcel can't open SQLlite files
- smackeyacky 5y agoYes it can, using the sqlite odbc driver.
- nicoburns 5y agoDoes that work with File > Open with a stock Excel install? Does editing work seamlessly?
- smackeyacky 5y agoNo, but that's not why you would move your data to sqlite. I was only responding to the question of whether Excel could read it, which it can.
- hnlmorg 5y agoHe said open, not read. They're subtly different terms but the distinction is important.