Today I gave compiling of the latest Query Browser a shot - the configure script initially failed by complaining about not being able to find gtkhtml-3.0. Which is correct, as SUSE 10.0 ships with verision 3.8... Adding --with-gtkhtml=libgtkhtml-3.8 to the configure options resolved that problem for me.

Source and binary RPMs for SUSE Linux 10.0 are now available from the usual place.

Oracle's latest pricing scheme is one that even Rube Goldberg couldn't have designed. Why do I always feel like major application vendors punish buyers for moving to new technologies?

I am a big believer in multi-core chips, and I appreciate that Oracle is discounting for Sun's new chips, but this doesn't make me want to move to multi-core. It appears that it would be cheaper to simply scale hardware. I guess we have to wait to see how much performance boost the multi-core gives you in relation to the cost upgrade.

While Oracle will continue to recognize each core as a separate processor, the processor definition has been amended as it relates to counting …

Back in the day, I played video games on computers and not much else. My mom had recently bought a 386 for the family. When she was at the computer store, the clerk asked her if she had any kids. When she replied that she had four boys, he gave her a free copy of ID Software's Doom:

http://web.archive.org/web/19990202175352/idsoftware.com/archives/


One of my friends told me that this "Linx" thing is really great. That it is *much more* efficient than the windows 95 thing our cousin had gotten a beta release of.

I also heard through the grapevine that Doom, the game that got me playing computer games, had been ported to this new operating system. I went to Barnes and Noble and looked through their books on "Linx" but couldn't find anything on the subject. I had done a bit of research on the …

I sometimes get asked by our customers what's a good way to find someone with skills in open source in general or MySQL in particular.  Often they're looking for a DBA or a developer to help out on a particular project.  Sometimes I get asked by our users what's a good way to get a job using MySQL.  Luckily, we have a solution for both these problems: the MySQL Job Forum.  Our forums cover a lot of technical topics, but there's also one section focused on jobs.  If you're trying to hire someone or if you're looking for a new opportunity using MySQL, this is a good place to post some information.  I've also seen a lot of postings on Craigslist, Monster and Hotjobs. 

And if you're interested in working at MySQL, we have a couple of dozen openings on our web site at …

I was getting bombarded with fake porno trackbacks, and I couldn’t find a way to get WordPress to shove them in my moderation queue, so I turned them off.

Let me know if you have any problems. I don’t know how to bulk edit existing posts to do this inside WordPress, so I fired up MySQL and manually disabled them via a SQL query. Hopefully, I didn’t break anything.

Hands up who's had an error message when they have issued an SQL statement with ; delimiter straight after they created a procedure, or had an error when they tried to create a procedure without first setting the delimiter. 1..2..3.."is that a hand or are you trying to swat a fly".. I imagine it's a fair few of you, in fact I know it's a fair few because over the past year or so it's one of the biggest things people have asked me about or have had when trying to create procedures. Not why have they made a mistake but why MySQL needs you to change the delimiter when creating stored routines (SQL/PSM).

When you think about it it's rather obvious, because lines are terminated with a semi-colon in SQL/PSM the MySQL command line client gets confused about what your trying to do. The delimiter needs to be changed so MySQL can tell the difference between straight SQL and SQL/PSM.

So what's the problem? Well there are two …

I've just come home visiting one of my Inter Access co-workers.

Barbara is a very capable Oracle Developer, Information Analyst and BI Consultant. She enjoys the craftmanship so much that she still finds time to help out friends managing their little IT solutions.

For example, one of her friends owns a sports clothing store. She built them an order entry system in that popular little Database by Microsoft known as Access.

As you might expect, the system has grown over time, and has had too little administrative attention. Now, it's about 30Mb of data. This may not seem much, until you try to run a query. Size really is a relative measure.

What's worse, the number of users has grown too. Again, it may not seem much, but five users that are …

In one of my previous blog posts I showed you the difference between the functions CURRENT_USER() and SESSION_USER() and promised to show you how to use them for auditing with triggers and what you have to watch out for when updating to MySQL 5.0.17. With this release now being just a few hours old, let's finally do that and set up a log that stores all the changes your users apply to a given table.

I'll use a pretty simple base table for the purpose of this article and will set up all the tables and triggers as user root@localhost.

CREATE TABLE t (
    t_id INT PRIMARY KEY AUTO_INCREMENT,
    v VARCHAR(32)
);

Now we need to create the table for auditing. In addition to all the columns from the base table it will usually contain additional columns for a time stamp, the operation performed on the base table …

Apart from corrupted data files and variations on that I don't remember being able to (repeatedly) having been able to crash MySQL for years. But today I could. Darn, I was looking forward to changing my production MyISAM tables using spatial keys to InnoDB. Not today I guess. :-)

update So that bug hasn't been fixed yet, but the busy bees at MySQL did fix another bug I submitted a while ago. Whee.

Comments

On a recent visit to O'Reilly I noticed a list of up coming books. There were the usual second edition of this and third edition of that, but among those was a book that looks like it will become a classic. MySQL Stored Procedure Programming is being written by Steven Feuerstein and Guy Harrison, I'll admit to not knowing much about Guy but I'm fully aware of Steven. For those that don't know Steven he's possible the worlds number one expert on Oracle's PL/SQL, having written a number of books which are seen as the standard by which we should all aim for.

I have all of Steven's Oracle books and if this MySQL book is even half as good as those it's going to be a great book. But it's not due for release until March 2006 and as we all know these things tend to have a habit of slipping a bit. But at $39.99 that at least gives us the time to save up the pocket money.