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.
[ Parent
| on HN ]
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.
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 \\.