csvz
csv2sqlite
| csvz | csv2sqlite | |
|---|---|---|
| 3 | 1 | |
| 30 | 10 | |
| - | - | |
| 4.4 | 3.0 | |
| over 3 years ago | about 1 year ago | |
| Go | ||
| Creative Commons Zero v1.0 Universal | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
csvz
- CSVZ: Zipped CSV files with optional metadata (2020)
-
Why isn’t there a decent file format for tabular data?
I put some work into creating a standard, csvz, for putting csv files and their metadata, into a zip file.
https://github.com/secretGeek/csvz
It’s a pretty powerful concept.
SimonW’s preferred technique of using sqlite as the means of exchange is also very powerful. Particularly when combined with all of the utils he maintains.
- It's Time to Retire the CSV
csv2sqlite
-
It's Time to Retire the CSV
CSV files are terrible, but I love them. I love sites that offer an "Export to CSV" option, because I know I can take that export and start working with it immediately. I can give that CSV file to my Dad, who can open it in Excel, or I can run a single command[0] to import it into a sqlite database.
It is a lowest common denominator format. That type of thing is incredibly hard to kill unless you can replace it with something that is simpler. Good luck with that.
[0]: https://github.com/psanford/csv2sqlite
What are some alternatives?
odiff - The fastest pixel-by-pixel image visual difference tool in the world.
ndjson.github.io - Info Website for NDJSON
cyanide - BSON documents in Elixir language
hsv5 - HTML5 Based Alternative to CSV, TSV, JSONL, etc
naya - A fast streaming JSON parser written in Python
parquet-wasm - Rust-based WebAssembly bindings to read and write Apache Parquet data
simdjson - Parsing gigabytes of JSON per second : used by Facebook/Meta Velox, the Node.js runtime, ClickHouse, WatermelonDB, Apache Doris, Milvus, StarRocks
ndjson-spec - Specification
datasette - An open source multi-tool for exploring and publishing data