3 ms·
Like all things, it depends. Certain features/abstractions have more value at different stages of an application. I LOVE using views early on in a new applicat
by tomnipotent 8y ago
Like all things, it depends. Certain features/abstractions have more value at different stages of an application.
I LOVE using views early on in a new application's schema as it allows me to evolve the logical model separately from the physical model, and once I've coalesced on something I like it's easy enough to swap the view with a real table and my application code higher in the stack is none the wiser.
Even Facebook at one point relied on MySQL triggers to keep its memcache fleet synced.
- scarface74 8y agoViews aren’t quite as bad as stored procedures. I could see doing a view being decently easy to manage - you can always add s column without breaking backwards compatibility. But you can’t imaging the number of times I’ve seen things like... SaveCustomer_1 SaveCustomer_2 SaveCustomer_3 And you never know whose using what.