4 ms·
Finding out that there are just 5 datatypes and that BIGINT, VARCHAR, BLOB, etc. are just mapped onto those was actually a breath of fresh air.
by joseferben 3y ago
Finding out that there are just 5 datatypes and that BIGINT, VARCHAR, BLOB, etc. are just mapped onto those was actually a breath of fresh air.
- cm2187 3y agoWhich I think is fine (though you could make a case for a proper datetime type). What I am a lot less of a fan is the dynamic typing, ie that if you have an int column, sqlite will happy store a string in there. I am not sure why they do that but to me, it lets some bugs go unnoticed.
- config_yml 3y agoThere are STRICT tables in newer versions of Sqlite
- ilyt 3y agoI saw that complaint but for all purposes it's a moot issue If your code allows it you're fucking doomed anyway and will have multiple other type-related problems all over the codebase.
- richbell 3y agoThere are a variety of ways that bugs like that could sneak through a codebase. I was taught to think of a RDMS as the last line of defense against data integrity issues. SQLite, on the other hand, is more than happy to let you shoot yourself in the foot.
- ilyt 3y agoI mean if you write database code in PHP or JS fair enough but you're fucking doomed if you do anyway.