r/programming • • Nov 16 '14

PostgreSQL vs. MS SQL Server - A comparison of two relational databases from the point of view of a data analyst

http://www.pg-versus-ms.com/
171 Upvotes

321 comments sorted by

View all comments

Show parent comments

4

u/Gotebe Nov 17 '14

MS SQL Server can neither import nor export CSV.

Dude... you found bugs (or one) in the way mssql handles CSV.

The thing obviously can import/export some CSV.

Shall I say it? Only fools think in absolute terms.

2

u/iBlag Nov 17 '14

I think the more pertinent question is: can <database> import/export CSV that is standards compliant (so far as those standards are unambiguous and complete)?

2

u/squareproton Nov 19 '14

Only fools think in absolute terms.

Is that absolute?

Dude... you found bugs

OK, firstly CSV is very very easy. Writing a CSV parser is orders of magnitude easier than, say, a JPEG decoder or a MP3 decoder or an XML parser or any of a hundred other things which always work perfectly whenever you use them. By comparison CSV is child's play.

Secondly, proper CSV support is vital for a structured data handling platform.

Thirdly, these are not mere bugs - they are massive, deal-breaking failures and feature omissions. If you're fortunate enough to always use CSV with no commas in the data and predictable field sizes, good for you. I (and many others) have virtually no control over the data we receive, other than to insist on standards compliance (which is what standards are for in the first place - providing a lowest common denominator to allow things to interoperate). In my direct experience and that of many others I know, MS SQL Server CSV functionality almost always fails.