The last half of January is going to be busy but here is where to catch me and some MySQL SWAG.

First I will be speaking at SkiPHP on the 14th and 15th. Then is it off to San Diego meet up with the San Diego PHP Meetup on the 19th. Next is the Southern California Linux Expo where MySQL is sponsoring a track from the 21st to the 24th. That is followed by a quick trip to the MySQL and Friend Room at FOSDEM to end the month. Finally back to DFW where there will be a meeting of the North Texas MySQL Users Group on the 15th of February.

…

Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:

" Database Workbench 5.1.10 "

This release adds a few small features and includes Windows Terminal Server support.

The full version 5.1.x change log is available here.

Version 5 added numerous new features and improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux.

Version 5.1 includes SQL Azure and Firebird 3 support, additional data export functionality, improved Oracle XML and Object-type support, Diagramming enhancements and new printing features as well as improvements …

Database folks are a pain in the rear to shop for at holiday time. So print out a copy of this blog post, circle the items that you really like, and give this to someone who does the shopping for presents.

It is once again time for the MySQL holiday present list for that database person in your life. These quirky folks have unique tastes in presents and this list reflects this in abundance.

First item: Hello Kitty Screen Cleaner.

Hello Kitty Screen Cleaner available at many retailers near you and the perfect gift for those who spend long hours at their monitors.

Everyone loves a clean screen and Hello Kitty Screen Cleaner is the second best thing to have a real cat complete with rough tongue to scrub your screen. Does Hello Kitty Screen Cleaner work better than say Thor Screen Cleaner? Doubtful but the bright pink and friendly face help remind your data nerd to keep things hygienic.

…

MySQL 5.7 and PHP 7 are the latest versions releases of two ofthe LAMP Stack pillars. In the past I have detailed how to use the MySQL apt-get repository to upgrade Ubuntu to the latest and greatest. But that about PHP 7? This is a fairly simple update for someone running a traditional LAMP (Linux Apache MySQL and PHP) server. There are also great directions out there on updating Nginx for those so inclined to be found with a quick search.

sudo apt-get install python-software-properties
sudo add-apt-repository ppa:ondrej/php-7.0
sudo apt-get update
sudo apt-get purge php5-fpm
sudo apt-get install php7.0-cli php7.0-common libapache2-mod-php7.0 php7.0 php7.0-mysql php7.0-fpm php7.0-curl php7.0-gd php7.0-mysql
cp /usr/local/php7/libphp7.so /usr/lib/apache2/modules/


Then a …

Need to convert between GeoJSON documents and spatial values? MySQL 5.7 has two functions that do just that. GeoJSON is an open standard for encoding geometric/geographical features. ST_AsGeoJSON generates a GeoJSON object from the geometry while ST_AsText parses a string str representing a GeoJSON object and returns a geometry.

Details at Spatial GeoJSON Functions

Based in Italy, SERNAV Group was founded in 1989 and manages the complete cycle of marine transportation activities. The companies of the group handle shipping agents, customs operations, overland and nautical transportation of conventional goods & containers, storing, loading and unloading of containers as well as logistics and distribution.

Challenges

• Modernize the customer application allowing the management of all necessary documents related to the different marine transportation activities of the SERNAV Group.
• Implement an enterprise-class infrastructure delivering the required performance, reliability and uptime while maintaining a low Total Cost of Ownership (TCO).

Solution

• SERNAV hired the system integrator & Oracle partner Teleion to help them select, implement and manage the new infrastructure.
• Teleion …

We are pleased to announce that MySQL Enterprise Monitor 3.1.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a few weeks. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

You will also find the binaries on the Oracle Software Delivery Cloud in a few weeks. Choose "MySQL Database" as the Product Pack and you …

MySQL User Conference Japan is back to Tokyo. We'd like to the event in Tokyo planned on Dec. 15th, celebrating 20 years anniversary of MySQL, 15 years anniversary of MySQL Nippon Association (aka MySQL User Group Japan), and 5 years of Oracle's stewardship with MySQL. Sessions are including MySQL 5.7 optimizer updates, Utilization of MySQL Binlog, Evaluation of MySQL + Oracle Clusterware, and much more. Please find more details below:

• Date: Dec. 15th, 2015
• Start Time: 10am
• Place: Fukuracia Tokyo Station

Speakers:

• Masahiro Tomita, Leader of MySQL Nippon Association (aka MySQL User Group Japan)
• Satoshi Mitani, Database Administrator "Kuro-obi", Yahoo! Japan
• Kenji Hirohama, Infrastructure Integration Div Manager, SCSK
• @yoku0825, Oracle ACE (MySQL) …

Earlier this week the MySQL team participated to the Forum PHP in Paris. It was a great conference, attracting over 600 developers who could attend about 40 talks in 3 parallel tracks. An excellent way to celebrate the 20 years of PHP and the 15 years of AFUP, the French PHP users association in charge of the event; great job! 2015 really is a year of anniversaries!

Oracle’s MySQL VP of Engineering Tomas Ulin delivered a very well received presentation entitled “MySQL 5.7 & JSON: New opportunities for developers”. The slides are available on slideshare. Thanks to Morgan Tocker for his help with the content.

While in Paris Tomas met with Le Monde Informatique, you can read their article …