I noticed that I have a “date” field type as INTEGER in a SQLite database. That field houses data in the format YYYY-MM-DD, and obviously should be TEXT instead. Is there a negative consequence to changing it to TEXT now that it has data in it? I imagine not, since SQLite data is not stored in rigid data types to begin with.
No… and there is no real danger in leaving it as is, unless you (or other) app uses the Table DDL for specific purposes
and technically… SQLite has NO DATATYPES at all… but Data Affinities (similar, but not the same)
Tadpole should let you change it