Well, the conference is now over! I had a great time, and met a lot of awesome people. It was awesome, I truly enjoyed meeting many of you, and will definitely see you next year.
I’ve uploaded my photos and presentations for your enjoyment:
[Read more]By tim
Eric Scheide of craigslist offered me a stream of consciousness summary of the craigslist database setup. At a conference last year, Craig showed a slide (which helped inspire my postings about asymmetric competition [1, 2, 3]) that listed the number of employees at the top ten web sites. Most of them have thousands of employees. Some have tens of thousands. Craigslist, at #7 on the list, has 19.
Eric's email has that embattled "news from the front" feel that you might expect from a site handling that much traffic with only 19 employees!
First, in response to my question about the craigslist database architecture, Eric wrote: …
[Read more]I'm on the phone with a WebEx technical support person. Not sure why tech support is necessary for taking my money (I'm just trying to set up a WebEx account for Alfresco - signed up online, gave my credit card number, and have received nothing in return), but whatever.
The thing that frustrates me to no end is that I went from talking with a local, US salesperson to a remote, India-based support person who gave me infinitely less support. He didn't understand the urgency of my requirements, though he tried hard to care. I eventually hung up in desperation and called back to the US sales team, telling them they were not allowed to transfer me outside their building. Result? Successful account setup.
Which got me thinking. I'm not a big fan of outsourcing in any situation - as I feel that support and development is best done as close to the problem one is trying to solve as possible - but in the open source world it seems insane. …
[Read more]What a blast! It was great to see most of my old colleagues from MySQL when I worked there as a Professional Consultant. Lots of cool sessions and great turnout. By far, the best session was Jim Starkey's intro to Falcon. Even Heikki was there listening intently! I am looking forward to all of the great things MySQL has in store in upcoming versions.
I have mentioned a couple of times about the upcoming release of
MySQL Stored Procedure Programming by Guy Harrison and Steven
Feuerstein. It was scheduled for release in March but the release
date slipped a couple of times, I pre-ordered and the good news
is that the book arrived this morning, so it's out now (in the UK
at least).
It weighs in at 636 pages so while it's not the door stopper
that's often related to computer books there is a lot of
information in there especially given the relatively recent
addition of stored procedures to MySQL. Jay Pipes and Michael
Kruckenberg did a great job with their stored procedure chapters
in Pro MySQL but given that it wasn't an exclusive development
book it didn't go into detail about using stored procedures from
other languages, this new book goes into great detail on the
subject with dedicated chapters on using stored procedures with
PHP, Perl, Python, Java and .Net.
Having …
After a few posts on Devshed forums I decided to summarize some basic
directions about porting SQLServer triggers to MySQL.
There are some notable differencies between trigger syntax in
SQLServer and MySQL (and other databases in general).
First of all usually you reference old (preexisting) and new
(inserted or updated) column values by NEW.column_name and
OLD.column_name, but in SQLServer those values are held in two
tables named INSERTED and DELETED, on which you'll have to
perform selects.
Second relevant difference is that SQLServer doesn't have BEFORE
triggers, you'll have to use a rather convoluted syntax for
this.
Third difference is that one SQLServer trigger can fire upon
multiple actions (one single trigger for
insert/update/delete).
Fourth difference, as new/old values are held in a table there is
no FOR EACH ROW implicit loop but you'll have to …
My talk at the MySQL Users Conference went well. MySQL For Oracle Developers was part of two talks,
the second was by Mark Leith on MySQL For Oracle
DBA’s.
I had a number of positive comments from attendees, including Ken Jacobs of Oracle who also contributed some valuable information in comparision of UPDATE/DELETE ORDER BY/LIMIT statements I was unaware of.
You can download my paper here.
My slides, like many talks just scratched the surface in the alloted. I’ve been working on additional reference material, a work in progress is available at …
[Read more]All of the closing-social ice cream is gone and the conference center has quieted down to just folks putting equipment away. The "MySQL" wireless network is the last remaining indicator of the weeklong activities here in the Santa Clara Convention Center.
(Oh dear, I'm starting to sound like a reporter doing an intro to a technology segment).
It's been a jam-packed 4 days here in Santa Clara at the MySQL 2006 Users Conference. There has been so much that has happens since arriving on Sunday morning it seems more like a long, quickly moving blur.
For me this year was such a different experience from last year. The content was the same high quality as it has been in the past (this is my 3rd conference), but returning this year to familiar faces and having made connections with folks over the past year on planetmysql and other MySQL online gathering places has added a much …
[Read more]I tried to upload my slides from the conference, but run into problems with a firewall somewhere, so they've had to wait for me to return home.
So, here we are: Using MySQL with PDO (PDF).
This was my first MySQL users conference, and it seemed to go well. Truth be told, I'm not a database fanatic (which is ironic considering my involvement with PDO), so I didn't find a lot of the material to my taste. I did learn a few things from Jim Winsteads embedded mysql talk (something I bet he'll be surprised to hear :) and also Hartmut Holzgraefe's mysqli talk. I also got to chat to Monty about the issues I mentioned and meet some new faces, including my Evil sysadmin, some old and some older faces (Hi …
[Read more]In this article I’ll show you how to find the “next” and “previous” records (define these terms any way you like) in a set of records. My solution uses no subqueries or unions, so it works on old versions of MySQL, and returns both the next and the previous records in a single efficient query. Motivation I’m working on a project right now that requires me to use MySQL 3.