Hacker News new | past | comments | ask | show | jobs | submit login

"Documents are littered with commas."

It's trivial to change all those commas to something else before making the CSV file and importing into the database.

They can then be converted back to commas by processing the query result.

This type of conversion before storage is routinely done with other characters, such as newlines, quotes, etc. For example, look at the JSON for the 10mHNComments data dump.

Personally, from a readability standpoint, tabs drive me nuts. I am glad TSV is not the default.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: