SQLite's default behavior has surprised me too many times.
I have end up spending time fixing errors only happens on dev environment which is quite frustrating.
So migrating the local test database from SQLite to Postgresql.
Actually test on Postgresql was also necessary previously, but it was done with much manual work(creating database clone on aws).
SQLite's default behavior has surprised me too many times. I have end up spending time fixing errors only happens on dev environment which is quite frustrating.
It seems I am not the only one who thinks so. http://michael.robellard.com/2015/07/dont-test-with-sqllite-when-you-use.html https://news.ycombinator.com/item?id=10002142
So migrating the local test database from SQLite to Postgresql. Actually test on Postgresql was also necessary previously, but it was done with much manual work(creating database clone on aws).
So I'm searching for a solution to make a