"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.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.