Mistakes: Importing Data with MySQL
I spent the better part of today trying to import—in various attempts—between 800 MB and 3.1 GB of data into a local MySQL »
Responsible SQL: How to Authenticate Users
Most SQL-injection articles set a horrible example for young programmers. Here is a very typical “bad example” of why you need to escape user data before »
Help Me Scale
I’ve been reading Eran Hammer-Lahav’s intelligent posts on microblog scalability, and now I’m concerned about my own “microblog” site, Picofiction. Similar to social »
MySQL Subqueries
I often find it difficult to find tips and advice for doing relatively simple things in things like MySQL, Ruby, Python, etc. So, starting with this »