Showing entries 1 to 10 of 742
10 Older Entries »
Connector/Python 2.1

Connector/Python 2.1 (2.1.7 GA, published on Friday, 18 Aug 2017)

Connector/Net 6.10

Connector/Net 6.10 (6.10.3 rc, published on Friday, 18 Aug 2017)

Northeast PHP

Next week Northeast PHP returns to Price Edward Island and Charltottetown. Last year this event moved from Cambridge to Canada and found a wonderful audience. This year the conference is back and bigger than ever. And the local government is extremely supportive and had provided the organizers with a grant to help this year.

I will be presenting on Basic PHP Database Programming and Getting JSON Data in and Out of MySQL. Tickets are still available and there is a student discount.


Percona Live Europe 2017 Sneak Peek Schedule Up Now! See Available Sessions!

We are excited to announce that the sneak peek schedule for the Percona Live Open Source Database Conference Europe 2017 is up! The Percona Live Open Source Database Conference Europe 2017 is September 25 – 27, at the Radisson Blu Royal Hotel.

The theme of Percona Live Europe 2017 is Championing Open Source Databases, with sessions on MySQL, MariaDB, MongoDB and other open source database technologies, including time series databases, PostgreSQL and RocksDB. This year’s conference will feature one day of tutorials and two days of keynote talks and breakout sessions …

[Read more]
Percona Toolkit 3.0.4 is Now Available

Percona announces the release of Percona Toolkit 3.0.4 on August 2, 2017.

Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.

You download Percona Toolkit packages from the web site or install from official repositories.

This release includes the following changes:

New Features

  • PT-90: Added collection of information …
[Read more]
MySQL 8 and Common Table Expressions – An Introduction

MySQL 8 will have Common Table Expressions also known as CTEs.  I have had people asking me when  MySQL would have CTEs for years and I am glad to report they are ready for testing.

What Does a CTE look like?

The keyword WITH is the big hint that the statement is a CTE.  For now think of a CTE as a collections of views or subqueries that you combine together for the desired results. After the WITH clause, one or more comma separated sub-clauses that are subqueries. And CTEs can reference other CTEs.  For a first example, let us combine the world_x example database’s city and country table to produce a list of all cities and their corresponding countries.

WITH
  cte1 as (select Name as CName, CountryCode as CCode from city),
  cte2 as (select Name as Name, Code from country)
SELECT cte1.CName, cte2.Name from …

[Read more]
MySQL Shell 1.0

MySQL Shell 1.0 (1.0.10 GA, published on Friday, 28 Jul 2017)

Connector/ODBC 5.3

Connector/ODBC 5.3 (5.3.9 GA, published on Monday, 24 Jul 2017)

Connector/C 6.1

Connector/C 6.1 (6.1.11 GA, published on Sunday, 23 Jul 2017)

MySQL Router 2.1

MySQL Router 2.1 (2.1.4 GA, published on Saturday, 22 Jul 2017)

Showing entries 1 to 10 of 742
10 Older Entries »