Posts

Showing posts from November, 2024

Non-fiction Book Recommendations

Life Bumpers, by Nic Peterson As a Man Thinketh, by James Allen The Daily Stoic, by Ryan Holiday Untangled: Guiding Teenage Girls into Adulthood, by Lisa Damour The Fine Art of Small Talk, by Debra Fine Personal Kanban, by Jim Benson and Tonianne DeMaria Why We Buy, by Paco Underhill The Life Changing Magic of Tidying Up, by Marie Kondo The Reason I Jump, by Naoki Higashida The Power of Habit, by Charles Duhigg Zen and the Art of Motorcycle Maintenance, by Robert Pirsig Tuesdays with Morrie, by Mitch Albom Work The Checklist Manifesto, by Atul Gawande Meetings Suck, by Cameron Herold The Five Dysfunctions of a Team, by Patrick Lencioni The Phoenix Project, by Kim, Behr, and Spafford Technical Old Coder Guy, by Eric Whitney Pragmatic Programmer, by David Thomas and Andrew Hunt NoSQL for Mere Mortals, by Dan Sullivan Pro SQL Server Database Design and Implementation, by Louis Davidson and Jessica Moss The Kimball Group Reader (data warehousing), by Ralph Kimball and others Design Pattern...

Don't Do This With Your Database ER Diagram

Image
 This: It's easy to understand why anyone would want to diagram the entire database so that developers and admins can see everything in one visual map. That works well for databases with a small number of tables, but as the tables increase the visual clarity quickly falls off, unless you make a giant diagram that requires zooming in and out to see any useful details. There's a famous parable about the blind men and an elephant.  A group of blind men heard that a strange animal, called an elephant, had been brought to the town, but none of them were aware of its shape and form. Out of curiosity, they said: "We must inspect and know it by touch, of which we are capable". So, they sought it out, and when they found it they groped about it. The first person, whose hand landed on the trunk, said, "This being is like a thick snake". For another one whose hand reached its ear, it seemed like a kind of fan. As for another person, whose hand was upon its leg, said, ...