The Date dimension is a well known construct in general data warehousing. In many cases, the data for a date dimension is generated using a database stored procedure or shell-script.

Another approach to obtain the data for a date dimension is to generate it using an ETL tool like Pentaho Data Integration, a.k.a. Kettle. I think this approach makes sense for a number of reasons:

• 
  
• When you tend to use a particular ETL tool, you will be able to reuse the date dimension generator over an over, and on different database platforms.
  
• You won't need special database privileges beyond the ones you need …

New MySQL 6.0 Alpha Release

If you are reading this, chances are you already know the advantages of open source. Open source is free, benefits from a community of contributors, it's well tested, the list of benefits is long... right?

Well, I agree. It's hard to believe that someone would choose anything but apache to run a web server. But software runs in a lot of different places, different industries and cultures. In the world of billing, we are about 15 years behind the industry standard, as far as open source adoption goes. The other day I had in my hands an issue of a billing magazine (Billing & OSS World, I think is its name). They had an article on open source and it was half funny, half depressing. Open source was synonym of Linux, that's all. Like there is nothing else in the open source world but Linux.

In about two months, jbilling will be launching a new major release that will include a package of components that address es the needs of …

If you are reading this, chances are you already know the advantages of open source. Open source is free, benefits from a community of contributors, it's well tested, the list of benefits is long... right?

Well, I agree. It's hard to believe that someone would choose anything but apache to run a web server. But software runs in a lot of different places, different industries and cultures. In the world of billing, we are about 15 years behind the industry standard, as far as open source adoption goes. The other day I had in my hands an issue of a billing magazine (Billing & OSS World, I think is its name). They had an article on open source and it was half funny, half depressing. Open source was synonym of Linux, that's all. Like there is nothing else in the open source world but Linux.

In about two months, jbilling will be launching a new major release that will include a package of components that address es the needs of …

HighLoad.RU is the conference focused on Building High Performance Systems and has speakers from most of top Russian Internet companies.

It is taking place in Moscow, Russia 24-25 of September and you should know a bit of Russian to attend

The conference has some international flavor though there are few people coming from other countries and giving talks in English. I too will fly from London but I'll specially prepare Russian presentation versions.

I'll have two sessions: MySQL Transactional Storage Engines and MySQL Scaling Techniques for Web Applications.

Here is the full conference program.

Andrey has implemented a little mysqlnd only addition to mysqli_debug(): ‘m’ - dump memory information. It works like the other options described in PHP: Debugging ext/mysqli and mysqlnd with the only difference that it is only available with mysqlnd.

Without option ‘m’

This is a short example of mysqlnd freeing the meta data of a result set.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : persistent=0
| | | | info : Freeing fields metadata
| | | | info : Freeing zend_hash_keys
| | | | info : Freeing metadata structure
| | | >mysqlnd_res_meta::free
[...]

Additional mysqlnd memory allocation debug information with option ‘m’

Same trace excerpt but with memory debugging turned on. The control string used for this trace was ‘t:O,/tmp/mysqlnd.trace:m’.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : …

Andrey has implemented a little mysqlnd only addition to mysqli_debug(): ‘m’ - dump memory information. It works like the other options described in PHP: Debugging ext/mysqli and mysqlnd with the only difference that it is only available with mysqlnd.

Without option ‘m’

This is a short example of mysqlnd freeing the meta data of a result set.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : persistent=0
| | | | info : Freeing fields metadata
| | | | info : Freeing zend_hash_keys
| | | | info : Freeing metadata structure
| | | >mysqlnd_res_meta::free
[...]

Additional mysqlnd memory allocation debug information with option ‘m’

Same trace excerpt but with memory debugging turned on. The control string used for this trace was ‘t:O,/tmp/mysqlnd.trace:m’.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : …

I thought my PHP/MySQL friends would get a kick out of another story of a company not being ready for technical demand.  I live in Alabama (southeastern USA).  For those that do not realize, we like our college football a lot (American football that is).  University of Alabama football has a particularly large buzz this year due to the hiring of our new coach, Nick Saban.  The first game of the year was this past Saturday.  It was not on network or cable television since it was against a no name team.  It was however available on Pay-Per-View for $29 or something (I don’t even know, I just ordered it blind).  Since getting tickets for me and my family was not really an option, I decided to just order the game and watch from the comfort of my home.  Directv tells you (a lot) that the easiest way to order sports events is their web …

One of the key features MySQL often uses to advertise for their database is the modular architecture that allows them to have different storage engines below the same SQL layer. In practice the application and/or database designer can choose from a variety of low level data storage implementations that each offer different characteristics and may be chosen on a per table basis. (Even though I personally believe most designs will use one type of table for all tables of a particular schema).

The idea behind this is that for example people who do not need transactions should not have to worry about them at all ? maybe there is performance impact involved which they cannot afford to take. Moreover some specialized types of index or column might not be available on all engines. Basically the concept is very interesting and can be really useful for developers.

However there is a weakness that in my opinion needs some severe work to be …