Introducing the MySQL 8 document store. ([2018])

• Record Type: Book
• 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 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
• 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.