My only question is if you really need a prefix before every value to say what type it is.
Any field in SQLite can contain any type, even if the schema says that a field should be INTEGER, it could have a TEXT, so it's necessary to specify what's the type of every single value
Indeed, unless it's a strict table, you can put gibberish in the type field (or forego giving a column a type altogether).
Any field in SQLite can contain any type, even if the schema says that a field should be INTEGER, it could have a TEXT, so it's necessary to specify what's the type of every single value
Indeed, unless it's a strict table, you can put gibberish in the type field (or forego giving a column a type altogether).