Re:Appropriate Uses for SQLite
by pmontra on Monday February 12, 2018 @01:36PM
(#16360772)
That bite me more than once with Sqlite. I inherited small webapp with extremely messed up datetimes because Sqlite doesn't defend its data in any way. Same column, three different formats. Ouch. It's also a problem with the original developer but the database should not tolerate such mistakes.
[ Parent
| on HN ]
Re:Appropriate Uses for SQLite
by HumanDrivenDev on Monday February 12, 2018 @03:47PM
(#16361954)
One of my (many) tasks at my current position is to maintain a SQL Server database where a lot of the date times are stored as raw strings in various different formats.
If you're determined enough you can turn any datastore into a mess, though I suppose SQLite gives you less tools.
Though I would agree that the option to have stricter type checking in SQLite would be a good thing, I don't think your criticism is fair in this case, since it sounds like a case of poor discipline on behalf of the coder(s).