When you write programs that uses a database backend, it is necessary to use a connector/API to submit the queries and retrieve the result. If you are writing Python programs that used MySQL, you can use MySQL Connector/Python – the connector developered by Oracle Corporation.
Now there is a new book dedicated to the usage of the connector: MySQL Connector/Python Revealed, which is published by Apress. It is available in a softcover edition as well as an eBook (PDF, ePub, Mobi).
The book is divided into four parts spanning from the installation to error handling and troubleshooting. The four parts are:
- Part I: Getting Ready
This part consists of a single chapter that helps you to get up and running. The chapter includes an introduction to MySQL Connector/Python and getting the connector and MySQL Server installed.
- Part II: The Legacy APIs
The legacy APIs include the connector module that implements PEP249 (the Python Database API). The discussion of the
mysql.connectormodule spans four chapters. In addition to query execution, the use of connection pools and the failover feature is covered. Finally, there is also a discussion about the C Extension.
- Part III – The X DevAPI
One of the big new features in MySQL 8 is the MySQL Document Store including the X DevAPI. It allows you to use MySQL through the NoSQL API as well as by executing SQL queries. The NoSQL API includes support both for working with MySQL as a document store where the data is stored in JSON documents and with SQL tables. Part III includes three chapters that are dedicated to the X DevAPI.
- Part IV – Error Handling and Troubleshooting
The final part of book goes through the two important topics of error handling and troubleshooting including several examples of how common errors and how to resolve them.
With the book comes 66 code examples that are available for download from Apress’ GitHub repository. See the book’s homepage for instructions.
MySQL Connector/Python is available from several sources including online bookshops. The following table shows some of the places, where you can buy the book. (The table if current as of 13 August 2018; changes to the available formats may happen in the future.)
|Apress||Yes||PDF and ePub (both DRM free)|
|Barnes & Nobles||Yes|