Creating an App from Scratch: Part 9
Part 9 of the Creating an App from Scratch series, in which Chris Coyier and Jason Lengstorf go over bug fixes, security concerns, and other feature tweaks that occurred after the application went live.
Tag: MySQL
Creating an App from Scratch: Part 7
Part 7 of the Creating an App from Scratch series, in which Chris Coyier and Jason Lengstorf explain the PHP and jQuery that make the application’s list handling functions work.
Creating an App from Scratch: Part 5
Part 5 of the Creating an App from Scratch series, in which Chris Coyier and Jason Lengstorf go over the PHP and MySQL that handles the creation and updating of user accounts.
Creating an App from Scratch: Part 3
Part 3 of the Creating an App from Scratch series, in which Chris Coyier and Jason Lengstorf cover the workflow and design of the application.
Creating an App from Scratch: Part 2
Part 2 of the Creating an App from Scratch series, in which Chris Coyier and Jason Lengstorf cover, in great detail, the planning, design, building, and testing of an AJAX-powered web application based on PHP/MySQL.
How to Implement Natural Sorting in MySQL
A quick tip that allows strings to be sorted in numerical order, avoiding the test1, test10, test2, etc. issue.
Optimizing MySQL Queries with JOINs
This week, I wanted to share some of my recent experiments with MySQL queries in regard to lowering the number of requests sent to the database server and, hopefully, avoiding the bottleneck that can form on sites that rely heavily on database interaction.