Posts Tagged ‘mysql
PHP development on Mac – my experience
A while ago I saw a lot of people writing about their PHP development environment and tools. I didn’t get around to it at the time but yesterday I found me some time to write down my experiences of moving from Linux to MacOS X as primary OS for PHP and web development
Me and my [...]
The MongoDB vs MySQL debate…
Same stupid debate as so often before. Just the topics are different from time to time. Found via the Swedish Utvbloggen, RWW, highscalability och myNoSQL.
Reordering nested sets using PHP and Javascript
The adjancency method
Representing a tree of nodes, for example product categories, in a relational database is not hard. The most common way of doing it is to store a parentid with each node. This is also known as the adjacency list model. It is sometimes also referred to as the recursive model. Whatever the name [...]
The nested set model – hierarchical data in MySQL
I’m working on a small PHP project handling data which is organized in a hierarchical fashion. This is a common task and I have done it before creating forums and the like. This time no different than any other I was swearing over the rather ugly and most of all inefficient code needed for fetching [...]
MySQL 4, Apache 1.3 and PHP 4.3 on Solaris x86
Yesterday I decided it was time to get a proper PHP 4 environment configured on my new machine running the x86 version of Solaris 9. I know going outside Windows or Linux with PHP sometimes can be tricky. I haven’t used PHP on Solaris since my time at AOL in Dublin three years ago, so I decided to write down exactly [...]
PHP5 Overview
PHP5 is still far from being finished even though you can already download a beta version. The performance improvements, the better object orientation and XML support, the new PDO extension and many other small and large changes make many of us wish it was already here. After attending the PHP Conference 2003 in Frankfurt I [...]
