In going to grab MySQL 5.0.17 today I noticed that the MySQL folks are now providing the Solaris binaries in Solaris packaging (pkgadd) format. That is so cool, now I don't have to go to the trouble of packaging it myself. I was planning to get started on a plan to move our dev environment up to 5.0 next week. Now rather than spending the day getting the build script up to speed I can do something else. I used to compile MySQL myself, but I just can't see the justification anymore, especially now that the pkgadd packages are available.

It hasn't been that long since I last came and grabbed MySQL, although that was for OS X so I might have missed the availability of Solaris packages.

Now, what will I do with my day?

It gives us great pride to announce the release of MyComponents V4.3 native Delphi/Kylix VCL suite. This update includes mainly fixes to issues as it has been reported to Support and on this forum, as well as Delphi 2006 certification.

What's new?

TMySQLDataset:
New: doSingleSQL option which allows an SQL script to be executed as a single SQL statement, thereby enabling you to use the SQL property to define functions and procedures in MySQL.
Fix: Various issues as has been reported to SciBit Support

This update is free of charge for all customers whom own a 2005.4.x MyComponents serial. Everyone still using a pre-2005.4 MyComponents may upgrade to the newest version by logging into their Secure accounts: simply click the Secure link at the top of this …

I've just started reading Pro MySQL by Jay Pipes and Michael Kruckenberg, Apress were kind enough to send me a free copy but what with the first copy going missing in the post and being busy it's only now I've had the chance to have more than a flick through. I have of course started with chapter one, Analyzing Business Requirements, you may be thinking why a book about MySQL starts with a chapter on a subject which is more related to application design, I don't think many people would have even noticed if it had been missing and the book kicked off with chapter two Index Concept. But this raises a really important point, and one which is often missed in the development process. The database is an essential part of most IT projects, it should be kept in mind from the very start.

In my experience of projects I've worked on the database has often been an after thought. Take for example a recent project I worked on, it was a large …

Lets see, since 4:30 I have ->

Dinked up a feature for LJ.

Finished up a chunk of AZIO for MySQL.

Wrote a converter to dump one of my flat file databases of addresses out of the flat file and into VCARD.

Not heated up the Chili like I told Christine I would.

Feared the movie that someone brought home, it has Puppets.

Thought about adding a new field type to MySQL. The request for a UUID () field type calls to me.

Not traveled to a foreign country at the last moment.

Setup the http://planetasterisk.org website. PlanetPlanet! is pretty cake software to make work. Someone should do a Fedora rpm.

Considered that in the future I should trade other open source projects features that I can write in turn for them writing a feature for me. …

Security is a hot topic, particularly for web applications. Essential PHP Security is a book by PHP security expert Chris Shiflett (O'Reilly Media, Inc, October 2005, ISBN 059600656X). Since we already covered SQL injection recently, we chose to publish chapter 2 from this book, "Forms and URLs".

Hi.
It's me again.
That one who is crazy for data structures and believes they are at all useful.
I know you've seen an article about arrays just a few days ago, and it was mine as well, but I have something new to share and here goes.
I told you that arrays were useful.
So useful, in fact, that improving the library itself became quite an easy task.
And so I made some more addition, such as operations on whole arrays, rather than on single items.
(Fifth part of the MySQL 5 general purpose routine library presentation.)
multiple usersIt occurred to me that having arrays in a multi-user environment could be either a blessing or a disaster, depending on which side you are.
If you are likely to see the benefits, having a way of sharing data among users could be a pro.
If you are more focused on the …

If you've ever been tempted to use your MySQL data directory for storing things other than that which is created by MySQL, don't. Today I went to drop a database in our dev environment (in order to rebuild it with a dump from production) and got this response:

mysql-dev> DROP DATABASE medical_admin;
ERROR 1010 (HY000): Error dropping database (can't rmdir './medical_admin/', errno: 17)

I've gotten this very error when triggers were first introduced and the .TRG file wasn't being removed on the DROP (we do not have triggers on this database though, and that bug was fixed). So I trucked (cd) over to the data dir and sure enough, an ls -l on the /data/mysql/medical_admin dirictory revealed:

/data/mysql> ls -l medical_admin
total 1
-rwxr-xr--   1 mysql    mysql         175 Nov 15 13:30 changed_evaluations.dat

Not good. Who knows why that was stuck there, but let me just reiterate that there are much better places …

If you've ever been tempted to use your MySQL data directory for storing things other than that which is created by MySQL, don't. Today I went to DROP a database in our dev environment (in order to rebuild it with a dump from production) and got this response:

mysql-dev> DROP DATABASE medical_admin;
ERROR 1010 (HY000): Error dropping database (can't rmdir './medical_admin/', errno: 17)

I've gotten this very error when triggers were first introduced and the .TRG file wasn't being removed on the DROP (we do not have triggers on this database though, and that bug was fixed). So I trucked (cd) over to the data dir and sure enough, an ls -l on the /data/mysql/medical_admin dirictory revealed:

/data/mysql> ls -l medical_admin
total 1
-rwxr-xr--   1 mysql    mysql         175 Nov 15 13:30 changed_evaluations.dat

Not good. Who knows why that was stuck there, but let me just reiterate that there are much better places …

It seems like just a few days ago when we announced Movable Type on Yahoo! Web Hosting. Understandably, lots of folks asked for WordPress support. Luckily, Matt and the hosting folks have been busy.

Sign up now and get:

• 33% off the monthly price for the first six months, and the setup fee is waived
• Free domain name
• 200GB data transfer per month
• Support for up to 1 million page views per day**
• 5GB disk space for your posts, graphics, and more
• Support for PHP, Perl, and MySQL
• 24-hour toll-free phone support

Enjoy. It's been in the works for quite a while now. :-)

( …

[Error: Irreparable invalid markup ('') in entry. Owner must fix manually. Raw contents below.]

My proposed talk got accepted for the 2006 MySQL UC.

I'm working with to get the Synchronization Manager functioning stably on Linux and Mac OS X. I'm going to tag blogs having to do with this purpose with "mysql uc 2006", in case you're interested in following along.

Chris has been putting a great deal of effort into getting MaxDB -> MySQL synchronization working smoothly and has offered up the documentation of his experience for the good of the community.

He has not stopped there. In fact, he has now gotten the Synchronization Manager running on OS X. We expect both of these features to be working well enough by the 2006 UC to present them to the community and have a public conversation about the subject.

If you're interested in attending this presentation, please …