News for hackers. Stuff that matters.
Re:SQLite is not a toy database by dnautics on Thursday March 25, 2021 @05:58PM (#26586017)
> SQLite doesn't really enforce column types[0], the choice is really puzzling to me.

It's not the worst thing in the world; you're validating on data ingest anyways to prevent sqli, for example, right?

Re:SQLite is not a toy database by Sohcahtoa82 on Thursday March 25, 2021 @06:22PM (#26586332)
Data validation is a dangerous method to try to prevent SQL injection. The only surefire method is to used parameterized queries, which you should be doing anyways.
Re:SQLite is not a toy database by dnautics on Thursday March 25, 2021 @06:29PM (#26586416)
huh? By data validation I mean a validation library in your surrounding PL, it's flowing through the types of that language, and at no point is unprepared SQL entering your system.