Here are some reasons why you should be using SQLite with your apps:
It is fast
SQLite is an embedded database so the database engine g...
For further actions, you may consider blocking this person and/or reporting abuse
"But you can stick text data into an integer column without a problem."
OK, I give up - why would that be an advantageous thing?
I'm pretty sure my app would crash horribly if I started getting strings in my ints.
If you want to use SQLite as more of a datastore, perhaps to back a dictionary then the data type flexibility would be very useful.
If you are using it as a simple traditional database, I agree it is far less useful.
Don't forget: Apple's Core Data is also backed by SQLite.
Thanks a lot for sharing this post. I didn't know that SQLite was used in production. I used it for testing locally in dev environments.
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.
It works great for this use case but it also works well in production.
It's also used pretty often for mobile apps.
And, in case you never read it, you might enjoy How SQLite is tested :)
wow. i think i must use sqlite
I read it got much of its funding by aerospace companies. That's why SQLite has a humongous amount of tests.