dcmoura/spyql
View on GitHub ↗ ★ 925 Jupyter Notebook
Query data on the command line with SQL-like SELECTs powered by Python expressions
13 mentions on Hacker News by 5 people: 5 stories, 8 comments · first 2022-01-24 · latest 2023-06-03
20082026
-
…SQL-like format. It’s not as complete but it cover most of the day-to-day use cases. Take a look at https://github.com/dcmoura/spyql (I am the author). Congrats on fq!
comment by dmoura · 2023-06-03 · in Fq: Jq for Binary Formats -
Here is a comparison of various SQL engines in command line: https://github.com/dcmoura/spyql/blob/master/notebooks/json_...
comment by zX41ZdbW · 2022-11-03 · in Command-line data analytics -
…It is more focused on CSV, but the commands would be the same if you were working with JSON. [1] https://github.com/dcmoura/spyql [2] https://danielcmoura.com/blog/2022/spyql-cell-towers/
comment by dmoura · 2022-11-03 · in JC – JSONifies the output of many CLI tools -
▲ 6
The fastest command-line tools for querying large JSON datasetsstory by zX41ZdbW · 2022-10-17 · 0 comments
-
…Well, even if you want to process a text file, ClickHouse will do it better than any other tool: https://github.com/dcmoura/spyql/blob/master/notebooks/json_... And ClickHouse looks like a normal relational database - there is no need for…
comment by zX41ZdbW · 2022-10-05 · in ClickHouse Cloud is now in Public Beta -
…and I'm pumped to see what you come up with next! [0]: https://github.com/cube2222/octosql [1]: https://github.com/dcmoura/spyql/blob/master/notebooks/json_...
comment by cube2222 · 2022-07-30 · in A SQLite extension for reading large files line-by-line -
…document. If you are interested in receiving updates, please subscribe to the following issue: https://github.com/dcmoura/spyql/issues/72 Thank you!
comment by dmoura · 2022-04-21 · in The fastest tool for querying large JSON files is written in Python (benchmark) -
▲ 12
The fastest tool for querying JSON files is *not* written in Python (revised)story by cube2222 · 2022-04-21 · 2 comments
-
…parser/compiler - and it's mainly some straight-forward regular expression replacements! https://github.com/dcmoura/spyql/blob/4b5ea3ff52875d2c1a544f... I'm very impressed - this is some very neat pragmatic software design.
comment by simonw · 2022-01-26 · in Show HN: SPyQL – SQL with Python in the middle -
▲ 2
Spyql: Query data on the command line with SQLstory by EntICOnc · 2022-01-26 · 0 comments
-
▲ 105
Show HN: SPyQL – SQL with Python in the middlestory by dmoura · 2022-01-25 · 45 comments
-
I am writing a language and CLI that mixes SQL with Python (spyql: https://github.com/dcmoura/spyql ), and it is interesting to see that we are tackling some of the same problems: - code/formula reutilization where we need to repeat logic…
comment by dmoura · 2022-01-25 · in PRQL – A proposal for a better SQL -
▲ 69
SPyQL – SQL with Python in the Middlestory by dmoura · 2022-01-24 · 1 comment