News for hackers. Stuff that matters.
Re:Why Uber Engineering Switched from Postgres to MySQL by nawitus on Tuesday July 26, 2016 @03:02PM (#12168017)
You don't need to close the database connection to not have an open transaction, right?
Re:Why Uber Engineering Switched from Postgres to MySQL by jedberg on Tuesday July 26, 2016 @03:08PM (#12168051)
No you don't. But depending on the ORM, some of them batch writes unless you explicitly tell them not to, but will flush when you close the connection. So some programmers will just close the connection because they don't understand the difference or because they've learned that closing the connection guarantees that the data is written.
Re:Why Uber Engineering Switched from Postgres to MySQL by mschuster91 on Tuesday July 26, 2016 @03:35PM (#12168205)
> So some programmers will just close the connection because they don't understand the difference or because they've learned that closing the connection guarantees that the data is written.

To be fair, this problem isn't limited to databases. Filesystems, even HDDs/SSDs, have been known to readily ignore flush() calls in order to achieve better benchmark results.