Hacker News Reader

Comment by grumpydba | Hacker News Reader

It all depends on the ANSI_WARNINGS switch. Some clients set it, some don't. Thus you have to be explicit or you might have a NoSQL database.

You should also read about arithabort and arithignore.

As I told you, you need to study the database engine you are using. For Mssql too. So you assumed it's always on. The type of mystake some non diligent devs do with MySQL. Gives it an undeserved bad rep. A dba can help you and teach you the nuances. Ask them at your company.

There have been a considerable amount of efforts made to improve innodb. It's plenty fast and properly used, it's well behaved. Just like Mssql.

View on HN

You are talking past the person you are replying to. Parent comment points out that MySQL has quirks that helps you shoot yourself in the foot moreso than other engines. Eventually you will slip up, no matter how diligent you are. The argument is that it's easier to slip up and with more frequency in MySQL, so when faced with a choice there are safer alternatives.

> Parent comment points out that MySQL has quirks that helps you shoot yourself in the foot moreso than other engines.

It used to be true. Not so much anymore. Study the defaults on mysql 8.

To summarise: Broadly the grandparent is correct, but some of his problems have been addressed in a very new version of the database in question. Is that fair?

Most of the "problems" also exist in enteprise scale database server such as sql server and sybase.

If parent meant that sql server and sybase are no more than nosql data store, I beg to differ.

Those issues have been "fixable" in innodb for years using flags. This is getting old. I think people come in here to have accurate information.

> Most of the "problems" also exist in enteprise scale database server such as sql server and sybase.

You've repeatedly dumped a long string of personal attacks based on statements of fact that were fundamented rather well, and in spite of your repeated appeals to authority you've failed or refused to comment on the technical aspects and decided to react with attacks and repeated assertions that in your eyes other alternatives are not perfect. Perhaps its high tine for you to step away from the keyboard and think about what you've been doing in this thread and how you've decided to portay yourself in this discussion.

Please don't do flamewar or post personal attacks, even if another account is doing that.

https://news.ycombinator.com/newsguidelines.html

Reply on news.ycombinator.com