Tad: A fast viewer for CSV and Parquet files and SQLite and DuckDb databases that supports large files. <-- Nice alternative to (in no order) dirtylittlesql.com, graphext, knime, visidata, datasette, xsv, csvkit, R tidyverse with arrow, python pandas / dask, as well as the traditional grep / uniq / cut / sed / awk / sort / uniq etc
- Discovered Sep 20, 2022 17:49 Tad: A fast viewer for CSV and Parquet files and SQLite and DuckDb databases that supports large files. (via this tweet from Antony Courtney which was in response to Simon W’s tweet: If someone gives you a CSV file with 100,000 rows in it, what tools do you use to start exploring and understanding that data? )
Previously
- March 2022: 2021 SUMO Firefox Desktop Support Questions in a SQLite file: 317 questions on June 4, 2021 about Firefox look and feel changes in Firefox 89 (used DB Browser for SQLite, csvstack, csvs-to-sqlite)
- February 2020: SQLite, JSON, CSV :-) the eternal golden braid of formats? so many tools for normal folks to grok them without programming e.g. sqlitebrowser
- April 2019: How to use mlr (miller) to create an id, url CSV file from a file of ids by concatenating ‘support.mozilla.org/questions/’ to the id
- October 2018: Mr Data Converter converts CSV to JSON, HTML, JSON, XML, Python, ruby, etc