Hacker News Reader

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.

View on HN

Which 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.

There are STRICT tables in newer versions of Sqlite

I 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.

There 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.

I mean if you write database code in PHP or JS fair enough but you're fucking doomed if you do anyway.

Reply on news.ycombinator.com