hacken-in/website — pull request #318 by moonglum (2013-12-22 11:06:46+00:00)
Title: Test database = Dev database = Production database

Oh, SQL. You are so standardised. Totally awesome. If only NoSQL had a language like you :laughing: Ok, jokes aside.

MySQL and SQLite behave differently in subtle ways. This makes it hard to test certain things – and it is just eating time. The biggest differences I found to this point are in the timestamp area – which is unfortunately quite important to a calendar application. We once had problems with miliseconds. Now I have a problem with the `DATE` function returning different values on MySQL and SQLite. I don't really want to deal with that nonsense anymore.

Can we switch all databases to MySQL? I know, Postgres would be nicer – but do we want to have this effort now especially given #257? I think the transition to MySQL in tests is painless.