You may have noticed a lot of talk about the recent agreement that Oracle will buy Sun, however nothing has been mentioned yet as of the fate of MySQL; which Sun subsidized not too long ago. Many are worried MySQL will be removed from their line of products/services; however this is highly unlikely due to the global popularity of MySQL.
It will be interesting to see where Oracle takes MySQL over the next few months.
This is a heads up for developers. We will document the coding standards before we release the early "developers" release of phpFox2, however just wanted to get as much information out there to prepare anyone interested in creating mods for the upcoming release.
Our current version (1.6.x) is not compliant with many of the MySQL sql-modes provided. Many clients running MySQL 5 has had problems since strict mode was enabled so we needed to provide a way to disable this setting if enabled which we did shortly thereafter.
Since phpFox2 will support other database drivers and not just MySQL we needed to implement a strict set of coding standards for SQL. So when developing a mod you will need to use standard SQL coding standards and make sure to not get too comfortable with a lot of the lax queries allowed with MySQL when no sql-modes are set. We are developing the product using MySQL and in order to make sure it will be compliant with the other database drivers the following needs to be added/updated in your MySQL configuration file (my.cnf):
sql-mode = "STRICT_TRANS_TABLES,STRICT_ALL_TABLES,PIPES_AS_CONCAT, ANSI_QUOTES,IGNORE_SPACE,NO_KEY_OPTIONS,NO_TABLE_OPTION S,NO_FIELD_OPTIONS"
For more information on the sql modes MySQL provides you can check them here.
