Pages

▼
Friday, January 27, 2006

MySQL 5 general purpose routine library - VII: Testing and best practices

›
(Seventh part of the MySQL 5 general purpose routine library presentation.) Test units Testing is often considered a boring activity, somet...
2 comments:

MySQL 5 general purpose routine library - VI : Globals

›
(Sixth part of the MySQL 5 general purpose routine library presentation.) Among the General Puropose Routines there are some that are more ...
Sunday, January 08, 2006

Checking MySQL weak passwords

›
Do you have a policy of strong passwords? Do you want to enforce it? If yes, then you may want a quick way of checking if your users are abi...
2 comments:
Saturday, December 31, 2005

New Year quiz

›
A few days ago I was asked to analyze some data related to a particular service usage in a large communications provider. The (simplified) t...
1 comment:
Friday, December 30, 2005

function WELL_KNOWN_FUNC does not exist

›
That came today in a newsgroup. A user was complaining that he was able to encrypt and decrypt some data with an early release of MySQL 5.0 ...
1 comment:
Tuesday, December 20, 2005

MySQL 5 general purpose routine library - V : more on arrays

›
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 abou...
Monday, December 19, 2005

Dumping GIS data

›
Today I needed to dump a table containing GIS data and I could not find a quick way of exporting such data into a WKT format. Since I had a...
Monday, December 12, 2005

MySQL 5 general purpose routine library - IV: Syntax helpers and named parameters

›
(Fourth part of the MySQL 5 general purpose routine library presentation.) SYNTAX HELPERS No matter how skilled you are as a programmer, wh...
Friday, December 09, 2005

Creating triggers in MSQL 5.0 without SUPER privilege

›
Trigger grants blues Triggers are a great feature, and used with care they can prove very useful. Unfortunately, since they arrived quite la...
6 comments:
Sunday, December 04, 2005

MySQL 5 general purpose routine library - III : Using "FOR EACH" loops

›
(Third part of the MySQL 5 general purpose routine library presentation.) How many times, while using a MySQL client, you were facing a pro...