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

MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers, 9781484236932 (1484236939), Apress, 2018

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.

Comments

Amazing Books

Quicken 2004 for Dummies

John Wiley & Sons, 2003

Computerize your checkbook, track your stocks, bank online, and much more. When money talks, you can tell it what to say. Quicken 2004 and this handy guidebook will help you manage your bills, maximize investments, minimize taxes, multiply savings, and maintain detailed financial records that will delight your tax preparer—especially if...

WebGL: Up and Running

O'Reilly, 2012

In early 1994, Tim Berners-Lee put out an open call for a virtual reality specification for the Web; Mark Pesce and I answered. Only being able to afford one plane ticket, we sent Mark to Geneva to present our Labyrinth prototype at the first-ever World Wide Web Developers’ Conference. With typical bombast,...

Agent Communication II: International Workshops on Agent Communication, AC 2005 and AC 2006, Utrecht, Netherlands, July 25, 2005, and Hakodate, Japan

Springer, 2007

This book constitutes the thoroughly refereed post-proceedings of the two International Workshops on Agent Communication, AC 2005 and AC 2006, held in Utrecht, Netherlands in July 2005, and in Hakodate, Japan in May 2006 as associated events of AAMAS 2005/2006, the main international conference on autonomous agents and multi-agent systems.

The...

Indian Medicinal Plants: An Illustrated Dictionary

Springer, 2007

In 2004, Springer-Verlag Heidelberg published C.P.Khares "Encyclopedia of Indian Medicinal Plants" which contained 400 monographs comprising classical as well as contemporary research findings.

"Indian Medicinal Plants. An Illustrated Dictionary" is the second major one-volume reference work by C.P.Khare which has been...

Beginning ASP.NET MVC 4

Apress, 2013

By now you’ll have heard of ASP.NET MVC. This exciting new approach to developing ASP.NET web applications has taken the development world by storm over the last few years. Now a mature technology suitable for mainstream use, its adoption has exploded in recent times.

Until recently, ASP.NET MVC was regarded as an advanced...

WordPress For Dummies (For Dummies (Computer/Tech))

For Dummies, 2017

The bestselling guide to WordPress—fully updated

Updated to capture all the changes expected to come with the latest release of WordPress, the brand-new edition of this bestselling guide gives you an all-access pass to using this powerful publishing platform to get your very own blog or website up and running—in...