Showing entries 1 to 10 of 770
10 Older Entries »
Little Rock Tech Fest, Symfony Live, Zendcon, Oracle Open World, Oracle Code One, and Madison PHP

October promises to be a busy month. I will be at the Little Rock Tech Fest October 4th and 5th speaking on The Proper Care and Feeding of a MySQL Database and MySQL 8. Then I am off to San Francisco to speak on MySQL Tips and Tricks on October 12th at Symphony Live USA. Then it is off to Las Vegas and Zendcon where I will speaking on MySQL 8 and MySQL Without the SQL.

Next is the dynamic duo of Oracle Openworld and Oracle Code One. I have a talk at Oracle Code One on the MySQl X DevAPI and PHP

[Read more]
PHP on the West Coast

I was barely back from the UK when I got back on a jet and made my way to Portland for CascadiaPHP where I will speaking on the MySQL Document Store.

Then it is down to my home town of San Diego for WavePHP to talk about MySQL 8.

The PHP community has been blessed this year by the big shift to the PHP 7 series AND a slew of new shows. Austin, Detroit, Nashville, Portland, and San Diego.

If you attend either show, I have lots of swag — plush dolphins, squish dolphins, stickers, and a handful of my book. And if you are good on all that please stop by and say hello.

Wales and London next week

Next week is a trip to Swansea in Wales for SwanseaCon on Monday the 10th where I will be speaking on MySQL 8 Server Optimization. And then the next day in London is the London MySQL Meetup.

SwanseaCon is a one day, agile development and software craftsmanship conference for Software Developers, Software Testers, Business Analysts, Scrum Masters, Software Architects, Project Managers and Consultants in Wales. This is the forth year in the beautiful sea side city and the audience is extremely sharp. The talk subjects range from mine to The Systemics of the Liskov Substitution Principle, and I am here for an argument – Working with conflict in teams.

The London MySQL Meetup is a fantastic group. They tend to meet in pubs (Highly recommended on my …

[Read more]
Connector/Python 2.1

Connector/Python 2.1 (2.1.8 GA, published on Friday, 31 Aug 2018)

Connector/J 5.1

Connector/J 5.1 (5.1.47 GA, published on Friday, 17 Aug 2018)

Connector/NET 6.10

Connector/NET 6.10 (6.10.8 GA, published on Tuesday, 14 Aug 2018)

Output MySQL in JSON Format

I was recently asked if there is anyway to select non-JSON data from a MySQL database and output that data in JSON format. There are two very easy ways to to this.

JSON Array

If you need a JSON array, it is very easy to use the JSON_ARRAY() function. Simply select the columns you want as the argument to JSON_ARRAY()


SQL> select
json_array(continent,Population, Code)
from country
limit 5;
+----------------------------------------+
| json_array(continent,Population, Code) |
+----------------------------------------+
| ["North America", 103000, "ABW"] |
| ["Asia", 22720000, "AFG"] |
| ["Africa", 12878000, "AGO"] |
| ["North America", 8000, "AIA"] |
| ["Europe", 3401200, "ALB"] |
+----------------------------------------+
5 rows in set (0.0006 sec)

JSON_OBJECT

[Read more]
Connector/ODBC 5.3

Connector/ODBC 5.3 (5.3.11 GA, published on Monday, 30 Jul 2018)

MySQL Installer 5.7

MySQL Installer 5.7 (5.7.23 GA, published on Friday, 27 Jul 2018)

MySQL Community Server 5.6

MySQL Community Server 5.6 (5.6.41 GA, published on Friday, 27 Jul 2018)

Showing entries 1 to 10 of 770
10 Older Entries »