I was asked in comments "nice, but its only read only right?".

Not true at all!

For example, lets create this table:


mysql> CREATE TABLE `website` (
-> `filename` varchar(125) NOT NULL DEFAULT '',
-> `contents` text,
-> PRIMARY KEY (`filename`)
-> ) ENGINE=HTTP DEFAULT CHARSET=latin1 CONNECTION="http://localhost/"
-> ;
Query OK, 0 rows affected (0.00 sec)


Now, lets insert a page:


mysql> insert into website VALUES ("index.txt", "This is a document on a website");
Query OK, 1 row affected (30.01 sec)


Read the page from curl:

[brian@zim ~]$ curl http://127.0.0.1/index.txt
This is a document on a website



…

From IM:
"So can anything be done with XML?"

Create a table:

CREATE TABLE `krow` (
`a` varchar(125) NOT NULL DEFAULT '',
`b` text,
PRIMARY KEY (`a`)
) ENGINE=HTTP DEFAULT CHARSET=latin1 CONNECTION='http://krow.livejournal.com/data/'

Now... can I extract anything?

mysql> select EXTRACTVALUE(b, '/rss/channel/title') from krow WHERE a="rss";
+--------------------------------------------------+
| EXTRACTVALUE(b, '/rss/channel/title') |
+--------------------------------------------------+
| Brian "Krow" Aker's Idle Thoughts |
+--------------------------------------------------+
1 row in set (1.29 sec)

Basically I use the new XML methods in 5.1 to extract out realtime data from 5.1.

I publicly committed mod_methods:
…

Tim O'Reilly, ever a few steps ahead of the rest of us, has some thoughtful musings on what's behind Google's new 411 service. Tim doesn't cast this as an open source move, but rather a Web 2.0 move designed to build up a treasure trove of data against which to build better speech recognition:

But it also seems to me that there's a hidden story here about the speech recognition itself. I was talking recently to Eckart Walther of Yahoo!, who used to be at Tellme, and he pointed out that speech recognition took a huge leap in capability when automated speech recognition started being used for directory assistance. All of a sudden, there were millions of voices, millions of accents to train speech recognition systems on, and much less need for the individual user to train the system.

This is reminiscent of a comment that Peter Norvig, Director …

I'm finishing up my presentation for the upcoming COSS.fi event next week (4/19/07), and was exploring an idea - how do you compete when the code is open? - when two things happened in quick succession.

One, I was reading the Bible and came across this interesting verse from Genesis:

...Cursed is the ground for thy sake; in sorrow shalt thou eat of it all the days of thy life;

Thorns also and thistles shall it bring forth to thee; and thou shalt eat the herb of the field;

In the sweat of thy face shalt thou eat bread, till thou return unto the ground.... [Genesis 3:17-19]

In other words, it's good to have to wade through difficulty. That's where growth comes from. There are no magic shortcuts to prosperity.

Second, I read Mike Olson's response to some criticism that I and Stephen O'Grady had heaped upon his …

In the spirit of humor, here are 2 ways I know I am a MySQL geek. These are actually things I do….

You Know You’re a MySQL Geek When….
1. You cannot type the word “myself” without typing “mysql” first, deleting 2 characters and finishing out the word.
2. You type “show processlist” at the commandline when you really mean “ps -ef”

Anyone have anything they can add to the list?

I'm proud to welcome Luke Welling to OmniTI. Luke is a prominent member of the open source community, probably best known as the co-author (along with Laura) of one of the best selling open source books of all time, PHP and MySQL Web Development. Those who know him are more familiar with his keen sense of humor and undying urge to bait people for his own amusement.

He is working with me as part of our growing web application security practice, focusing on three key areas:

Security Training Program

Help clients avoid security problems. (Teach …

Welcome to the 40th edition of Log Buffer, the weekly review of database blogs. In celebration of this special number, LB has gone out and bought itself a sexy new sports car in which it plans to ride around with a younger, blonde blog. The MySQL User Conference & Expo is very close, so it’s [...]

I wrote a few days ago about the keynote I'm hoping will lead to some wonderful on-stage fireworks — the Clash of the Database Egos. The keynote has had a late addition: the creator of InnoDB, Heikki Tuuri. I'm certain a number of you out there had wondered how we could have a clas of the database egos without Heikki participating. I assure you, there wasn't any ill intent for not having Heikki originally listed on the clash speaker list. More of a time pressure thing from my end, nothing more.

Our most excellent facilitator, …

At the MySQL Conference & Expo April 23-26 in Santa Clara, we'll be introducing for the first time the idea of a "Guru Bar."  Taking a tip from Apple's highly successful in-store "genius bar" (which I've found to deliver excellent service" we decided to up the ante at our conference.  Our Guru Bar will be staffed by top notch MySQL gurus including our System Engineers, Developers, Consultants, Training and Support Engineers.  You can come by, bring your technical challenges or problems and we'll help you resolve them. Heck, bring your toughest problem, your laptops and your teams and we'll work together with you to solve them right there at the conference.  …

Lenz made a good summary of the DotOrg Pavilion exhibitors at the Expo part of the MySQL Conference & Expo ten days from now. To recap, the DotOrg Pavilion is a part of the exhibition area reserved for Open Source projects. Our attempt has been to collect the DotOrg pavilion to be a mecca for OSS enthusiasts, writers, speakers, and advocates. We are fortunate to have attracted some of the world’s most recognised free software organisations, and new up and coming projects.

A related type of reason to register for the conference are the …