SQLite, technically, has no data types, there are storage classes in a manifest typing system, and yeah, it’s confusing if you’re used to traditional
RDBMSes. Everything, internally, is stored as text. Data types are coerced/converted into various storage locations based on affinities (ala data types assigned to columns).
The best thing that I’d recommend you do is to :
Temporarily forget everything you used to know about standalone database datatypes
Read the above link from the
Take the types based off of your old schema, and see what they’d map to in
Migrate all the data to the
Note: The datatype limitations can be cumbersome, especially if you add time durations, or dates, or things of that nature in
SQLite has very few built-in functions for that sort of thing. However,
SQLite does provide an easy way for you to make your own built-in functions for adding time durations and things of that nature, through the
sqlite3_create_function library function. You would use that facility in place of traditional stored procedures.