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. ▲ 1
    Q – Run SQL Directly on CSV or TSV Files
    story by fouc · 2021-07-18 · 0 comments
  12. 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
  13. …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
  14. 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
  15. 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
  16. 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
  17. How is this different from https://github.com/harelba/q
    comment by berta · 2018-04-07 · in TextQL: Execute SQL Against CSV or TSV
  18. ▲ 3
    Run SQL directly on CSV files
    story by vinnyglennon · 2015-12-13 · 0 comments
  19. ▲ 5
    Q – Run SQL Directly on CSV or TSV Files
    story by reinhardt · 2015-12-11 · 2 comments
  20. 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
  21. …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
  22. ▲ 18
    Q – Run SQL Directly on CSV or TSV Files
    story by gorgas · 2014-11-05 · 8 comments
  23. 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
  24. ▲ 126
    Q – Execute SQL on text. Supports joins across files, RPM available
    story by harelba · 2014-02-24 · 43 comments
  25. ▲ 8
    Q - Treating Text as a Database
    story by rbanffy · 2013-10-14 · 1 comment
  26. ▲ 5
    Text as a Database - Linux tool for performing SQL-like statements on text data
    story by harelba · 2012-02-13 · 2 comments