Archive for September, 2010

Programming bit index support

It seems to me that sometimes using hash tables is not required and thus no need to make another expensive JOINs. Especially, when the number of attributes can be foreseen, you can simply set some bit to on. Imagine, we have a product which has two attributes: new, promotion. Usually, we create 2 tables, `Product` […]

Read more...

MySQL PL/SQL Errors / Exceptions support

Functions like mysql_error() in PHP or try/catch blocks and MySqlException in C# are very helpful to discover problems. Unfortunately, inside stored procedure (routine) there is no ready component to catch errors to see what would return SHOW ERRORS. But I have wanted such feature at my EVENT (Event Scheduler)! Hopefully, I realized that I can […]

Read more...