http://www.robertswarthout.com Things that I run across that might be useful to others... Wed, 20 Aug 2008 19:06:31 +0000 http://backend.userland.com/rss092 en This post will be about the what always seems to be a hot topic among PHPers about what connection type to use when connection to a MySQL database. I used MySQL 5.0.45, PHP 5.2.4 for this benchmarking. You can download the same sample MySQL database that is used for this set ... http://www.robertswarthout.com/2008/08/benchmarking-of-mysql-persistent-connections-vs-non-persistent-connections/ So I have submitted my first conference talk proposal. PHP|works 2008 is going to be held in Atlanta here again this year. My proposed talk is about implementing the open source fulltext search engine Sphinx in a website. Let's hope that it gets accepted! :-D http://www.robertswarthout.com/2008/06/submitted-a-talk-proposal-to-phpworks-2008-today/ I am going to begin the process of explaining how to setup a PHP frontend to a remote subversion (SVN) working copy. The post today will talk about how to correctly setup apache to work in a multi-user setup. One of the the nice things about SVN is that it keeps ... http://www.robertswarthout.com/2008/05/php-subversion-frontend-part-1/ So it has been 1 year to the day since my last post, too long! A lot has happened in the last year, I will spare you most of the details. Recently I have started working for Schematic in Atlanta and started a used auto sales site, EasyAutoSales.com with some ... http://www.robertswarthout.com/2008/05/31556926-second-hiatus/ I just ran across an interesting bug in IE 6 when a page is loading an external javascript file. If Apache is outputting the external javascript compressed (gzip) IE will do one of the following things: Return a blank page Try loading the page forever Prior to finding this bug, our apache settings ... http://www.robertswarthout.com/2007/05/ie-6-apache-mod_deflate-blank-pages/ On PaperBackSwap and SwapaCD we have some tool-tip rollovers that display a definition of what we define as keywords. (This can be seen in action on http://www.paperbackswap.com/help/hdtw.php. The word "credit" has been highlighted.) It came to our attention the other day that Safari was display anything replaced by JavaScript as ... http://www.robertswarthout.com/2007/02/javascript-safari-bug/ So over the last week I have been working on and off with a PHP frontend to SVN. The frontend needed to be designed in such a way that each developer could access their working copies and make the full range of actions against them. I decided to also use ... http://www.robertswarthout.com/2007/01/php-frontend-to-subversion-svn/ After our latest purchase with Dell, all I can say is that Micheal Dell will be able to buy a nice new watch. Currently in the office we have a stack of new machines that are getting close to being fully configured ready for the move to the data center. ... http://www.robertswarthout.com/2007/01/our-new-hardware-setup/ After getting our new servers delivered I came to the conclusion very quickly that I would like a way to easily get the same configurations on every box without having to spend the rest of my life doing so. Each box needed to have Apache, MySQL and PHP installed and ... http://www.robertswarthout.com/2007/01/install-of-apache-223-mysql-5018-and-php-520/ After searching online for a hour or so I was able to get iptables setup correctly to use a Fedora Core 5 server as a router for an internal network. The following iptable rules is all I needed. I ended making a file and putting these 4 lines into it, ... http://www.robertswarthout.com/2007/01/fedora-core-5-nat-routing/