MySQL Connector/Python Revealed

SQL and NoSQL Data Storage Using MySQL for Python Programmers



Bookstore > Books > MySQL Connector/Python Revealed

Price$24.27 - $32.59
Rating
AuthorJesper Wisborg Krogh
PublisherApress
Published2018
Pages515
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484236939
ISBN-139781484236932
EBook Hardcover Paperback

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.

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.



Similar Books


MySQL for Python

MySQL for Python

by Albert Lukaszewski

Python is a dynamic programming language, which is completely enterprise ready, owing largely to the variety of support modules that are available to extend its capabilities. In order to build productive and feature-rich Python applications, we need to use MySQL for Python, a module that provides database support to our applications. Alth...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2010

Professional Linux Programming

Professional Linux Programming

by Jon Masters, Richard Blum

As Linux continues to grow in popularity, there has never been more of a need to understand how to develop for this platform. Rather than focusing on a particular language or development technique, Professional Linux Programming looks at the different development environments within Linux - the kernel, the desktop, and the web - and then ...

Publisher:  Wrox  |  Release:  2007

SQL Antipatterns, Volume 1

SQL Antipatterns, Volume 1

by Bill Karwin

SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - -solutions that look right but become increasingly painful to work with as you u...

Price:  $47.95  |  Publisher:  The Pragmatic Programmers  |  Release:  2022

Learn More Python 3 the Hard Way

Learn More Python 3 the Hard Way

by Zed A. Shaw

Zed Shaw has perfected the world's best system for becoming a truly effective Python 3.x developer. Follow it and you will succeed - just like the tens of millions of programmers he's already taught. You bring the discipline, commitment, and persistence; the author supplies everything else.In Learn Python 3 the Hard Way, Zed Sha...

Price:  $22.33  |  Publisher:  Addison-Wesley  |  Release:  2017

Beginning Python

Beginning Python

by James Payne

As an open source, object-oriented programming language, Python is easy to understand, extendable, and user-friendly. This book covers every aspect of Python so that you can get started writing your own programs with Python today. Author James Payne begins with the most basic concepts of the Python language - placing a special focus on th...

Price:  $7.99  |  Publisher:  Wrox  |  Release:  2010

MySQL Stored Procedure Programming

MySQL Stored Procedure Programming

by Guy Harrison, Steven Feuerstein

MySQL Stored Procedure Programming covers a lot of ground. The book starts with a thorough introduction to stored procedures programming and functions, covering the fundamentals of data types, operators, and using SQL in stored procedures. You'll learn how to build and maintain stored programs -- covering transactions, stored functio...

Price:  $6.38  |  Publisher:  O'Reilly Media  |  Release:  2006

C and Python Applications

C and Python Applications

by Philip Joyce

Solve problems by embedding Python code in a C programs, SQL methods, Python sockets. This book uses rudimentary mathematics and basic programming to create practical Python applications for embedding. You'll start with an introduction to C and Python, assuming a fundamental understanding of what programming is. You will also review ...

Price:  $33.74  |  Publisher:  Apress  |  Release:  2021

DevOps in Python, 2nd Edition

DevOps in Python, 2nd Edition

by Moshe Zadka

Take advantage of Python to automate complex systems with readable code. This new edition will help you move from operations/system administration into easy-to-learn coding.You'll start by writing command-line scripts and automating simple DevOps-style tasks followed by creating reliable and fast unit tests designed to avoid incident...

Price:  $37.95  |  Publisher:  Apress  |  Release:  2022