3 ms·
> I'm reliably informed that there's no way to cook squirrels so they are appetizing to anyone who isn't desperate Misinformed. Squirrels are pretty tasty. Nee
by eropple 10y ago
> I'm reliably informed that there's no way to cook squirrels so they are appetizing to anyone who isn't desperate
Misinformed. Squirrels are pretty tasty. Need a few, though.
More to the point of the article, I appreciate that Fowler calls out stored procedures as something often misused but secretly pretty awesome. If you are working in an environment where you can handle a SQL database as a canonical datastore--and of course there are literally kajillions of opportunities for that--then sprocs can do a lot to isolate business logic at a level lower than the application. I wouldn't use them in every case, but I've had good success using them in many cases.
- deleted 10y ago[deleted]
- KingMob 10y agoUnfortunately, most database abstraction libraries and ORMs have the effect of reducing available database capabilities to the lowest-common denominator. For example, look at how many ORMs have facilities to add commonly-required conditions to every query (e.g., "is_active = true"), but lack the ability to use views.
- eropple 10y agoUse better ones. =) I'm a big fan of Sequel, for when I'm in an environment where I can deal with having models schema expressed via introspection of the database itself.