Month: November 2018

User Authentication with MySQL Stored Routines

User Authentication with MySQL Stored Routines

Making MySQL Do More The standard approach to authentication systems in web development is simple: store your confidential data in a database, pull the needed data from said database and let your chosen language/framework (PHP, Ruby, Python, etc.) do the work. What many programmers don’t realize is that MySQL is capable of so much more than …

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 to any specific relational database management system (RDBMS); though, it must be an RDBMS- NoSQL solutions …

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 closes or the machine shuts down) and reliability (you will be able to retrieve as needed …