I've been running Weblogs.Com since June for Dave Winer, who wanted to see if service performance could be improved as he began to receive seven-digit inquiries about selling it. Weblogs.Com ran on Frontier for six years from its founding in 1999, handling the load reasonably well until the number of pings topped one million per day within the last year. In a frenzied weekend, I recoded the site as an Apache/MySQL/PHP web application running on a Linux server, writing all of the code from scratch except for ... read more

While deleting some comment spam in the Drudge Retort database, I just had to use the following MySQL query: delete from feedback where author like '%sperm%'; ... read more

I just finished moving the Drudge Retort from Movable Type to Wordzilla, my PHP/MySQL software that runs Workbench, giving all 14,400 weblog entries and 233,000 user comments a new home. The project took 10 days, around eight more than I expected. The Retort is emulating Daily Kos by giving site visitors the tools to create their own blogs. I'm going to choose interesting user blog entries for the main page and home page to run alongside my own blog entries -- I've always wanted to give the kids a chance to drive ... read more

Of all the insults I received for popesquatting, the ones that stung the most were about my web skills, such as this comment on MetaFilter: Eh, his website needs work. The text overflows the white box and he must've used the nowrap attribute as there is a hideous amount of rightwards scrolling. pls fix ur website b4 u sho it to teh whirled, pls ok tks. Ouch. F U 2. I like three-column designs, so I lay out my sites with HTML tables, often putting ads in the rightmost column. This lends itself to a creative trick ... read more

I'm coding this weblog myself in PHP and MySQL, writing software that I will eventually release under the name Wordzilla. A new recent comments sidebar on Workbench makes it easier to follow active discussions on old weblog entries. Running a weblog with open comments attracts some unusual discussions when people using a search engine find familiar names in an old entry. For two years, Workbench has hosted an ongoing soap opera between the current and former spouses of Atlanta Journal-Constitution reporter Ron ... read more

My server has been under attack for three days by a user in Colorado who requested the same URL 8.3 million times (and counting). The user, making simultaneous connections from eight IP addresses in a block controlled by Time Warner Telecom, requested a URL on URouLette that redirects to a random web site -- as many as 30 requests a second to a PHP script that made a MySQL database connection. I'm guessing the motive was to acquire web addresses for e-mail harvesting or some other form of net abuse. By yesterday ... read more

I'm winning the war on comment spam on Wordzilla, my homebrew weblog software, thanks to PHP code that rejects link-heavy comments and submissions from banned IP addresses. I'm losing on Movable Type and Manila. Both programs are being flooded with spam that has to be hand-deleted, a chore that's miserably time consuming in each. Six Apart enhanced Movable Type's comment-management features in version 3.1, but it can take up to five minutes to delete a group of spam comments on the Drudge Retort, which has 107,000 ... read more