Introduction to MySQL 5.5

In this John Russell's article you can read about speed, scalability, usability of the MySQL database and the InnoDB storage engine.
Read more.

Rinaldo

Pentaho Report Designer and Excel Data Sources - Analyse This

In this tutorial Prashant show us that Pentaho Report Designer (PRD) can be  an alternative to Mircosoft Excel, Access or other big BI vendors.
read it.

How to Identify an Apple iPhone, iPod or iPad Visitor to Your Website

Today I report an article where Creg Blucker  with javascript and php examples explains how to catch the visitors of your site using Apple's iPhone, iPod or iPad.

Read more ...

Rinaldo

Open Source Reuse Rating Service

Through LinkedIn, I received an email reporting that Antelink has released the Beta version of it's 'Open Source Reuse Rating Service'.
On their blog you can find a summary about this project and a use case based on the Apache Commons libraries.
Read more...

Rinaldo

How to implement UI testing without shooting yourself in the foot

From Gojko Adzic
in this post Gojko present what he consider a very good practice for how to do UI test automation efficiently.

How to implement UI testing without shooting yourself in the foot

Rinaldo

MySQL :: Top Reasons to Use MySQL

MySQL® database maybe the world most popular open source why?
MySQL :: Top Reasons to Use MySQL

Install Open ERP 5.0.6 on Mac OS X 10.5.8 Leopard | Christopher R. Shackleton, MD

From Cristopher R.Shackleton I suggest you this post

Install Open ERP 5.0.6 on Mac OS X 10.5.8 Leopard

Intercept null value on a query

These last days working to create a Pentaho report with openERP data, I came across a serious problem:
if a query return a null value arithmetic operations are in error. The question was how to intercept the null value, surfing on Google I found this

SELECT IFNULL (1,0) this query return 1
SELECT IFNULL(null, 0) this query return 0

Fine my problem was solved NO!!  openERP use postgresql and postgresql doesn't support IFNULL
Again surfing on Google and I found COALESCE
The postgresql manual say:

The COALESCE function returns the first arguments of ITS THAT IS NOT NULL. Returned is null only if all arguments are null. Often it is used to substitute a default value for null values 

Finally my problem was solved my query now  is something like this
SELECT COALESCE(sum(aal.amount * -1) , 0) FROM account_analytic_line AS aal WHERE (aal.account_id=83) and aal.journal_id = 3

Rinaldo

5 Levels of Agile Planning: From Enterprise Product Vision to Team Stand-up

To day I need to suggest a paper that evaluates agile practices when applied in multi-team and multi-person-year projects. Download it here  


Rinaldo