Index

• Title page
• Introduction
• History and philosophy
• Competing interests
• Open source
• The unappreciated RDBMS
• Who does the work? Application vs. the database
• Grabbing a userid: shifting the work
• Views - the key to happiness
• Views, why we love them
• Views: so they're not quite perfect
• Business logic
• Languages: the good, the bad, and the ugly
• Some are more equal than others
• Overview of the process
• Credit cards
• Credit cards: rolling our own data type
• Credit cards: more business logic
• Credit cards: more checks
• Credit cards: the plot thickens
• Credit cards: updating
• Why should the DBA have to do all this?
• Why should the developer have to do all this?
• Things the DBA may need to know
• Things the developer may need to know
• Documentation, APIs, and mutual distrust
• Revision control
• Documentation: keep it close, keep it current
• DNA: Nature's database
• DNA meets RNA
• DNA: Compacting
• Schemas and the power of plain text
• Overview of DBA tools
• Auditing
• Configuration changes
• Naming considerations
• Physical considerations
• Moving forward
• Advanced topics