That's the point of my post.

There are subtle differences between SQLite and MySQL/Postgres. You should use the same database in dev, test and production.