Wranglify
Wranglify- an offline delimited data workbench
What it does
Open or paste a 1GB data export, repair the encoding, split a column at a delimiter, mask the PII, and get real SQL out. Create and edit SQLite databases, flatten nested JSON/JSONL/NDJSON in one click into columns- then quick pivot, Vega lite chars, and export in any format you want. Private, offline, 10 MB. Save your pipeline of clean up steps, and run it through your terminal against any files whenever you want, automated cleanup for ingestion. Fully Themeable with custom themes!
Open the 500 MB export, repair the encoding, split the column, mask the PII, and get real SQL out. Private, offline, 10 MB. Mac and Windows now, Linux next.
, not a heading. This is the wordmark, and it now sits ABOVE the h1 rather than below it: as a heading it would make the brand name the document's first outline entry and push the descriptive h1 under it, which is backwards for anything reading the page as a document. Sized like a hero regardless, which is styling rather than semantics. --> Wrangl ify_ Flatten it with one click. Run it over a batch of files in a click. CSV too big to open in excel, too sensitive to paste into an online converter, and too messy for anything that only does one thing. Wranglify opens it on your own machine, shows you what is wrong, and lets you fix it one reversible step at a time. Nothing is uploaded, because…from wranglify.app
Does the same job
all alternatives →- DCDatasette – Create and publish an API for SQLite databases2017 · simonwillison.net · ▲269
Glitch Instant Database Starters2021 · ▲159Build a database-backed full-stack app in under a minute.
- DPDatasette Publish – Turn CSVs into a SQLite-Backed JSON API2018 · publish.datasettes.com · ▲101
- SQSQLite query inside a Bash function2021 · ▲134
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
More growth this month
the category →
AstraPixels▲267A pixel-art solar system at its real current positions.
Growth · 29d ago · astrapixels.com
Launched alongside, August 2026
the whole month →- TL
Life & fun · 10d ago · louisabraham.github.io
- SA
Hello HN! I found that picking out plausible but diverse skin tones for my digital art and game development projects was kind of difficult, and I got curious about if there was a way to define a color space that made it easy. I've built a color picker and procedural generation algorithm based on the space as well as a bunch of other fun js features and demos throughout the page that use the equations. If you find it interesting, I have lots of explanations of how I built it and what properties the space has. The methodology might be a bit shaky, but hopefully the result is as helpful for…
Life & fun · Aug 2026 · toneyalexander.github.io
I trained a 125M-parameter transformer to autocomplete piano performances in real time (~108 notes/sec on an iPhone 15). The idea is basically GitHub Copilot or Tabnine, except instead of prompting it with code, you prompt it by playing a few notes on a MIDI piano. The model then continues what you played, entirely on-device. The app is free if anyone wants to try it. Happy to answer questions about the model, training, Core ML, or the many things that didn't work.
AI · 16d ago · simedw.com