nowfound

Dev tools · September 13, 2021

Columnq brings OLAP to Unix pipes

Create full-fledged APIs for slowly moving datasets without writing a single line of code. - roapi/columnq-cli at main · roapi/roapi

Columnq brings OLAP to Unix pipes launched on September 13, 2021 with 32 votes, #1,100 of 2,941 launches that month and more than 75% of that year's launches. The site was still online in September 2026, 5 years on.

Visit github.com ↗Alternatives

In plain words

Columnq is a Unix command-line tool that brings OLAP (online analytical processing) capabilities to standard Unix pipes. It allows users to perform multidimensional data analysis and aggregation operations on streaming data using familiar pipe-based workflows. The tool is designed for developers and data analysts who work in Unix environments and need analytical processing without leaving the command line. Columnq integrates with existing Unix tools to enable complex queries on structured data.

written from the facts on this page · September 2026

Does a similar job

all alternatives →
  • chdb2023 · clickhouse.com · ▲88

    Embedded SQL OLAP engine powered by ClickHouse

  • Hydra 1.0 – open-source column-oriented Postgres2023 · hydra-so.notion.site · ▲269

    hi hn, hydra ceo here hydra is an open source, column-oriented postgres. you can set up remarkably fast aggregates on your project in minutes to query billions of rows instantly. postgres is great, but aggregates can take minutes to hours to return results on large data sets. long-running analytical queries hog database resources and degrade performance. use hydra to run much faster analytics on postgres without making code changes. data is automatically loaded into columnar format and compressed. connect to hydra with your preferred postgres client (psql, dbeaver, etc). following 4 months…

  • SnapQL – Desktop app to query Postgres with AI2025 · github.com · ▲104

    SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand. Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.

  • KQ – Simple Job Queue for Python Using Kafka2016 · github.com · ▲116

    Kafka-based Job Queue for Python. Contribute to joowani/kq development by creating an account on GitHub.

  • Parqeye – A CLI tool to visualize and inspect Parquet filesNov 2025 · github.com · ▲167

    I built a Rust-based CLI/terminal UI for inspecting Parquet files—data, metadata, and row-group-level structure—right from the terminal. If someone sent me a Parquet file, I used to open DuckDB or Polars just to see what was inside. Now I can do it with one command. Repo: https://github.com/kaushiksrini/parqeye

  • LN
    LineaPy – New open source tool for automating data science workflows2022 · lineapy.org · ▲20

More dev tools this month

the category →
  • Run full iOS 16.5 firmware on Android Devices▲508

    Contribute to oosexgang/hackios-xnu-kernel development by creating an account on GitHub.

    Dev tools · 1d ago · github.com

  • /dev/null▲492

    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 · 29d 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 · 27d 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 · 22d ago · talanoa.email

Source: Show HN post ↗

Launched alongside, September 2021

the whole month →