Today I’m very pleased. My UDF lib ‘lib_mysqludf_xql’ has been mentioned in an article by Jon Stephens about ‘Using XML in MySQL 5.1 and 6.0′.

The lib_mysqludf_xql you can query relational data and return XML. It will give you the same functionality as SQL/XML in Oracle and MS SQL. Compares to other methods like using CONCAT or generating XML in a PHP script, this method is much easier and will perform much better.

You can find the library at mysqludf.org, including some documentation. You can also find a bunch of other nice libs there.

Do note that you need to have root privileges on the server to install MySQL UDFs.

If you are interested in the MySQL packages in Debian, join #debian-mysql on OFTC. Most people involved into the packages are hanging around there.

Neither of the books I’ve been an author of has been just me. For Practical MythTV (Christmas is coming, buy it for all your TV and tech loving friends!), Michael Still and I worked hard to get a well rounded and practical (not to mention good) book. I think we succeeded - certainly has gotten positive reviews (check the amazon page).

For my second endeavor (just to make it fun, I was working on both at the same time) we have a much longer list of authors. The aim was to write a study guide for those wishing to be certified in MySQL Cluster. Being a developer with a fair bit of knowledge in the product (and somebody who also presents and writes) - I was a natural …

Today's entry, provided by Terry Chay, is entitled Filter Input; Escape Output: Security Principles and Practice.

Name

Terry Chay

Blog

terrychay.com/blog/

Biography

When Zend puts your face on a trading card, you've either arrived in the PHP world, or you're a terrorist. Terry Chay is a …

We are just passed the time of year when we give thanks (in the US anyway) and we are coming up on the time when we all try and be giving.  I feel like my last few blog posts have been a little too negative and want to make up for that.  So, I want to say thank you to some people for what I have in my professional world.

Daniel deGrandpre and Richard Moss, dealnews.com
I have known both these guys since I was a kid.  I was so excited when they offered me a full time job working on the internet.  I was in a Dilbert world and they rescued me.  Richard gave me the best recommendation I have ever heard.  I listed Richard as a reference for the job I had before dealnews.com.  The interviewer told me that when she asked Richard why she should hire me, he said “Because if I had the money, he would be working for me.”  A year later, when I told her I was leaving …

I like driving. It relaxes me. I especially like driving in the Carolinas versus driving the freeways in Los Angeles. In LA, you have to intentionally calm yourself down before going to the on ramp of the 101, 5 or the 10. Here, in South Carolina, it is possible to drive highway speeds on the highways (in LA, it is possible, but only at night time or early in the morning).When I heard that

Today I received the "MySQL 5.1 Cluster Certification Study Guide".

I will compare this book to the "MySQL 5.0 Certification Study Guide" from MySQL Press. This is the book I used to study for the MCDEV (Certified Developer) and MCDBA (Certified DBA) exams.

The MySQL study guide was published by MySQL Press which is a cooperation with a n old-school publisher.

The MySQL cluster study guide  is published by Lulu.com which is an online on-demand publisher.

Lulu.com Cons:
1. The print quality is worse.
2. The paper is less white.
3. The layout is more compact. The margins are really small.

Lulu.com Pros:
1. On-demand print. This will make updated versions possible.
2. The book is smaller (small margins) and is very easy to carry with you (handy if your …

Firstly, I have to apologize. I have been busy with some personal things and also been looking for a new job, so I haven't had a lot of time to update my blog.

I have read something on Coding Horror (which is a really good blog, by the way) about whats called "analysis paralysis".
I myself, often get stuck in this stage. Especially in a paradigm-rich environment like java, which gives you many philosophies about how to do things more effectively, when I myself have to admit that it would take less time to just start to do some code and make corrections later. For the people, that have been following my blog, I do talk a lot about theory and not a lot about action. This is something I would very much like to change. So I plan to take my idea for " …

mysql connector/odbc 5.1.1-beta is available.

we didn?t implement all of the features in our original plan, but we decided to close out 5.1 to new features so that we could work on getting it to a production (GA) release as soon as possible.

5.1 has it?s share of bugs still, but we have tackled the most serious ones, and now that we are done with features (for the time being) we can focus on making the GA release shine.

now the race is on to see who gets out a 5.1 GA release first ? the server or connector/odbc!

Today to debug one of the issue related to InnoDB where the INSERT INTO .. SELECT simply bails with an error as “ERROR 1105 (HY000): Unknown error”; I simply started loading the data onto 5.1 server as it was consistent in 4.1 version (even though it was noted as fixed). So, LOAD DATA INFILE suddenly pops with an error as ..

1
2
3
4
5
6
7
8
9

      mysql> LOAD DATA LOCAL INFILE 'venudata-all.txt' INTO TABLE DOCUMENT_DESC FIELDS TERMINATED BY ',';
ERROR 1148 (42000): The used command IS NOT allowed with this MySQL version
mysql> SHOW variables LIKE '%infile%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| …