Barcelona MySQL Meetup

June 20, 2017

Upcoming Barcelona MySQL User Group Meetup,

Barcelona, Spain, July 5, 2017

It’s our pleasure to announce and invite you to the next Barcelona MySQL User Group Meetup scheduled for Wednesday, July 5, 2017. Please find more details below:

Date: July 5, 2017
Time: 19:00 – 21:00
Place: Mobile World Center, C/Fontanella 2, 08002 Barcelona, Spain (map)
Proposed agenda:
MySQL Failover and Orchestrator by Simon Mudd, the co-organizer of MySQL User Group in Madrid and database administrator of

More information & registration available at Meetup.
We are looking forward meeting you there!


The London MySQL Meetup

April 25, 2017

The various MySQL User Groups or MySQL Meetups around the world are made of up of various groups of individuals that all have a passion for MySQL. Some are large and intense like San Francisco or Boston. Others are fun loving like Chicago or obviously vary hard working like Oklahoma City. I recommend for those of you that travel to connect with these groups. But there is one group that is a little special. They meet in a pub, upstairs in the back. There is a bar and bartender. The food is very good and the attendees very sharp. If you get a chance, visit the London MySQL Meetup

I had been in York a few days before and was invited by Ivan Zoratti, a long time institution of the MySQL Community and Meetup organizer to present on MySQL 8. I made it to The Lamb, a pub on Conduit street and made my way to the meeting room. I was greeted by the bartender (a nice addition to your meeting if you can arrange it) and soon the room filled. I gave my presentation and we then started a fun question & answer period.

All too soon we realized it was getting very late and had to disband. But I had a wonderful time and decided that I need to make a return visit.

So if you find yourself in London, please take the effort to try to attend one of the London MySQL Meetup meetings.

MySQL NYC Meetup Wednesday!

July 13, 2015

The MySQL NYC Meetup is this Wednesday, July 15th in the Oracle office at 120 Park Avenue. I will be talking about MySQL 5.7 and the event is free but you must RSVP by 6PM July 14 (and bring ID).

Dallas PHP Users Group Meeting Rescheduled to Jan 21st

January 14, 2015

Dave Stokes: SQL for PHP Programmers

Wednesday, Jan 21, 2015, 7:00 PM

SoftLayer Offices
4849 Alpha Rd Dallas, TX

50 PHP Developers Went

This month we welcome back Dave Stokes to share some excellent SQL knowledge. He’ll be presenting a regular session length of his tutorial talk “SQL for PHP Developers”:————-PHP Programmers know the latest and greatest on their preferred language, are excellent at Javascript but very few have had any training in SQL.  This presentation co…

Check out this Meetup →

Wednesday, January 21, 2015
7:00 PM

SoftLayer Offices
4849 Alpha Rd, Dallas, TX (map)

Come in the doors by the flagpoles, check in with security then it’s upstairs to the left
This month we welcome back MySQL Community Manager Dave Stokes from Oracle to share some excellent SQL knowledge. He’ll be presenting a regular session length of his tutorial talk “SQL for PHP Developers”:


PHP Programmers know the latest and greatest on their preferred language, are excellent at Javascript but very few have had any training in SQL. This presentation covers the differences in a declarative language (SQL) and an Object-Orientated/Procedural language (PHP), how relational theory is supposed to work, and how to let the database do the heavy lifting to make your life easier.
Come out on Tuesday the 20th at 7pm at the SoftLayer offices on Alpha to hang out with fellow developers and hear about this great topic!

Where: SoftLayer Offices on Alpha Rd

Who: Dave Stokes

When: Wednesday, January 21st @ 7pm

SQL For PHP Programmers at the world’s largest PHP user group — Dallas PHP

January 7, 2015

I will be presenting ‘SQL for PHP Programmers’ on Tuesday January 13th (please RSVP) at the Dallas PHP meeting.

After attending many PHP Conferences and user groups, I was shocked to fins so few developers had had any training in SQL. They were great with PHP obviously, Javascript, various frame works, and parts of modern programming but only 2 percent that I survived had any SQL training. Heck you could empty a room and have them leave skid marks by saying ‘relational calculus’. So I developed a workshop for last years PHPWorld to begin to rectify the dearth of SQL knowledge problem.

Oh, and I can answer questions about MySQL for attendees also.

Tuesday, January 13, 2015
7:00 PM

SoftLayer Offices
4849 Alpha Rd, Dallas, TX MAP

DFW Unix User Group – MySQL Workbench January 8th

December 17, 2014

MySQL Workbench will be the subject of the January 8th presentation of the DFW Unix User Group. Pizza before the meeting at the IBM Innovation Center at 1177 South Beltline Road, in Coppell, just south of the Airline Drive traffic light, and just west of North Lake.

MySQL Workbench Performance Dashboard

Workbench 6.2, CakePHP’s new ORM, and OKC Meetup on Wednesday

August 26, 2014

In the beginning was the MySQL command line and it was good. Verbose yes, error prone yes, and even tedious. But it was good. The UPDATE USER set SELECT_PRIV=’Y’, DROP_PRIV_’Y”, UPDATE_PRIV=’Y’,……,LAST_BLOODY_PRIV=’Y”; type errors have caught of us old timers. But it was still good.

Then came some GUI tools that were okay. Not great but they had their uses.

And then came MySQL Workbench. And it was very good.

Now there is MySQL Workbench 6.2 and it is excellent. It came out in Beta last week and has built on the proven success of its predecessors. All the usual stuff is there – Server Status, Users & Privileges, Startup/Shutdown, logs, Dashboard, Performance Reports and more. But there area whole bunch of subtle little tweaks that make it easier to use.

For instance, the VISUAL EXPLAIN allows toggling between the visual display and the tabular display. Plus you can now get query stats like the number of rows processed, joins per table, sorting information, and even how many temporary tables were created. And it is easier to toggle between the explain panel and the results grid.

Now that I am back from Europe, I will write a little more on this in the following days.

CakePHP’s new ORMCakePHP 2014 attendees in Madrid

I attended Cakefest in Madrid to hear about the latest in CakePHP. Version 3.0 is almost ready to launch and has many new features that will help speed its adoption. Chief among them is a new ORM’s query builder that is well designed, intuitive, and easy to use. Under the covers is PDO prepared statements to help protect against SQL injection.

Most Object Relational Modelers remind me of a juggler balanced on a large ball while simultaneously swinging a Hulla-hoop around his middle while trying to order coffee in a crowded Starbucks. Too much action for something that can be done much simpler. Object Oriented programmers want everything as an object but the rigors most ORMs demand if much more complicated than writing good SQL in the first place.

The new CakePHP ORM is based on a data mapper pattern and easily interfaces with MySQL, Postgres and SQLserver. The query builder is designed to take advantage of MySQL 5.6 features like improved sub queries. They hope soon to offer Oracle database support. The design is light, easy to read, and can take advantage of sub queries. My preference is still for well written SQL but this query builder is not bad. I am sure it will catch the attention of those who fight other ORMs in their projects.

Next years is CakePHP’s fifteenth anniversary and their spirited crew is doing great things. If you have not investigated them in a while, you really need to spend some time with their new 3.0.

Oklahoma MySQL Meetup

And I will be heading up I35 to talk to the OKC MySQL Meetup tomorrow. Hope to see you if you are in the area!