The MySQL Workbench tool is great for development and administration tasks. Also it's available on Windows, Linux and Mac OS X which, according to information from third party sources, is more than you can say for most of the other equivalent tools. And Workbench is free. Having said that, most of the provided functionalities are intuitive and of daily use for developer and DBA staff alike.
This is a response to the JSON document fast lookup with MySQL 5.7
article by Frederic Descamp.
It is very easy to also use MySQL Workbench and the new GeoJSON support to actually show the
features.
My query:
SELECT ST_GeomFromGeoJSON(feature->"$.geometry",2) AS
feature
FROM test_features WHERE street='BEACH' ;
The result:
The MySQL developer tools team announces 6.3.6 as our GA
release for MySQL Workbench 6.3.
For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/list.php?152
Download MySQL Workbench 6.3.6 GA now, for Windows, Mac OS X
10.9+,
Oracle Linux 6 and 7, Fedora 22 and Fedora 23, Ubuntu 14.04
and
Ubuntu 15.10 or sources, from:
http://dev.mysql.com/downloads/tools/workbench/
Enjoy!
The MySQL developer tools team announces 6.3.5 as our GA
release for MySQL Workbench 6.3.
For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/list.php?152
Download MySQL Workbench 6.3.5 GA now, for Windows, Mac OS X
10.7+,
Oracle Linux 6 and 7, Fedora 21 and Fedora 22, Ubuntu 14.04
and
Ubuntu 15.04 or sources, from:
http://dev.mysql.com/downloads/tools/workbench/
Enjoy!
The MySQL developer tools team announces 6.3.4 as our GA
release for MySQL Workbench 6.3.
For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151
Download MySQL Workbench 6.3.4 GA now, for Windows, Mac OS X
10.7+,
Oracle Linux 6 and 7, Fedora 21 and Fedora 22, Ubuntu 14.04,
Ubuntu
14.10 and Ubuntu 15.04 or sources, from:
http://dev.mysql.com/downloads/tools/workbench/
Enjoy!
Changes in MySQL Workbench 6.3.4 (2015-06-15)
…
The MySQL developer tools team is pleased to announce 6.3.3 as our GA release for the MySQL Workbench 6.3
For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html
For detailed information about the new features, see What’s
New in MySQL Workbench 6.3
http://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151
Download MySQL Workbench 6.3.3 GA now, for Windows, Mac OS X
10.7+,
Oracle Linux 6 and 7, Fedora 20 and Fedora 21, Ubuntu 14.04 and
Ubuntu
14.10 …
The MySQL developer tools team is pleased to announce 6.3.2 RC - the first release candidate for MySQL Workbench 6.3
For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html
For detailed information about the new features, see What’s
New in MySQL Workbench 6.3
http://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151
Download MySQL Workbench 6.3.2 RC now, for Windows, Mac OS X
10.7+,
Oracle Linux 6 and 7, Fedora 20 and Fedora 21, Ubuntu 14.04 and …
The MySQL developer tools team announces 6.2.2 RC – the final release candidate for MySQL Workbench 6.2.
MySQL Workbench 6.2 is the upcoming major update for the official
MySQL
graphical development tool .
MySQL Workbench 6.2 focuses on support for innovations released
in MySQL 5.6 and MySQL 5.7
DMR (Development Release) as well as MySQL Fabric
1.5, with features such as:
- A new spatial data viewer, allowing graphical views of result
sets containing GEOMETRY data and
taking advantage of the new GIS capabilities in MySQL 5.7. - Support for new MySQL 5.7.4 SQL syntax and configuration options.
- Metadata Locks View shows the locks connections are blocked or waiting on.
- MySQL Fabric cluster connectivity – Browsing, view status,
and connect to any MySQL instance in a
Fabric Cluster. …
The MySQL Workbench team is announcing availability of the
first beta release of its upcoming major product update,
MySQL Workbench 6.2.
MySQL Workbench 6.2 focuses on support for innovations released
in MySQL 5.6 and MySQL 5.7 DMR (Development Release) as well as
MySQL Fabric 1.5, with features such as:
- A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and taking advantage of the new GIS capabilities in MySQL 5.7.
- Support for new MySQL 5.7.4 SQL syntax and configuration options.
- Metadata Locks View shows the locks connections are blocked or waiting on.
- MySQL Fabric cluster connectivity - Browsing, view status, and connect to any MySQL instance in a Fabric Cluster.
- MS Access migration Wizard - easily move to MySQL Databases.
Other significant usability improvements were made, …
The MySQL Workbench team announces availability of version 6.1.7 of its flagship product.
MySQL Workbench 6.1.7 is a periodic maintenance release including
17 bug fixes. Additionally, the supported Linux distribution list
has been refreshed. Users of the product are recommended to
upgrade to this version.
MySQL Workbench 6.1
With over 30 new features, this version has many significant
enhancements focusing on real-time performance assessment and
analysis from the SQL statement level to server internals and
file IO. You can see this from additions to the SQL Editor as
well as new dashboard visualization and reporting that take
advantage of MySQL Server 5.6 and 5.7 Performance Schema, and
enhancements to the MySQL Explain Plans.
Additionally Workbench 6.1 is leveraging work from various
teammates in MySQL Engineering by introducing a schema called
"SYS" that provides simplified views …