HOME
SEARCH
BLOG
SCRIPTS
CONTACT
SEARCH
SEARCH
Disclaimer:
Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
×
BOOK INTRODUCING THE MYSQL 8 DOCUMENT STORE
DOWNLOAD
SUMMARY
Items Found:
171
Index
Summary
Document Store Tips and Tricks
Strategies for Migrating to a Document Store
Take Storage for Granted
Embed or Separate?
Formal Rules vs Heuristics
Normalization vs Denormalization
Migrating to Schemaless Documents
Considerations for Upgrading to MySQL 8
Reasons for Upgrading
Upgrade Practices
Types of Upgrades
Chapter 10: Planning for MySQL 8 and the Document Store
Upgrading from MySQL 57 and Earlier
Summary
Challenges
Executing the Code
Observations
Application Code
Templates
Version 3: Document Store
Database Code
Database Design
Executing the Code
Observations
Templates
Application Code
Database Code
Database Design
Version 2: Relational Database + JSON Fields (Hybrid)
Templates
Executing the Code
Observations
Application Code
Database Design
Database Code
Chapter 9: Library Application: Database Implementations
Version 1: Relational Database
Application Code
Summary
Form Classes
View Functions
Templates
User Interface Features
Preparing the Directory Structure
Library Application User Interface Design
Flask Review: Sample Application
Redirects
Additional Features
Error Handlers
Initialization and the Application Instance
HTML Files and Templates
Terminology
Flask Primer
Setup Your Environment
Library Application
Getting Started
Chapter 8: Library Application: User Interface
Document Store Example
Summary
Relational Data Example
Creating X Clients
Setup for the Examples
Protobuf Implementation
X Protocol Examples
X Protocol Walkthrough
X Protocol and Protocol Buffers
X Protocol: Under the Hood
Goals for the X Protocol
Overview
Summary
Chapter 7: X Protocol
SSL
Statements
Worker Threads
Sessions
Errors and Warnings
Connections
CRUD Operations
Status Variables
Monitoring the X Plugin
Communication
System Variables and Startup Options
How to View Values of Variables
How to Set Values of Variables
Options and Variables
Going Deeper—Journey into the Source Code
Overview
Features
Chapter 6: X Plugin
Summary
Asynchronous Execution
For More Information
CRUD Prepared Statements
Parameter Binding
Method Chaining
Warnings and Errors
Additional Features
Expressions
Working with Data Sets
Example Data Used in this Chapter
CRUD Operations
Session Class
Classes and Methods
Clients
Target Language Conformity
MySQL X Module
Overview
Chapter 5: X Developer API
Summary
SQL
Python
JavaScript
Installing the Sample Database
Tutorial: MySQL Shell by Example
Set Up and Install
Install the MySQL Shell
Setup the X Plugin
Connections
Options
Sessions and Modes
Shell Commands
Features
Getting Started
Chapter 4: The MySQL Shell
Summary
JSON Functions
Combining SQL and JSON - Indexing JSON Data
Using JSON in MySQL
Path Expressions
JSON Format Rules
Introducing JSON Documents
Document Store
NoSQL Interface
Application Programming Interface
JSON
Origins: Key,Value Mechanisms
Chapter 3: JSON Documents
Concepts and Technologies: Jargon Explained
Summary
Simple Joins
Stored Routines
Triggers
Using Indexes
Views
Deleting Data
Updating Data
Searching for Data
Creating Data
A MySQL Primer
Creating Databases and Tables
Configuring and Managing Access to MySQL
How Do I Connect to MySQL?
How to Get and Install MySQL
Getting to Know MySQL
Chapter 2: Getting Started with MySQL
Summary
Group Replication
InnoDB Cluster
Paradigm Shifting Features
Removed Options,Variables,and Features
Account Management
Data Dictionary
New Features
InnoDB Improvements
X Plugin,X Protocol,and X DevAPI
MySQL Shell
JSON Data Type
Old Features New Again
Chapter 1: Introducing MySQL 8—A New Beginning