PlanetMysql.ru — информация о СУБД MySQL

The business-logic should not be the task of a database server, because hardware of database servers is mostly more expensive than the sheet metal of some stupid application servers. The other problem are inconsistencies if you change the code-base on a large database cluster very often. You could reduce the risk of inconsistency with batches, but that does not solve the problem completely. However, I've developed a handful of stored functions to simplify queries, reduce index sizes and to shorten strings where only a small portion is needed, which in turn saves a lot of bandwidth.

Read the rest »

PlanetMySQL Voting: Vote UP / Vote DOWN

The business-logic should not be the task of a database server, because hardware of database servers is mostly more expensive than the sheet metal of some stupid application servers. The other problem are inconsistencies if you change the code-base on a large database cluster very often. You could reduce the risk of inconsistency with batches, but that does not solve the problem completely. However, I've developed a handful of stored functions to simplify queries, reduce index sizes and to shorten strings where only a small portion is needed, which in turn saves a lot of bandwidth.

Read the rest »

PlanetMySQL Voting: Vote UP / Vote DOWN

Recently I saw a MySQL Stored Function requirement on Experts-Exchange for converting date into some specific words format. You may find MySQL function for date to words conversion online; even udfs might be ready, but I decided to write my own. I wrote this simple function mainly based on SELECT CASE to convert dates in to words [...] Related posts:

1. bat – batch file to create formatted date time (ddmmyyyy) directory
2. Stored procedure to Find database objects
3. MySQL Stored procedure to Generate-Extract Insert Statement

PlanetMySQL Voting: Vote UP / Vote DOWN