News for hackers. Stuff that matters.
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.
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.

Re:Appropriate Uses for SQLite by Cyberdog on Monday February 12, 2018 @02:50PM (#16361446)
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).