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

Jesper Wisborg Krogh

  • 出版商: Apress
  • 出版日期: 2018-08-01
  • 售價: $2,310
  • 貴賓價: 9.5$2,195
  • 語言: 英文
  • 頁數: 540
  • 裝訂: Paperback
  • ISBN: 1484236939
  • ISBN-13: 9781484236932
  • 相關分類: MySQLNoSQLPython程式語言SQL
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

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. 

商品描述(中文翻譯)

在這本書中,你將學習如何在資料庫和應用程式之間來回移動資料。這本書中的必備知識將幫助程式設計師學習如何使用官方驅動程式MySQL Connector/Python,這是Python程式與MySQL資料庫進行通訊的方式。

本書將從連接器的初始安裝開始,介紹基本的查詢執行,然後深入介紹更高級的主題,如錯誤處理和故障排除。本書涵蓋了傳統的API和新的X DevAPI。X DevAPI是MySQL 8.0的一部分,它是一個可以與多種程式語言的連接器一起使用的API,並且可以從稱為MySQL Shell的命令行介面中使用。通過編寫代碼示例並討論API調用的工作原理,你將學習如何使用連接器。

通過閱讀本書,你將能夠將MySQL作為Python程式的後端儲存,並且還可以選擇使用SQL和NoSQL介面。

本書的學習內容包括:
- 安裝MySQL Connector/Python
- 連接到MySQL並配置資料庫訪問權限
- 從Python程式執行SQL和NoSQL查詢
- 處理錯誤並解決問題
- 使用MySQL的字符集支援來存儲來自不同語言的資料
- 使用底層的X DevAPI來工作,該API是MySQL所有語言連接器的基礎

本書適合已熟悉Python並希望使用MySQL作為後端資料庫的開發人員。不需要先備的Connector/Python知識,但讀者應該熟悉資料庫和Python程式語言。