DEV Community

Discussion on: SQLite Rocks and Here's Why

Collapse
 
engineercoding profile image
Wesley Ameling

I actually encountered an issue with this. I updated a migration once to have a char(8) and accidentally updated a field to a string with 9 characters. Locally testing it with SQLite threw no errors, but on the CI my tests were failing and I couldn't figure out why.

Personal lesson learned: use the same rdbms as on production while testing.