Is there an awk/perl style tool for on-the-fly one-liners with a SQL syntax?

This page summarizes the projects mentioned and recommended in the original post on /r/commandline

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • miller

    Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

  • xsv

    A fast CSV command line toolkit written in Rust.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • datasette

    An open source multi-tool for exploring and publishing data

    As well as the 2 CLI tools I mentioned in another comment, you might like to look at https://datasette.io, a great OSS tool by Simon Willison.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts