dinedal/textql on Hacker News

I really like the idea of https://github.com/dinedal/textql , which uses SQL to interact with file-based data stores. However, I don't understand why sq does the opposite—using a new DSL to access a database that already has a…

comment by novoreorx · 2024-10-08 · in Sq.io: jq for databases and more

I like textql [0] better for this use case, as it's simpler in my mind. [0] https://github.com/dinedal/textql

comment by MrDrMcCoy · 2023-11-29 · in Jaq – A jq clone focused on correctness, speed, and simplicity

▲ 1

Textql: Execute SQL against structured text like CSV or TSV

story by thunderbong · 2023-01-07 · 0 comments

As the author of textql ( https://github.com/dinedal/textql ) - thanks for the shoutout! Looks great, I love more options in the space for CLI based data analysis tools! Fantastic work!

comment by dinedal · 2023-01-06 · in Show HN: ClickHouse-local – a small tool for serverless data analytics

…bam, there's your query returned as a table. Handy for parts lists, inventory, that kind of crap. https://github.com/dinedal/textql https://gist.github.com/mojavelinux/8856117

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

…manuals. Refresh from PDM/PLM/LSA/Whatever. Rebuild for new parts data. Built on TextQL, natch https://github.com/dinedal/textql

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

…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

TextQL is a similar thing for CSV/TSV: https://github.com/dinedal/textql/ Also SQLite itself can query CSV files IIRC.

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

…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

You can do this with https://github.com/dinedal/textql as well, and a little easier as you don't need to import the data explicitly. SQL_QUERY=<<-EOS SELECT category.name AS category, composition.key, composition.composer, composition.name…

comment by dinedal · 2021-07-07 · in Show HN: SQLite query inside a Bash function

…http://harelba.github.io/q/ https://github.com/BatchLabs/charlatan https://github.com/dinedal/textql https://github.com/BurntSushi/xsv https://github.com/dbohdan/sqawk https://stedolan.github.io/jq/ https://github.com/benbern

comment by dima55 · 2019-11-23 · in An introduction to data processing on the Linux command line

…http://harelba.github.io/q/ https://github.com/BatchLabs/charlatan https://github.com/dinedal/textql https://github.com/BurntSushi/xsv https://github.com/dbohdan/sqawk https://stedolan.github.io/jq/ https://github.com/benbern

comment by dima55 · 2019-08-31 · in TSV Utilities: Command line tools for large, tabular data files

…in D lang by a mega corp. Some useful cli data wrangling tools -- https://github.com/BurntSushi/xsv https://github.com/dinedal/textql https://github.com/n3mo/data-science https://stedolan.github.io/jq/…

comment by JimmyRuska · 2019-08-31 · in TSV Utilities: Command line tools for large, tabular data files

…- http://harelba.github.io/q/ - https://github.com/BatchLabs/charlatan - https://github.com/dinedal/textql - https://github.com/dbohdan/sqawk (disclaimer: vnlog is my tool)

comment by dima55 · 2019-05-20 · in Show HN: UXY – adding structure to Unix tools

▲ 2

Textql

story by ScottWRobinson · 2018-08-05 · 0 comments

It's discussed in the README: https://github.com/dinedal/textql#key-differences-between-te... > sqlite import will not accept stdin, breaking unix pipes. textql will happily do so. > textql supports quote escaped delimiters, sqlite does…

comment by TAForObvReasons · 2018-04-07 · in TextQL: Execute SQL Against CSV or TSV

https://github.com/dinedal/textql#key-differences-between-te...

comment by scrollaway · 2018-04-07 · in TextQL: Execute SQL Against CSV or TSV

▲ 658

TextQL: Execute SQL Against CSV or TSV

story by TAForObvReasons · 2018-04-07 · 91 comments

There's been quite a bit of open source work in this space. https://github.com/dinedal/textql runs queries against CSVs on the command line. http://sheetjs.com/sexql/ runs queries against excel files in the web browser.

comment by TAForObvReasons · 2018-04-06 · in I wandered off and built an IDE

If you want something lighter to use text files as tables you could try TextQL: https://github.com/dinedal/textql .

comment by kwhitefoot · 2017-09-22 · in Recutils – Tools and libraries to access plain text databases called Recfiles

Really nice! I used https://github.com/dinedal/textql a bit, but your project seems much more practical.

comment by alexvay · 2017-06-30 · in Show HN: VisiData – vi for data

▲ 2

TextQL – Execute SQL against structured text like CSV or TSV

story by ergot · 2017-01-17 · 0 comments

▲ 3

TextQL: Query structured text like CSV or TSV via SQL alike language

story by devy · 2016-12-14 · 0 comments

Another tool like this, written in Go: https://github.com/dinedal/textql

comment by aargh_aargh · 2015-12-11 · in Q – Run SQL Directly on CSV or TSV Files

…simple to install. If Windows, IDK if it's easy or hard. Or you could try using a CSV plus textql https://github.com/dinedal/textql

comment by jrpt · 2015-07-31 · in SQL web interface for your own data?

See also: textql - Execute SQL against structured text like CSV or TSV GitHub: https://github.com/dinedal/textql HN: https://news.ycombinator.com/item?id=7175830

comment by _jomo · 2015-06-26 · in ThingieQuery: a SQL plugin for Excel

There are applications that let you query structured text with SQL. For example, https://github.com/dinedal/textql there are others as well.

comment by mhuffman · 2015-04-04 · in GNU Recutils – Tools and libraries to access plain-text databases

…right now it fills a gap not in CSVKit, which is the direct execution of SQL on flat files. [1]: https://github.com/dinedal/textql

comment by dinedal · 2014-05-27 · in CSVKit: CSV utilities that includes csvsql, csvgrep, csvstat, and more

…mentioned a similar project in Go called "TextQL." https://news.ycombinator.com/item?id=7290739 https://github.com/dinedal/textql

comment by rpicard · 2014-02-24 · in Q – Execute SQL on text. Supports joins across files, RPM available

…applies tokenization and throws the text into a temporary database. Quite similar to the Go project https://github.com/dinedal/textql , at least superficially.

comment by unwind · 2014-02-24 · in Q – Execute SQL on text. Supports joins across files, RPM available

https://github.com/dinedal/textql/issues/7

comment by dinedal · 2014-02-04 · in Execute SQL against structured text like CSV or TSV

https://github.com/dinedal/textql/issues/6

comment by dinedal · 2014-02-04 · in Execute SQL against structured text like CSV or TSV

https://github.com/dinedal/textql/blob/master/main.go around line 154: appears to make TEXT cols for everything. SQLite is pretty liberal about types so some math works anyway: sqlite> select "3"+"3"; 6 though note: sqlite> select "24" <…

comment by twotwotwo · 2014-02-04 · in Execute SQL against structured text like CSV or TSV

▲ 130

Execute SQL against structured text like CSV or TSV

story by mhausenblas · 2014-02-04 · 91 comments