3 ms·
This discussion reminds me of when I read in our database server's documentation something along the lines of "for very wide tables (more than 10 columns)" and
by magicalhippo 7y ago
This discussion reminds me of when I read in our database server's documentation something along the lines of "for very wide tables (more than 10 columns)" and I literally had to laugh out loud, as the main table at work is over 500 columns wide...
Gotta love organic db schemas with long history...
- hinkley 7y ago> the main table at work is over 500 columns wide... This is horrifying, but at least not as horrifying as the public sector database I once had to work with that predated proper support for foreign keys, so there was a relationship table that was about 4 columns wide and must have had more rows than the rest of the database combined. Even the database they had moved this schema to struggled with that many join operations.
- PavlovsCat 7y agoThat's like snickering when someone mentions that sugar is unhealthy in large quantities because you smoke 5 packs a day or something. That doesn't make it less valuable to those who aren't yet stuck with crap. > Gotta love organic db schemas with long history... I much more love the fact that I always have the option to start with a blank file and an empty db schema. I love the fact that decades of ignoring "social" advice about doing it this or that way because "everybody" does that, and just looking at the docs I could find/understand and making a decision, programming gets more fun and effective every year for me. I love that there is still development to be had outside of corporations and more or less unfettered by their regression. "How do I learn Javascript?" "Use a framework, they do the hard work for you. Don't learn Javascript, learn this wrapper around Javascript." "How do I learn CSS?" "Use Bootstrap or install this theme generator with a compilation pipeline. Don't learn CSS, learn this wrapper around CSS." "How do I set up a DB that doesn't suck balls?" "Use an ORM, just describe things to it, and it will do all the boring stuff for you. Don't fuzz about with a DB though, or SQL or anything, that has so many pitfalls... you might lose data or have a slow query one day, and then you obviously die."