If foreign keys are a part of the database namespace, why is it that you have to ALTER TABLE to add and remove them? Why not alter the database? I suspect the issue is more in MySQL’s limitations that names of foreign keys be unique among tables in a database. . . but it does make me wonder.

If foreign keys are a part of the database namespace, why is it that you have to ALTER TABLE to add and remove them? Why not alter the database? I suspect the issue is more in MySQL’s limitations that names of foreign keys be unique among tables in a database. . . but it does make me wonder.

Joke of the day from our character sets ubergod:

10:59 < bar> mysql> set names utf8;
10:59 < bar> Query OK, 0 rows affected (0.00 sec)
10:59 < bar> mysql> create table t1 (a text,
10:59 < bar>     -> fulltext index `

So what am I up to?

I am taking a vacation.

What does that mean?

I am on a "Hacker Holiday"

In other words I am at staying at home and screwing around with some technology that I have been wanting to look at.

One of the things I am trying to do is see why my network goes down the tubes every so often (or am I supposed to now say the Tubes get full?). I use DD-WRT , http://www.dd-wrt.com/, on all of my routers. I got the brilliant idea of enabling QOS on Wednesday to see if I could get better bandwidth shaping. This pretty much broke everything... I disabled it suspecting that it was causing the router to max out its CPU only to discover that the network issues were related to the maximum number of open connections that my WRT54GL can handle. Which means that I need to find a faster box to run DD-WRT on. Problem is... I …

A week ago, I noted the following:

The MySQL 5.0.26 released 3 Oct 2006 contains an embarrassing ABI breakage. We?re fixing this bug right now, and making a new build including the first binaries which will carry the name ?MySQL Community Server? and ?MySQL Enterprise Server? (which obviously did not exist on 3 Oct 2006). We?ll notify both our community and our customers of the new builds when they?re available.

Sorry about the trouble. We?re also improving our internal QA and build processes, in order to avoid future, similar problems.

Now, we have fixed the ABI breakage and built new releases.

• MySQL Community Server 5.0.27 is built and the packages are being seeded to our mirrors. We will send a release announcement, as we’ve always done, to …

A few weeks ago, I was holding a PHP training for a customer who's using the Oracle database on a regular basis. My boss and I agreed on teaching the Oracle database connection with PDO (instead of the MySQL database connection we usually teach in trainings).

Continue reading "Oracle with PHP and PDO"

Unfakeable Linux. Red Hat responds., Red Hat (Press Release)

Oracle Joins The Free Standards Group As A Platinum Member, Oracle (Press Release)

Canonical Launches New Ubuntu Release for Desktops and Servers, Canonical (Press Release)

White-Box PC Makers Pre-Install Novell’s SUSE Linux Enterprise Desktop, Novell (Press Release)

SibylSource Offers Professional Windows-Based Open Source Desktop Suite, SibylSource (Press Release)

…

I am waiting and seeing how this new MySQL Enterprise Edition shapes up and how it affects the Community Edition, the Community, and MySQL users as a whole, but everything I have heard about it so far, from official press releases, initial public feedback, and information given to me, I am very impressed with it. This move shows every sign of being well-planned, designed to work positively for all parties concerned, from MySQL staff to paying customers to community members. What I see is added value for paying customers, better reasons for purchasing the paid edition, a focusing of MySQL's resources to better develop the product as well as to devote support to their customers, and importantly, an enabling of the community to be even greater participants than before. Some things taken for granted by some community members such as frequent binary updates may cause some disappointment, but I view this as a small price to pay, and an encouragement to …

Note: For the impatient, here's a direct link to the example that highlights itself:

http://shiflett.org/code/highlight.php

As I mentioned in the previous post, shiflett.org is being redesigned and redeveloped from the ground up. (Nope, it's not finished yet; you'll know it when you see it.) One of the things I want to improve is commenting. This blog has been getting a lot of comments, and I really appreciate that. (Thanks!) Since the topics I talk about (PHP, MySQL, etc.) are technical, I want to let you add formatted code listings to your comments.

I've been playing with this tonight. Feel free to follow along as I go. The first thing you want to do is create an ordered list from the code you want to format ($code in these …

In a dramatic twist on Oracle's news yesterday that it will be offering support for Red Hat's Enterprise Linux, word on the street is that MySQL is considering offering support for Oracle's venerable database.

The hitch, however, is pricing. Early estimates suggest that MySQL would need to charge 1000% the cost of Oracle's typical pricing to make a profit on the support, given the persistent bugginess of proprietary databases compared to MySQL.

/tongue in cheek :-)

ADVERTISEMENT
…