Thanks a ton to Xarb who reminded me of pipes in his blog post about filtering out fluffy planet mysql authors.
I should remember Pipes, since I work at Yahoo and I was called in to help out with their DB that first full day they were launched and couldn't handle the traffic, but hey, sometimes things just don't come to mind.

read more

Good news fellow DBAs; adding to the already packed list of RSS/Atom aggregation sites out there on the internet, there is a new site catering to DBAs called Relationalnews. Feel free to add your feed(s) for aggregation, because what else do bloggers want but more visibility to search engines, right? This was basically a coding project to get familiar with CodeIgnitor as well as RSS and Atom xml feed processing in PHP. Pretty simple looking back on it, and it was generally a fun project.I’ll probably add more features to the site at a later time, with free time being what it is…So read the news! http://relationalnews.com 

Because of some weird bug my RSS feeds were broken ever since I’ve upgraded to WP 2.5. Today they were fixed and I hope they’ll have some new posts there soon Stay tuned.

I’ve been coding a couple of scripts that run on 5 minute intervals to grab RSS/Atom feed data from http://mysql-dba.com and import that into a MySQL database. It idea is to create a search function for the site that will look at all past data from the aggregated feeds. Since there are multiple pollers running at different intervals I decided to use Innodb for the read/write nature of the poller/processing scripts.

This is very simple so far - and as such I felt it should be documented from the start unlike many of my other projects. Here’s the feed table that is storing the information from the RSS feeds.


mysql> show create table feed_items\G
*************************** 1. row ***************************
Table: feed_items
Create Table: CREATE TABLE `feed_items` (
`id` bigint(20) NOT NULL






The following is what i wrote on “43people.com” about the boss. I thought it was worth keeping in my own archives, since it’s actually a story about my life as it pertains to Mr. Bezos.

Anyway, the prof didn’t require that we buy any books, but he made some suggestions. And he also suggested that we buy them on this new fangled “Internet” thing through a few of his friends down south in Seattle at this
  [Read more...]

I am happy to announce the latest creation from foundeo: fusionKit.

fusionKit is a CD full of some handy ColdFusion components and UDF's. It is a similar concept to the DRK's that Macromedia used to sell, but is it's 100% ColdFusion.

My favorite component in the kit is the Bayesian CFC. You may recall that spam filters tend to use bayesian analysis to determine if a message is spam or ham. This CFC allows you to perform the same kind of analysis on any block of text. I am using this CFC in one of my client's blogs, and it has blocked over 4,000 spam comments in one week!

There is also the tagging CFC, which