5 ms·
Just because a tool is well liked and widely used does not mean that it is well-designed or immune from criticism. "But it's popular" or "but I like it" really
by da_chicken 5y ago
Just because a tool is well liked and widely used does not mean that it is well-designed or immune from criticism. "But it's popular" or "but I like it" really aren't a defense of any criticism at all. At best they merely express disagreement with it, but in this case they're more or less orthogonal to it.
I have and do use SQLite. That doesn't mean I'm incapable of recognizing and understanding a design flaw when I see one, nor that I'm unwilling to point one out for fear of upsetting those who simply haven't experienced it.
- at_a_remove 5y agoI would have agreed with that until you hit the "nearly everyone" bit. That's my "evidently not."
- da_chicken 5y agoOkay, but how many are using it because of the type model versus those who are using it for any other reason and just putting up with it? You can't claim every use of the software is because of every feature or quirk.
- at_a_remove 5y agoI claimed "I could see people who are super-cereal about types getting bunged up about it in SQLite" ... which seems to have been borne out. If you don't know what your data looks like because you're just wading into filthy data, being loose about your types is not the worst thing in the world. That's all. You know the progression. You get this file, claims were made about what was in the file and its structure, its data, but then you realize that these claims are ... aspirational at best. You open it up in a notepad or cat it or whatever. Yup, it's awful. Can you maybe look at it in the spreadsheet? How bad are the line endings anyway? And the next step from that is trying to pull it into SQLite, because it won't fail when I start trying to cram junk into it. I am in no way claiming that I want to use SQLite as my final database.