DuckDB Has Replaced JQ For Me
I reach for JQ almost every day. It’s fast, it’s everywhere, and for quick JSON inspection it’s hard to beat. But somewhere along the way I started using DuckDB for anything more complex, and I don’t plan to go back. Here’s how it works and when to use it. Getting Started Basic Setup First, ensure you have DuckDB installed # On macOS brew install duckdb # On Linux, Windows, or for you favourite programming language: # Follow instructions here: https://duckdb.org/docs/installation/ Sample Data We’ll use this example JSONL file (data.jsonl) throughout our examples: ...