So, Qcodo. I've seen a tiny bit of "wow" and a lot of "hadn't heard of that". It's clearly not on the buzz radar... maybe because it's for PHP 5 only, and many people haven't yet taken the step to run it (please do, it's good stuff!)

Anyway, I've been told about Qcodo is that it's like rails for PHP: very rapid web development, and with MySQL schema, app and queries automatically built based on the data model you design (which is where development starts). That's definitely the right order of development! ;-)

I'd say, take a look over the holidays, write/blog/scream about it... could be very very cool stuff. Perhaps drop me a comment or msg to tell me about your experience. I'm just curious.

So, Qcodo. I've seen a tiny bit of "wow" and a lot of "hadn't heard of that". It's clearly not on the buzz radar... maybe because it's for PHP 5 only, and many people haven't yet taken the step to run it (please do, it's good stuff!)

Anyway, I've been told about Qcodo is that it's like rails for PHP: very rapid web development, and with MySQL schema, app and queries automatically built based on the data model you design (which is where development starts). That's definitely the right order of development! ;-)

I'd say, take a look over the holidays, write/blog/scream about it... could be very very cool stuff. Perhaps drop me a comment or msg to tell me about your experience. I'm just curious.

The virtual doors have just opened -- sign up before early registration ends on March 6 and save up to $200.

2006 MySQL Users Conference is April 24-27, 2006 in Santa Clara, California.

Lots of detail there and via Planet MySQL.

The virtual doors have just opened -- sign up before early registration ends on March 6 and save up to $200.

2006 MySQL Users Conference is April 24-27, 2006 in Santa Clara, California.

Lots of detail there and via Planet MySQL.

I spend a fair amount of time on the MySQL forums and also over on the Quest Pipelines answering questions. I've mentioned on a few occasions about how I think this benefits me as much as the person asking questions, but one thing I've noticed a lot recently is the amount of, for the want of a better word, bad questions.

In reality there are no bad or wrong questions, we all have to start somewhere, but what appears to be a problem is people only putting in the minimum of effort when asking, which often results in an equal amount of effort when people answer. Despite the rewarding nature of answering, a person is far more likely to help if they can answer the question easily or at least is given enough information to be able to answer fully. One of the problems with forums is that it doesn't lend its self to a conversational style, especially given the international nature of the web, I'm often dealing with questions from people …

Related: Google XSS Example

I'm sure this will be getting some attention, because everything Google does gets attention. :-)

The recent cross-site scripting (XSS) vulnerability discovered in Google perfectly illustrates why character encoding matters. This example demonstrates how to use PHP's htmlentities() with the optional third argument that indicates the character encoding:

<?php 
 
$html = array(); 
 
$html['username'] = htmlentities($clean['username'], 
                    ENT_QUOTES, 'UTF-8'); 
 
echo "

Welcome back, {$html['username']}.

";

?>

The example uses UTF-8, so this should be indicated in the Content-Type header:

Content-Type: text/html; charset=UTF-8

Researchers at …

Today I finally released the next MDB2 version which finally promises a stable API. I am hoping to actually be able to release the first release labeled as "stable" before the end of the year. I have also pushed new releases for the two MySQL drivers, the PostGreSQL driver, the Oracle OCI8 driver, the SQLite 2.x driver and the Querysim driver. Furthermore I have released an updated version of …

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 …