multiprocessio/dsq on Hacker News

There's also DSQ which uses SQL instead of its own language. https://github.com/multiprocessio/dsq

comment by wooptoo · 2025-03-22 · in fd: A simple, fast and user-friendly alternative to 'find'

…For the SQL part, but maybe a lot heavier, you can use one of the projects listed on this page: https://github.com/multiprocessio/dsq (No longer maintained, but has links to lots of other projects)

comment by bachmeier · 2023-11-02 · in Tracking SQLite Database Changes in Git

…have been mentioned, but another very simple one, a single dependency-free binary, is https://github.com/multiprocessio/dsq Not affiliated, just a happy user

comment by PhilippGille · 2023-06-28 · in Using command line to process CSV files (2022)

You can try this one too https://github.com/multiprocessio/dsq

comment by guilhas · 2023-03-13 · in Nushell.sh ls | where size > 10mb | sort-by modified

What is the general opinion about Nushell and this tools (or others)? https://github.com/multiprocessio/dsq https://github.com/jqnatividad/qsv https://csvkit.readthedocs.io/en/latest https://github.com/kellyjonbrazil/jc…

comment by guilhas · 2023-03-13 · in Nushell.sh ls | where size > 10mb | sort-by modified

Welcome to the gang! :) https://github.com/multiprocessio/dsq#comparisons Realistically though aside from the variety of input formats that DuckDB doesn't (yet) support, I think most people should probably use DuckDB or ClickHouse-local.…

comment by eatonphil · 2023-03-03 · in DuckDB: Querying JSON files as if they were tables

dsq [0] [0] - https://github.com/multiprocessio/dsq

comment by brihter · 2022-12-20 · in Ask HN: Programs that saved you 100 hours? (2022 edition)

…so you can i.e. join with a Postgres table. [0]: https://github.com/apache/arrow-datafusion [1]: https://github.com/multiprocessio/dsq [2]: https://github.com/cube2222/octosql Disclaimer: Author of OctoSQL

comment by cube2222 · 2022-11-03 · in Command-line data analytics

…numerous statistics, url, math, string, and regexp functions that aren't part of the SQLite base. ( https://github.com/multiprocessio/dsq#standard-library ) Ah, I wondered if they rolled their own SQL parser, but no, I now see the…

comment by mdaniel · 2022-10-06 · in Jq Internals: Backtracking (2017)

dsq works for me: https://github.com/multiprocessio/dsq

comment by bachmeier · 2022-10-06 · in Jq Internals: Backtracking (2017)

…underlying pieces into a standalone CLI, so they both support the same range of sources. dsq CLI - https://github.com/multiprocessio/dsq DataStation desktop app - https://datastation.multiprocess.io/ Two alternative CLI tools that I looked…

comment by sjellis · 2022-09-25 · in Run SQL on CSV, Parquet, JSON, Arrow, Unix Pipes and Google Sheet

…[1]. Whichever tool you end up using, I'm sure it will help out with your CLI data exploration! [0] https://github.com/multiprocessio/dsq#comparisons [1] https://github.com/multiprocessio/dsq#benchmark

comment by eatonphil · 2022-09-21 · in Q – Run SQL Directly on CSV or TSV Files

…with different set of tools [3] including duckdb. Everyone should check out duckdb. :) [0] https://github.com/multiprocessio/dsq [1] https://github.com/multiprocessio/go-sqlite3-stdlib [2] https://github.com/multiprocessio/dsq#comparisons…

comment by eatonphil · 2022-07-16 · in OctoSQL allows you to join data from different sources using SQL

…I thought someone must have deleted the actions yaml files. This is a dangerous failure mode. https://github.com/multiprocessio/dsq/pull/82 Screenshot here: https://twitter.com/phil_eaton/status/1542168020516216832

comment by eatonphil · 2022-06-29 · in GitHub incident – now resolved

…can more easily combine with other extensions. That's not really possible with dsq right now. [0] https://github.com/multiprocessio/dsq [1] https://github.com/multiprocessio/go-sqlite3-stdlib [2] https://sqlite.org/forum/forumpost/ec944414f…

comment by eatonphil · 2022-06-25 · in Xlite: Query Excel and Open Document spreadsheets as SQLite virtual tables

…in Go. The Go evaluation code forms the backbone of another app you may have seen around HN, dsq: https://github.com/multiprocessio/dsq , which is a limited version of DataStation as a CLI for querying files with SQL. In the future I'd…

comment by eatonphil · 2022-05-31 · in Show HN: DataStation – App to easily query, script, and visualize data

…it still. Just sharing some observations. [0] https://github.com/multiprocessio/datastation [1] https://github.com/multiprocessio/dsq [2] https://github.com/itchio/wharf [3] https://github.com/itchio/butler

comment by eatonphil · 2022-04-29 · in Lies we tell ourselves to keep using Golang

…are many tools that help you do this like dsq [0] (which I develop), q [1], textql [2], etc. [0] https://github.com/multiprocessio/dsq [1] https://github.com/harelba/q [2] https://github.com/dinedal/textql

comment by eatonphil · 2022-04-26 · in Zq: An easier and faster alternative to jq

…dsq: CLI tool for running SQL queries against JSON, CSV, Excel, Parquet, and more - https://github.com/multiprocessio/dsq gron: Make JSON greppable - https://github.com/tomnomnom/gron jello: Filter JSON and JSON Lines data with Python…

comment by luckman212 · 2022-03-21 · in Ask HN: Local Tools for Viewing JSON

I've got a lot of good first projects for github.com/multiprocessio/datastation and github.com/multiprocessio/dsq. If you have any experience in Go it will be easy to get you up and running. I've already had a few students and…

comment by eatonphil · 2022-03-19 · in Ask HN: Who is looking for help on a project?

…continue working on my company, multiprocess.io. I am building github.com/multiprocessio/datastation and github.com/multiprocessio/dsq in public and they are used by a number of developers. I host a hacker Discord and a monthly virtual…

comment by eatonphil · 2022-03-01 · in Ask HN: Freelancer? Seeking freelancer? (March 2022)

…continue working on my company, multiprocess.io. I am building github.com/multiprocessio/datastation and github.com/multiprocessio/dsq in public and they are used by a number of developers. I host a hacker Discord and a monthly virtual…

comment by eatonphil · 2022-03-01 · in Ask HN: Who wants to be hired? (March 2022)

…the case, competition is good! Happy to chat more if you want. I love database projects! [0] https://github.com/multiprocessio/dsq

comment by eatonphil · 2022-01-26 · in Show HN: SPyQL – SQL with Python in the middle

Binaries are now available! https://github.com/multiprocessio/dsq#macos-linux

comment by eatonphil · 2022-01-15 · in Dsq: Commandline tool for running SQL queries against JSON, CSV, Parquet, etc.

…in the space like q, octosql, and textql. [0] https://news.ycombinator.com/item?id=29643835 [1] https://github.com/multiprocessio/dsq

comment by eatonphil · 2022-01-11 · in Dsq: Commandline tool for running SQL queries against JSON, CSV, Parquet, etc.