Posts filed under “Development”
Hierarchical Data With PHP and MySQL
I recently had fun with an all-to-common issue with SQL driven websites: hierarchical data. For those who don’t like big words, think trees. Other people have already discussed storage methods, and I would actually highly suggest you read the writeup if you haven’t already. While it is fairly straightforward to deal with, in our case [...]
*AMP and Runaway Scripts
Peter Zaitsev posted a very interesting test on how PHP and Apache handle runaway PHP scripts. I’m sure all of us have had a long executing SQL script or at least a runaway script, and he points out even with ignore_user_abort set to FALSE and max execution times set both in PHP and Apache, a [...]
Automating the Development Workflow
I just rolled out some new automation tools for a few projects here at work and so far I’ve been extremely happy. Much to my embarrassment, development has previously been outside of source control due to the fact that we develop sites, we don’t deploy packaged applications, and we don’t have a cohesive IT setup [...]
Partial Classes in PHP
One of my favorite features of C# is Partial Classes. For the uninitiated, it is a way of defining a class in two separate locations. Very useful when you have code generation utilities such as LINQ. Unfortunately, PHP has no such feature (though if anyone’s listening it would be a great feature to add to [...]
Database Normalization and Design: Part II
(This is the sequal to my previous post, Database Normalization And Design: A Primer)
Database Normalization And Design: A Primer
I am by no means a database expert, such titles are best left to people like Peter Zaitsev and Vadim Tkachenko, however one of my co workers has been asking me for some help on how I come about my database designs, particularly issues concerning normal form. Whlie I could spend several posts going over [...]
Microsoft Access and PHP
Microsoft products can really be a big wrench in the finely oiled machine that is your development environment. While Microsoft does offer some excellent products and development tools, when you work from an open source context, these great tools become great hazards and headaches. Case in point, access databases. Take as a recent example, a [...]
OO Design and PHP
I was helping a coworker the other day with some object oriented design issues in PHP and thought it would be great to share with the general PHP community as the general PHP community seems to lack in good OOP skills. The task, which will be detailed later when we release it, boiled down to [...]
PHP Feeds, or, Get Your Read On!
I’ve started to amass a large amount of feeds in my reader and I thought I’d share a few with you: PHPDeveloper.org (feed) Great aggregation of blog posts and updates in the PHP world. Zend Developer Zone (feed) Zend’s place for all things PHP related SitePoint.com (blogs) (articles) The infamous SitePoint. Not entirely PHP, but [...]
MySQL Workbench 5 Beta (Or: WTF?)
So I’m setting up my windows PC at home (hooray compsci classes being an all Microsoft setup, requiring Visual Studio 2005), downloading the MySQL GUI tools, launching them to test when I notice that MySQL Workbench went through a HUGE overhaul. When I say huge I mean “It Actually Works Now And Looks Completely Different” [...]