San Diegans — learn about MySQL’s New JSON Data Type Tonight

January 19, 2016

I will be speaking at the San Diego PHP Meetup tonight January 19th at 7pm. The location is Media, 1900 Wright Place in Carlsbad (33.122360, -117.28909) and the topic will be MySQL’s JSON Data Type. I hope to see you there!

See you in Salt Lake City, San Diego, Pasadena, Brussels or Frisco!

January 8, 2016

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.

Annual Holiday Shopping List

December 14, 2015

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.

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.

Second item: DBA Coffee Cup
DBA Coffee Cup

Third: DBA t-shirts

Forth: Think Geek Coffee Cup

Fifth: And you can always buy tickets for the new Star Wars movie because, as you will be told, there is so much to see on the ‘tenth and twelfth’ viewing.

Any other suggestions? Please leave them in a comment.

Lucky Sevens — MySQL 5.7 and PHP 7

December 10, 2015

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/ /usr/lib/apache2/modules/

Then a quick test program:
$mysqli = new mysqli("localhost", "root", "hidave", "world");

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());

/* print MySQL server version */

PHP version: %s

", phpversion());

MySQL version: %s

", $mysqli->server_info);
printf ("

System status: %s

", $mysqli->stat());


And the result:
PHP version:

MySQL version: 5.7.9

System status: Uptime: 2102 Threads: 1 Questions: 12 Slow queries: 0 Opens: 107 Flush tables: 1 Open tables: 26 Queries per second avg: 0.005

Please note that you will have to update your code if you use the old and no deprecated mysql calls instead of the supported mysqli calls.

Converting between GeoJSON documents and spatial values with MySQL 5.7

December 1, 2015

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

Need a quick MySQL 5.7 PHP Vagrant environment?

November 20, 2015

The Laravel folks are not letting the grass grow under their feet. The popular PHP Framework (motto ‘The PHP Framework For Web Artisans’) wraps their framework and the recently released MySQL 5.7 server software in a Vagrant image called Homestead ready for you to use.

I created a new directory for my new Laravel work, cd-ed into it, and then issued vagrant init laravel/homestead. As quick as my hotel wi-fi could support, I had 5.7, PHP 5.6.15 plus more on an Ubuntu 14.04 LTS virtual machine.

So if you want to easily try MySQL 5.7 or Laravel please Laravel Homestead a try

Links to Slides from MySQL Central @ Oracle Open World

November 4, 2015

Did you want a copy of a presentation slides from MySQL Central @ Oracle Open World? You can find them here

See the plus sign to the left of the title? Click on that and it will expand the entry to see the link for the presentation

See the plus sign to the left of the title? Click on that and it will expand the entry to see the link for the presentation

Click on the plus sign next to the title to expose the link to the presentation and to see the description. The two pics are the unexpanded and expanded views of one of the tutorials.

And  there is the link to the presentation!

And there is the link to the presentation!


Get every new post delivered to your Inbox.

Join 941 other followers