Databases are pure joy when they are well-structured, and nightmares when they aren't. All databases structure decays as a function of continued development over time.
Databases are their own little world, speaking their own little language, following different rules to the rest of the software world. They are hard to version control, hard to scale, and hard to live without.
Databases Management Systems
Someone else (someone smarter) did the hard work for us!
Interesting Links
- Code in database vs. code in application, a discussion on the pros and cons of having application login in triggers/stored procedures vs server code