Browsed by
Tag: mysql

Configuring Zend Framework with Dwoo

Configuring Zend Framework with Dwoo

I spent some time trying to set up Zend Framework using the Quick Start Guide, combined with the Dwoo Template Engine.  Even though there is an actual guide written for the Zend Framework side, as well as a Dwoo adapter and corresponding wiki help page – there still seems to be a lot of confusion around this setup process.  The number of complaints in the comments in the quick start guide combined with the lack of help I was able…

Read More Read More

MySQL Float vs. Decimal Money Datatype

MySQL Float vs. Decimal Money Datatype

It is surprising how often I see confusion around the MySQL float and decimal data types – especially when it comes to deciding which one to use when storing financial figures. Let’s compare the float and decimal definitions, and then compare the two in real use. From the MySQL documentation: Float: A small (single-precision) floating-point number. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38. These are the theoretical limits, based on the IEEE standard. The actual range…

Read More Read More