Any downsides to using SQLite locally?

I'm considering just using SQLite for local development...

First thing I ran into today... strict type checking against an integer "broke"

MySQL - Works

some_number !== integer_from_mysql

SQLite - Doesn't Work

some_number !== integer_from_sqlite

Not sure if this is actually SQLite NOT being able to spit out integers or not, even though they are specified as an integer in the data schema, I'm going to test this...

Just wanted to know what everyone thinks. Is this a bad thing to do? Dangerous?

It seems VERY stupid and broken to me that the above code doesn't work correctly. This caused me a massive headache this morning.