Introducing the MySQL 8 document store. ([2018])
- Record Type:
- Book
- Title:
- Introducing the MySQL 8 document store. ([2018])
- Main Title:
- Introducing the MySQL 8 document store
- Other Titles:
- Introducing the MySQL 8 document store
- Further Information:
- Note: Charles Bell.
- Authors:
- Bell, Charles
- Contents:
- Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Introducing MySQL 8-A New Beginning; Old Features New Again; JSON Data Type; MySQL Shell; X Plugin, X Protocol, and X DevAPI; InnoDB Improvements; New Features; Data Dictionary; Account Management; Removed Options, Variables, and Features; Paradigm Shifting Features; Group Replication; InnoDB Cluster; Summary; Chapter 2: Getting Started with MySQL; Getting to Know MySQL; How Do I Connect to MySQL?; How to Get and Install MySQL; Configuring and Managing Access to MySQL Configuration FilesCreating Users and Granting Access; Configuring the Document Store; A MySQL Primer; Creating Databases and Tables; Searching for Data; Creating Data; Updating Data; Deleting Data; Using Indexes; Views; Triggers; Simple Joins; Stored Routines; Summary; Chapter 3: JSON Documents; Concepts and Technologies: Jargon Explained; Origins: Key, Value Mechanisms; JSON; Application Programming Interface; NoSQL Interface; Document Store; Introducing JSON Documents; JSON Format Rules; Using JSON in MySQL; Path Expressions; JSON Functions; Creating JSON Data; Modifying JSON Data Searching JSON DataUtility Functions; Combining SQL and JSON - Indexing JSON Data; Summary; Chapter 4: The MySQL Shell; Getting Started; Features; Shell Commands; Options; Sessions and Modes; Session Objects; Modes Supported; Connections; Using a URI; Using Individual Options; Using Connections in Scripts; Using SSLIntro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Introducing MySQL 8-A New Beginning; Old Features New Again; JSON Data Type; MySQL Shell; X Plugin, X Protocol, and X DevAPI; InnoDB Improvements; New Features; Data Dictionary; Account Management; Removed Options, Variables, and Features; Paradigm Shifting Features; Group Replication; InnoDB Cluster; Summary; Chapter 2: Getting Started with MySQL; Getting to Know MySQL; How Do I Connect to MySQL?; How to Get and Install MySQL; Configuring and Managing Access to MySQL Configuration FilesCreating Users and Granting Access; Configuring the Document Store; A MySQL Primer; Creating Databases and Tables; Searching for Data; Creating Data; Updating Data; Deleting Data; Using Indexes; Views; Triggers; Simple Joins; Stored Routines; Summary; Chapter 3: JSON Documents; Concepts and Technologies: Jargon Explained; Origins: Key, Value Mechanisms; JSON; Application Programming Interface; NoSQL Interface; Document Store; Introducing JSON Documents; JSON Format Rules; Using JSON in MySQL; Path Expressions; JSON Functions; Creating JSON Data; Modifying JSON Data Searching JSON DataUtility Functions; Combining SQL and JSON - Indexing JSON Data; Summary; Chapter 4: The MySQL Shell; Getting Started; Features; Shell Commands; Options; Sessions and Modes; Session Objects; Modes Supported; Connections; Using a URI; Using Individual Options; Using Connections in Scripts; Using SSL Connections; Set Up and Install; Install the MySQL Shell; Setup the X Plugin; Enable the X Plugin Using the MySQL Shell; Enable the X Plugin Using the MySQL Client; Tutorial: MySQL Shell by Example; Installing the Sample Database; SQL; JavaScript; Python; Summary Chapter 5: X Developer APIOverview; Clients; Target Language Conformity; MySQL X Module; Classes and Methods; Session Class; Schema Methods; Transaction Methods; Connection Methods; Miscellaneous Methods; CRUD Operations; Schema Class; Collection Class; Table Class; Example Data Used in this Chapter; Working with Data Sets; Document Identifiers; Auto Increment; Accessing Data in Data Sets; Accessing Metadata in Results; Column Metadata; Expressions; Expression Strings; Boolean Expression Strings; Warnings and Errors; Warnings from the Server; Errors from the X DevAPI; Additional Features Parameter BindingMethod Chaining; CRUD Prepared Statements; Asynchronous Execution; For More Information; Summary; Chapter 6: X Plugin; Overview; Features; Secure Socket Layer (SSL) Connections; Changing the Default Port; Going Deeper-Journey into the Source Code; Options and Variables; How to View Values of Variables; How to Set Values of Variables; System Variables and Startup Options; Status Variables; Monitoring the X Plugin; Communication; Connections; CRUD Operations; Errors and Warnings; Sessions; SSL; Statements; Worker Threads; Summary; Chapter 7: X Protocol; Overview … (more)
- Publisher Details:
- New York, NY : Apress
- Publication Date:
- 2018
- Copyright Date:
- 2018
- Extent:
- 1 online resource (xxiii, 532 pages), illustrations
- Subjects:
- 005.75/85
Computer science
Databases
Database management
COMPUTERS / Programming Languages / SQL
Database management
Databases
Computers -- Programming -- General
Computer programming / software development
Computers -- Database Management -- General
Databases
Electronic books - Languages:
- English
- ISBNs:
- 9781484227251
1484227255 - Related ISBNs:
- 9781484227244
- Notes:
- Note: Online resource; title from PDF title page (EBSCO, viewed June 25, 2018).
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.353631
- Ingest File:
- 01_312.xml