marcin szałowicz - mysql workbench
TRANSCRIPT
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 121
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12
MySQL Workbench Walk throughMarcin SzałowiczSenior Software Developer, MySQL Developer Tools
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.3
Safe Harbor
The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.4
Program Agenda
MySQL Workbench 6.3
Advanced Workbench
Workbench can do more
MySQL 5.7 RC
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.5
MySQL Workbench Intro
Workbench 6.3 Open Source Windows, OS X, Linux C++, Python,
Objective-C, C# WinForms, Gtk+, Cocoa
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.6
MySQL Workbench Overview
MySQL Administration MySQL Development Database Modeling Migration
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.7
MySQL Workbench - Administration
Server Status Start/Stop Connection Dump/Import Logs Configuration Performance Reports
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.8
MySQL Workbench – SQL IDE
Browse Database View/Edit Data Run/Visualize Queries Create/Alter Objects
(online) Query Optimization
(Visual Explain etc)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.9
MySQL Workbench - Modeling
Visually model database schema
Reverse engineerexisting databases
Generate SQLcode from diagram
Synchronize
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.10
WorkbenchAdvancedSQL IDE
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.11
Import / Export Wizard
Ease of use CSV format Local or remote Auto create table
structure
SQLIDE
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.12
Schema Inspector
View all objects in a schema
Status info from server Access table
maintenance options Analyze
Optimize
Check
Checksum
SQLIDE
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.13
Form Editor
Edit data row by row Multi line text edit Visualize data
SQLIDE
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.14
Spatial Viewer
Visualize spatial data Merge several layers Export visible area Check coordinates
SQLIDE
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.15
Table Data Search
Easy search through schemas
Search through all column types
SQLIDE
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.16
WorkbenchCAN DOMORE
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.17
Workbench Can Do More
SSH Tunneling Python Scripting Shell Fabric
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.18
MySQL 5.7 RC
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.19
MySQL 5.7 RC
GIS GeoHASH, GeoJSON
InnoDB R-trees
JSON*
– Native JSNON datatype and binary storage format
– Server side JSON functions
Index support on virtual generated columns
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.20
MySQL Workbench 6.3
Informations:
Tutorials: http://mysqlworkbench.org
IRC: #[email protected]
Bug Reports/ Feature Requests: http://bugs.mysql.com
Download:
http://dev.mysql.com/downloads/workbench/
http://dev.mysql.com/downloads/repo/apt/
http://dev.mysql.com/downloads/repo/yum/
Lookup places
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 1221
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.22
Safe Harbor
The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 1223