I’m seeking help from the MySQL community for what tools are used today to generate complex reports for enterprise applications that use MySQL. In an Oracle world, you have Oracle Report Writer , in Microsoft Crystal Reports .
In the open source world there is Jasper Reports , Pentaho Reports and BIRT however I don’t know the power of complex reporting with these.
If anybody has experience using or evaluating these tools please let me know. This may lead to possible work.
Having covered the preparation and character set options of performing a latin1 to utf8 MySQL migration, just how do you perform the migration correctly. Example Case Just to recap, we have the following example table and data.
Read moreMySQL has the same level of data integrity for numbers and strings as Oracle; when MySQL is correctly configured. By default (a reason I wish I knew why it is still the default), MySQL performs silent conversions on boundary conditions of data that will result in your data not always being what is specified.
Read moreWhile some may think I’m daft, I have a legitimate reason for wanting to crash mysqld. However first we need to find a way to crash it. Great thanks to Alan K, Mark L, Harrison and Hartmut on #mysql-dev for several suggestions and a config option I was unaware of.
Read more