Hacker News Reader

Comment by keithwarren | Hacker News Reader

see rest of comments, it is not taking long for people to point out the flaws in the OP

So that is a "no" then? You make a blatant argument from authority and then when asked to affirm your opinion with facts rather than claimed qualifications you refuse (saying "read the other posts" is a refusal if I've ever seen one).

In all honesty it would take hours to write a proper rebuttal. There are many factual errors but there are also many errors that are mostly incorrect. CSV import/export is one of the first things he calls out and he never mentions BCP or SSIS, which are the methods for CSV import in SQL Server. It would be like saying Apache does not support SSL - it is just factually wrong.

I've been using MS SQL Server for over 10 years, including versions as early as 2000. I have extensively used CSVs in every version

Then you're well aware of how broken MS SQL is when it comes to exporting CSVs where the delimiter is in one of the string fields or where a field has an EOL character, etc. PostgreSQL handles all of that with no problems whatsoever. MS SQL doesn't even attempt to follow RFC 4180.

I've actually written small wrapper scripts that feed a query into MS SQL, fetch the results row by row and--with a proper CSV writer (eg Python's csv, Perl's Text::CSV, etc), dump to file. It's relatively slow, but at least it works.

Reply on news.ycombinator.com