This includes the end of support for all things PHP 4 as noted by seemingly everybody on php planet. But I also wanted to reminds people that the same is more or less happening in the MySQL world too. Did you know that active support for MySQL 4.x ended along with the year 2006? Did you even know that MySQL 5.0 active support is ending this year!?! Given MySQL 5.1 no show mentality, they might have to review this. Well there is of course extended support that extends MySQL 4.0 support until this year, MySQL 4.1 until the end of next year and MySQl 5.0 until the end of 2011.

This includes the end of support for all things PHP 4 as noted by seemingly everybody on php planet. But I also wanted to reminds people that the same is more or less happening in the MySQL world too. Did you know that active support for MySQL 4.x ended along with the year 2006? Did you even know that MySQL 5.0 active support is ending this year!?! Given MySQL 5.1 no show mentality, they might have to review this. Well there is of course extended support that extends MySQL 4.0 support until this year, MySQL 4.1 until the end of next year and MySQl 5.0 until the end of 2011.

It’s time again for another edition of the weekly review of database blogs, Log Buffer. Since it was a big week for SQL Server, let’s start there, shall we?

The big news — SQL Server 2008 is released, as reported by SqlServer-qa.net, in seven different versions. Aaron Bertrand introduces a new kid on the block: SQL Server 2008 Web Edition — “. . . designed for highly available Internet …

I'm off in few hours to attend DebConf 8 in lovely Mar del Plata, Argentina.  The only bummer is that its winter down there so this seaside resort is going to be a bit chlly and as a result Im not able to pack as light as I usually do.  That being said, getting away from the string of 100 degree days that we've been having here in Austin isn't such a bad thing.

I had a great time at DebConf 7 in Edinburgh, particularly since it was a homecoming of sorts for me.  This time its exciting since I've never been to Argentina before and have heard great things. Like last year, Sun is a Silver Sponsor of the event.

On the …

This is a continuation of my articles on how to select the desired rows from ranked data. A user recently posed a question in the comments that I thought was particularly intriguing:

What is the best way to query 1) Sum of min price of all types? 2) Sum of 2nd highest price of all types?

Sounds like fun! Let me start by saying the sum is the easy part. You can always do that like so:

select sum(price) from (
   -- find desired rows here
) as x;

Finding the desired rows is the hard part. In my previous articles I focused on extrema:

• The single biggest/smallest/extremest row in each group. (Pretty easy.)
• The N most extreme rows in each group. (Doable, but harder.)

In this article, we’re going to see how to get not the most extreme row, not the N most …

Me, Larry Augustin and a penguin. Film at 11:00. READ MORE

On Wednesday, September 17 there will be a web based seminar on MySQL 5.1. 

Seminar will be in Italian and anyone who is interested is invited to join us!

You can find details here.

If you are a database administrator or a developer and you are courious about new features coming with MySQL 5.1 then this is the right webinar to attend. In the meantime, to better understand MySQL 5.1, take have a look at "Inside MySQL 5.1" white paper.

See you soon! 

Finally the on-demand version of the web based seminar is online. You can find recording here and you can also download presentation slides.

Please note that due to a technical problem in the time span  11:10 - 13:20 slides are not visible, but audio is good. Sorry for the inconvenience and thanks to everyone who attended!

I follow only a few comics in my feed reader: Get Fuzzy, Dilbert, XKCD, and now The Adventures of Ace, DBA. It’s kind of XKCD-ish, only it’s about Oracle and it doesn’t have the extra punch line when you hover your mouse over the picture. And it’s proof that a DBMS (even one I don’t use) can be pretty damn funny.

comics, humor, Oracle

I'm off in few hours to attend DebConf 8 in lovely Mar del Plata, Argentina.  The only bummer is that its winter down there so this seaside resort is going to be a bit chlly and as a result Im not able to pack as light as I usually do.  That being said, getting away from the string of 100 degree days that we've been having here in Austin isn't such a bad thing.

I had a great time at DebConf 7 in Edinburgh, particularly since it was a homecoming of sorts for me.  This time its exciting since I've never been to Argentina before and have heard great things. Like last year, Sun is a Silver Sponsor of the event.

On …