Hacker GitHub

← All repos

harelba/q

View on GitHub ↗ ★ 10,361 Python

q - Run SQL directly on delimited files and multi-file sqlite databases

26 mentions on Hacker News by 24 people: 7 stories, 19 comments · first 2012-02-13 · latest 2023-03-25

Mentions per year 26 mentions · busiest year 2021 (6)
20082026
AllStoriesComments NewestTopOldest
  1. …/ exploration setup. Hope you like it! CSV utilities (still haven't pick a favorite one...): https://github.com/harelba/q https://github.com/BurntSushi/xsv https://github.com/wireservice/csvkit https://github.com/johnkerl/miller
    comment by lot3oo · 2023-03-25 · in icsp – Command-line iCalendar (.ics) to CSV parser
  2. …https://github.com/TomWright/dasel https://github.com/johnkerl/miller https://stedolan.github.io/jq https://github.com/harelba/q ...
    comment by guilhas · 2023-03-13 · in Nushell.sh ls | where size > 10mb | sort-by modified
  3. I think they're talking about https://github.com/harelba/q , which is not very fast.
    comment by cube2222 · 2023-01-06 · in Show HN: ClickHouse-local – a small tool for serverless data analytics
  4. I like using q for querying CSVs on the command line: https://github.com/harelba/q
    comment by alana314 · 2022-06-21 · in One-liner for running queries against CSV files with SQLite
  5. …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
  6. 9k stars and 5yrs old: https://github.com/harelba/q Why not call it like dnsq or dq like jq ( https://stedolan.github.io/jq/ ) did?
    comment by itake · 2022-04-18 · in Show HN: "q", a DNS query tool with support for UDP, TCP, DoT, DoH, DoQ and ODoH
  7. dsq references a benchmark done by q ( https://github.com/harelba/q/blob/master/test/BENCHMARK.md ) that indicates that octosql is significantly slower. However, octosql's GH repo claims otherwise. Does anyone have any real world…
    comment by newman314 · 2022-01-11 · in Dsq: Commandline tool for running SQL queries against JSON, CSV, Parquet, etc.
  8. …is useful for converting them to SQLite, and then exploring with Visidata or SQL queries. Q: https://github.com/harelba/q sqlite-utils: https://github.com/simonw/sqlite-utils
    comment by leonim · 2021-12-30 · in A fast SQLite PWA notebook for CSV files
  9. …as inspiration [0]. How did you go about developing against the Starlark API, any IDE support? [0] https://github.com/harelba/q/blob/master/pyoxidizer.bzl
    comment by alex_hirner · 2021-12-04 · in Compile Python applications into stand-alone executables
  10. …I'm the author of OctoSQL. Still actively developing a rewrite on the redesign branch. [0]: https://github.com/harelba/q [1]: https://github.com/dinedal/textql [2]: https://datasette.io [3]: https://github.com/cube2222/octosql
    comment by cube2222 · 2021-07-18 · in Show HN: Work with CSV files using SQL. For data scientists and engineers
  11. Is this similar to https://github.com/harelba/q ?
    comment by _1tan · 2021-07-18 · in Show HN: Work with CSV files using SQL. For data scientists and engineers
  12. …db from CSV/TSV (similar to sqlite's '.import') and then runs SQL on it, right? It appears so: https://github.com/harelba/q/blob/master/bin/q.py#L267 Regardless, simple utilities that expose SQL interfaces over arbitrary data are still…
    comment by bob1029 · 2021-06-07 · in Q – Run SQL Directly on CSV or TSV Files
  13. Also see https://osquery.io/ https://github.com/harelba/q
    comment by bmn__ · 2019-07-18 · in Show HN: OctoSQL – Query and join multiple databases and files, written in Go
  14. Looks like it is implemented in python(2) with use of the stdlib sqlite3 module. https://github.com/harelba/q/blob/master/bin/q
    comment by alex_stoddard · 2018-11-14 · in Q: Run SQL Directly on CSV Files
  15. Why not combine the approach and run SELECT statements from the command line? https://github.com/harelba/q I'm sure there are issues with this, but it seems pretty sane. Your sample query would read _something_ like: q 'SELECT * FROM…
    comment by passwordreset · 2018-10-03 · in Finding data items in one field that contradict data items in another field
  16. How is this different from https://github.com/harelba/q
    comment by berta · 2018-04-07 · in TextQL: Execute SQL Against CSV or TSV
  17. There is also the (impossible to google) https://github.com/harelba/q that lets you SQL over CSV and is unix pipeline friendly.
    comment by dajobe · 2015-08-16 · in Miller is like sed, awk, cut, join, and sort for name-indexed data such as CSV
  18. …not suffer from the ",,,,,," problem of CSV. [1] Here's the list of ones I have run into so far: * https://github.com/harelba/q * https://github.com/tobimensch/termsql * https://github.com/samuel/squawk * https://github.com/tjunier/sqawk…
    comment by networked · 2015-04-04 · in GNU Recutils – Tools and libraries to access plain-text databases
  19. There's also a tool named q to query text files: https://github.com/harelba/q
    comment by egeozcan · 2014-03-03 · in Q – A Data Language