BigBash.it – Turn your SQL query into a bash one-liner

What it does

Converts your SQL select queries into an autonomous Bash One-liner that can be executed on almost any *nix device to make quick analyses or crunch GB of log files in csv format. Perfectly suited for BigData tasks on your local machine. They perform surprisingly well - thanks to the highly optimized unix tools such as sort and (m)awk - and are often even faster than DB queries for larger data sets. BigBash is open-source and you can find more information, for instance details on the supported SQL syntax, on the Github page . (trap "kill 0" SIGINT; export LC_ALL=C; find persons_*.csv.gz -print0 | xargs -0 -i sh -c "gzip -dc {} | tail -n +2"|tr $',' $';'|cut -d $';' -f2,3,4 |awk -F ';' '($3 ==…from bigbash.it

• 
  Bigbash – Generate bash one-liners from SQL queries on files without DB2016 · github.com · ▲9

  A converter that generates a bash one-liner from an SQL Select query (no DB necessary) - Borisvl/bigbash

• CQ
  CSVFiddle – Query CSV files with DuckDB in the browser2022 · csvfiddle.io · ▲64

  Import CSVs, write SQL, and instantly share it with anyone. Runs 100% in-browser, so you're in control of your data.

• 
  cq – Query CSVs using SQL2019 · github.com · ▲80

  Query CSVs using SQL. Contribute to jolmg/cq development by creating an account on GitHub.

• 
  FSQL – Search through your file system with SQL-esque queries2017 · github.com · ▲341

  Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.

• DU
  Duck-UI – Browser-Based SQL IDE for DuckDB2025 · demo.duckui.com · ▲213

  I built Duck-UI, a web-based SQL editor that runs DuckDB entirely in your browser via WebAssembly. No backend required. The Problem: Every time I needed to query csv, parquet, or even to play with SQL, I had to either: (a) spin up a Jupyter notebook (b) use the CLI (c) upload to a hosted service. Friction at every step (TOO MUCH to load a csv or even to test some sql (study)... The Solution: DuckDB's WASM runtime lets us run SQL analysis client-side. Load CSV/JSON/Parquet files from disk or URL, write SQL, get results instantly. Data stays on your machine. What It Does: SQL editor…

• 
  SQL query for CSV2022 · csv-query.com · ▲85

  Analyze CSV records using sql syntax right in your browser

• 
  /dev/null▲490

  a social network for devs

  Dev tools · 4d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 28d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 26d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 24d ago · openbot.run

• 
  Talanoa▲346

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 21d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 29d ago · corespeed.io

• 
  Web Design in 4 minutes▲1,624

  Learn the basics of web design in 4 minutes with this interactive tutorial.

  Life & fun · 2016 · jgthms.com

• 
  Buffer for Instagram▲640

  Plan, track, and analyze your Instagram marketing

  Growth · 2016 · buffer.com

• 
  Sans Francisco▲604

  A collection of tools and resources for designers

  Work · 2016

• 
  Nintendo Classic Mini▲593

  The NES is back... but it's mini!

  Life & fun · 2016 · nintendo.com

• 
  Highly for iOS▲573

  Medium-style highlighting in every app and website. 🖌

  Work · 2016

• 
  Drift 2.0▲569

  A scalable way to talk to your customers

  Growth · 2016 · drift.com