http://www.nodroidsallowed.com Practical techniques for raising a well-adjusted database Fri, 19 Dec 2008 20:58:30 +0000 http://backend.userland.com/rss092 en This article covering a talk by Rasmus Lerdorf on the issue of scaling PHP and PHP Frameworks is a couple of months old but keeps popping up on Delicious. There's a lot to disagree with there, especially if you read through the comments by other people who were in ... http://www.nodroidsallowed.com/2008/12/19/php-frameworks-and-scaling/ As a followup to one of my previous posts I wanted to go through how I managed to get CodeIgniter and Minify to play nice with each other. Hopefully this will make someone else's life easier. For those not using CodeIgniter this post might be either confusing or ... http://www.nodroidsallowed.com/2008/09/22/codeignitermeet-minify/ So right now I'm looking at a table that has at least 3 different columns that control whether the particular row is displayed on the front end. In some cases that's unavoidable, but it has to be kept in check. Maybe you can tell me what the difference is between ... http://www.nodroidsallowed.com/2008/09/19/one-flag-to-rule-them-all/ Having read High Performance Web Sites, I figured I'd take a little time out of the development of new features on my side project to look at some basic performance issues. The first stop was YSlow, the Firefox plugin that works with Firebug to give you a simple report ... http://www.nodroidsallowed.com/2008/07/29/in-praise-of-minify/ If there's one concept I've fought my entire career it's that there can be, or even should be, a way to make everything work "automagically", a term the afflicted developers use lovingly. I recently christened this the "Magic Button Syndrome". Usually a bunch of fairly smart developers sit ... http://www.nodroidsallowed.com/2008/05/05/magic-button-syndrome/ I decided to use CodeIgniter for a PHP project that I'm working on. CodeIgniter is an MVC framework, not too unlike CakePHP. At least I imagine they're very similar, but I can't say for sure as the reason I chose CodeIgniter over CakePHP was that the CakePHP documentation ... http://www.nodroidsallowed.com/2008/04/24/wherein-i-question-the-usefulness-of-mvc/ It seems like a long since I was the youngest guy in the office. Those days were pretty golden. The young turk is the one that everyone lives vicariously through. I remember recounting stupid drinking stories to a cube-full of older developers eager to relive their own ... http://www.nodroidsallowed.com/2008/04/11/where-go-older-developers/ The idea behind the request token is another one of those simple-but-powerful patterns that I've come to rely on in various systems. I'll jump right into an example of a case where I wanted to use it but alas I didn't get to make the change before I left ... http://www.nodroidsallowed.com/2008/03/28/the-request_token-pattern/ Funny thing happens when you start to put data into a database. It becomes important. At one point it might have seemed like a nice idea to save the visitor's IP address. Slowly, as the system evolves, little branches of code pop up around the fact that ... http://www.nodroidsallowed.com/2008/03/14/be-a-data-integrity-watchdog/ I thought I'd start a loose series on PL/SQL for server-side developers. As a developer who has had to defend my use of PL/SQL in various systems over the years, I have some pretty strong feelings about what it brings to the table. I think of PL/SQL as ... http://www.nodroidsallowed.com/2008/03/03/whats-so-great-about-plsql/