MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers

Book Description

Move data back and forth between database and application. The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs communicate with the MySQL database.

This book takes you from the initial installation of the connector through basic query execution, then through more advanced topics, error handing, and troubleshooting. The book covers both the traditional API as well as the new X DevAPI. The X DevAPI is part of MySQL 8.0 and is an API that can be used with connectors for several programming languages and is used from the command-line interface known as MySQL Shell. You will learn to use the connector by working through code examples and following a discussion of how the API calls work.

By the end of the book, you will be able to use MySQL as the back-end storage for your Python programs, and you’ll even have the option of choosing between SQL and NoSQL interfaces.

What You’ll Learn

• Install MySQL Connector/Python
• Connect to MySQL and configure database access
• Execute SQL and NoSQL queries from your Python program
• Trap errors and troubleshoot problems
• Store data from different languages using MySQL’s character set support
• Work in the X DevAPI that underlies all of MySQL’s language connectors

Who This Book Is For

Developers familiar with Python who are looking at using MySQL as the back-end database. No prior knowledge of Connector/Python is assumed, but readers should be familiar with databases and the Python programming language.

Table of Contents

Part I: Getting Ready
Chapter 1: Introduction and Installation

Part II: The Legacy APIs
Chapter 2: Connecting to MySQL
Chapter 3: Basic Query Execution
Chapter 4: Advanced Query Execution
Chapter 5: Connection Pooling and Failover

Part III: The X DevAPI
Chapter 6: The X DevAPI
Chapter 7: The MySQL Document Store
Chapter 8: SQL Tables

Part IV: Error Handling and Troubleshooting
Chapter 9: Error Handling
Chapter 10: Troubleshooting

中文：

书名：MySQL连接器/Python透露：使用MySQL的SQL和NoSQL数据存储适用于Python程序员

在数据库和应用程序之间来回移动数据。本书中的必备知识帮助程序员学习如何使用官方驱动程序MySQL连接器/Python，通过该驱动程序，Python程序与MySQL数据库进行通信。

本书从连接器的初始安装到基本的查询执行，再到更高级的主题、错误处理和故障排除。这本书既涵盖了传统的API，也涵盖了新的X DevAPI。X DevAPI是MySQL 8.0的一部分，是一种可与多种编程语言的连接器一起使用的API，可从称为MySQL Shell的命令行界面使用。通过完成代码示例并讨论API调用的工作方式，您将学习如何使用连接器。

到本书结束时，您将能够使用MySQL作为您的Python程序的后端存储，您甚至可以在SQL和NoSQL接口之间进行选择。

你会学到什么？

• Install MySQL Connector/Python
• 连接到MySQL并配置数据库访问
• 从您的Python程序执行SQL和NoSQL查询
• 捕获错误并排除故障
• 使用MySQL的字符集支持存储不同语言的数据
• 使用作为MySQL所有语言连接器基础的X DevAPI

这本书是为谁写的

正在考虑使用MySQL作为后端数据库的熟悉Python的开发人员。本文假定您不了解Connector/Python，但读者应该熟悉数据库和Python编程语言。

目录表

第一部分：做好准备
第1章：介绍和安装

第二部分：传统API
Chapter 2: Connecting to MySQL
Chapter 3: Basic Query Execution
第4章：高级查询执行
第5章：连接池和故障转移

第三部分：X DevAPI
第6章：X DevAPI
第7章：MySQL文档存储
第8章：SQL表

第四部分：错误处理和故障排除
第9章：错误处理
Chapter 10: Troubleshooting