Q – Run SQL Directly on CSV or TSV Files

Re:Q – Run SQL Directly on CSV or TSV Files by vptr on Monday June 07, 2021 @10:57AM (#27423335)

I think I've seen several similar projects to this one. It always make me wonder how are these different from sqlite virtual tables (https://www.sqlite.org/csv.html)? And why would I want to use this over sqlite? Perhaps some API in python? But then again I could just run sqlite script and dump results into temp csv and read them back in any other lang of my choice.

[ Parent | on HN ]

Re:Q – Run SQL Directly on CSV or TSV Files by mikepurvis on Monday June 07, 2021 @11:39AM (#27423856)

I think the value here probably depends a lot on what it's doing under the hood. Like, if this is just a wrapper on importing to sqlite, building up an index, and running a query, then maybe there aren't a lot of use-cases.

But maybe it does something interesting with the fact that it can receive data in a stream?

[ Parent | on HN ]

Re:Q – Run SQL Directly on CSV or TSV Files by nonameiguess on Monday June 07, 2021 @01:12PM (#27425128)

There actually is a Python API for doing this: https://pypi.org/project/dataframe-sql/

It doesn't expose a CLI, though.

[ Parent | on HN ]

Re:Q – Run SQL Directly on CSV or TSV Files by cntlzw on Monday June 07, 2021 @11:36AM (#27423818)

Where would the world be if we just would stop innovating after the first idea that works?

[ Parent | on HN ]