Relational Database Design for Developers (Database Normalization)

Database Normalization

Good Form, Peter Pan! Corny title of this section aside, database design is often a subject that developers gloss over. And because developers really cannot get by without utilizing databases, I’m writing this guide for them. It’s not even exclusive Continue reading Relational Database Design for Developers (Database Normalization)

A Beginner’s Introduction to SQL & MySQL

Introduction to SQL and MySQL

Your Data Lives Somewhere Databases, and the very definition of one come in all shapes and sizes. But ultimately every definition has the same roots: a system with which data can be stored persistently and reliably. Persistence (it’s not lost when the application Continue reading A Beginner’s Introduction to SQL & MySQL

Stored Routines: Word Filtering Inside the Database

MySQL Stored Routines

Please note: This article was written in late 2010.  Before MariaDB.  Before MySQL 5.5 even released.  What you read below may no longer work, or require modifications to make work. MySQL Stored Routines: Another Useful Scenario In a past guide I Continue reading Stored Routines: Word Filtering Inside the Database