or, why I find the Solaris manual pages amusing.
In this thread on the php internals list, Kevin is asking why the handling of whitespace in certain PDO DSNs is inconsistent. I go on to point out that the manual doesn't say anything about whitespace in DSNs, and that all the documented examples have no whitespace around the DSN parameters.
His response was:
but in this example we have a space and it works mysql: host = localhost; dbname=test
And another that I got via private email:
Thursday’s Keynote speaker at the MySQL Conference was Mark Shuttleworth talking on The Ubuntu Project: Improving Collaboration in the Free Software World.
Ubuntu from Canonical Ltd is fastly becoming one of the most popular Linux Distributions, based on Debian. Here were some notes from his presentation. Mark had some really powerful one or two line slides that typified both his presentation intention and the goal of Ubuntu.
Delivering on the Promise of Free Software
It's hard to believe that MySQL Users Conference is over. Though
each day seemed like very long, it went pretty fast.
My Applied Ruby on Rails and AJAX session was the last session at
the MySQL Users Conference and was happening at the same time as
Jim Starkey's Falcon storage engine. I was kinda worried
about the attendance at first, but when my session started, I saw
people standing in the back (full room). A lot of questions were
asked at the end. Thanks to everyone who attended.
Harrison Fisk, my session buddy, presented me with a speaker's
gift from MySQL, which was a very nice MySQL pen (Thanks).
At the end of the session I was told that there were about 114
people attending my session, roughly the same amount of folks
that attended Jim's session, Wow!.
As I was walking out of the …
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]