Mysql

My Reign as the King of Pings

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 ... (read more)

2005/10/12

The Joy of MySQL

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)

2005/09/30

Changing Weblog Software is Drudge Work

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 ... (read more)

2005/05/25

Let's Put Everything on the Table

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 ... (read more)

2005/05/19

Weblog Comments Near and Far Out

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 ... (read more)

2005/05/12

Server Attacked at Random

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 ... (read more)

2005/04/06

Closing Movable Type Comments

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 ... (read more)

2004/11/30

Turning Off the Radio

Because I wrote the book on Radio UserLand, my decision to stop using the software on Workbench has raised a few eyebrows.By tradition, the first thing a weblogger must do with new software is publish a vicious excoriation of the old software, warning others to keep away, like a courageous relief worker marking a land mine.Textbook example: When Mark Pilgrim concluded that a Movable Type licensing change would have cost him $535, he declared the software a dead end, switched to WordPress, and ... (read more)

2004/10/07

The Bench is Back

This entry represents the culmonation of several weeks of work moving Workbench from Radio UserLand to software that I am writing for myself on a LAMP platform (Linux, Apache, MySQL, and PHP).This has been an eventful month. I was the first person to evacuate Florida for Hurricane Frances, taking my family all the way to Northern Virginia almost two full days before it made landfall. My excessive caution was rewarded by a drive home through South Carolina as the storm hit that state, spawning ... (read more)

2004/09/30