4 ms·
I am really surprised at the number of developers who have seemingly no knowledge of Sql. I've seen very large data-models without any useful indicies and deve
by ericHosick 15y ago
I am really surprised at the number of developers who have seemingly no knowledge of Sql.
I've seen very large data-models without any useful indicies and developers attempting to optimize these systems through manual caching (similar to indexed views in something like Sql Server).
The trend seems to be worsening and is disconcerting.
Key/value stores are the trend but Sql is still very prevalent and should be as well understood as something like regular expressions.
- mzarate06 15y agoAgreed; the same can be said for other fundamentals such as foreign key constraints. I still see modern day apps being developed where foreign keys, and uniqueness, are only implemented in the application. I understand some protection should be added in the app to prevent errors, but to avoid implementing these constraints in the database itself still leaves the door open for problems to occur.
- lwcd 15y agoWorsening indeed, both with depth of understanding of schema definition and of query mechanics - very often I see developers run with the first query returns their desired results, with little regard for performance or understanding how the results are actually being generated.