Connector/Python 2.1 (2.1.7 GA, published on Friday, 18 Aug 2017)
10 Older Entries »
Connector/Net 6.10 (6.10.3 rc, published on Friday, 18 Aug 2017)
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.
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 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.
This release includes the following changes:
- PT-90: Added collection of information …
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.
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 …
MySQL Shell 1.0 (1.0.10 GA, published on Friday, 28 Jul 2017)
Connector/ODBC 5.3 (5.3.9 GA, published on Monday, 24 Jul 2017)
Connector/C 6.1 (6.1.11 GA, published on Sunday, 23 Jul 2017)
MySQL Router 2.1 (2.1.4 GA, published on Saturday, 22 Jul 2017)
10 Older Entries »