News for hackers. Stuff that matters.
Re:Q: Run SQL Directly on CSV Files by z92 on Thursday November 15, 2018 @03:00AM (#18457642)
Usability suffers, if you can't type the delimiters easily.
Re:Q: Run SQL Directly on CSV Files by hyperbovine on Thursday November 15, 2018 @03:51AM (#18457831)
I can’t stand it when I’m banging out a CSV by hand and have to manually escape the field and record separators. Happens all the time.
Re:Q: Run SQL Directly on CSV Files by z92 on Thursday November 15, 2018 @09:47AM (#18459586)
I use TSV for that reason. Most of the time you don't need to escape anything. And from code you need to escape/unescape only 4 chars. \t \n \NULL and \\.
Re:Q: Run SQL Directly on CSV Files by dghf on Thursday November 15, 2018 @05:29AM (#18458233)
In a terminal, Record Separator is CTRL-^, Unit Separator is CTRL-_. Vi[m] will accept the former literally, and will accept the latter if escaped with a CTRL-V.