When I started a project with SQLite, the available data types struck me as odd (coming from MySQL), but as I learned I started asking the question: are there any more fundamental data types other than null, int, real, text and blob? For example dates are just a facade for an integer of some kind, JSON is really just text adhering to certain formatting rules, booleans are usually stored as some kind of byte anyway so why not drop that abstraction?
With this limited set of datatypes it really makes you think harder about the data you are processing, because in the end all your data is one of these types anyway.
With this limited set of datatypes it really makes you think harder about the data you are processing, because in the end all your data is one of these types anyway.