عنوان

MySQL Connector/Python revealed :

(Number (ISBN

1484236947

(Number (ISBN

9781484236949

Erroneous ISBN

1484236939

Erroneous ISBN

9781484236932

Title Proper

MySQL Connector/Python revealed :

General Material Designation

[Book]

Other Title Information

SQL and NoSQL data storage using MySQL for Python programmers /

First Statement of Responsibility

Jesper Wisborg Krogh.

Place of Publication, Distribution, etc.

[United States] :

Place of Publication, Distribution, etc.

New York, NY :

Name of Publisher, Distributor, etc.

Apress,

Name of Publisher, Distributor, etc.

Distributed to the Book trade worldwide by Springer

Date of Publication, Distribution, etc.

2018.

Date of Publication, Distribution, etc.

©2018

Specific Material Designation and Extent of Item

1 online resource

Text of Note

Includes index.

Text of Note

Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Getting Ready; Chapter 1: Introduction and Installation; Introduction; Versions; Community and Enterprise Editions; APIs; Downloading; Installation; pip -- All Platforms; Microsoft Windows -- MySQL Installer; Linux -- MySQL Yum Repository; Verifying the Installation; MySQL Server; Installation; Configuration; Creating the Application User; Installing the world Sample Database; Code Examples; Summary; Part II: The Legacy APIs; Chapter 2: Connecting to MySQL.

Text of Note

Creating the Connection from PythonSyntax; Common Connection Options; Connection Examples; Reconfiguration and Reconnect; Connection Best Practices; Configuration Files; Alternatives to Hardcoding the Configuration; Using MySQL Configuration Files; General Configuration; Connection; Character Set; Query Behavior; Warnings; Summary; Chapter 3: Basic Query Execution; Simple Execution; Executing the Query: cmd_query(); Retrieving Rows -- get_rows(); Automatic Conversion into Native Python Types; Retrieving Rows -- get_rows() With Limit; Retrieving Rows -- get_row(); Consuming Results; Cursors.

Text of Note

InstantiationMySQLCursor -- Execution Flow; MySQLCursor -- Query Execution; MySQLCursor -- Properties; column_names; description; lastrowid; rowcount; statement; with_rows; The Dictionary and Named Tuple Cursor Subclasses; Handling User Input; Validating the Input; Query Parameterization; Prepared Statements; Summary; Chapter 4: Advanced Query Execution; Multi-Query Execution; Multiple Queries with Support for Results; Connection -- cmd_query_iter(); Cursor -- execute(); Multiple Queries Based on a Template; Extended Inserts; Buffered Results; Stored Procedures; Loading Data Using a CSV File.

Text of Note

Loading a Server-Side FileLoading an Application-Side File; Load Data Example; Connection Properties; Transactions; Default Database; Time Zones; Other Connection Utility Methods; Connection Methods; cmd_change_user(); cmd_reset_connection() and reset_session(); is_connected(); ping(); Server Information Methods; Column Information; Field Types; MySQL Column Flags; The C Extension; The mysql.connector.connect() Function; The _mysql_connector Module; Summary; Chapter 5: Connection Pooling and Failover; Connection Pooling -- Background; The pooling. MySQLConnectionPool Class.

Text of Note

The pooling. PooledMySQLConnection ClassConfiguration Options; Using Connection Pools; Creating a Connection Pool; Using Connection Pool Connections; Using the mysql.connector.connect() Function; Using the get_connection() Method; Executing Queries; Reconfiguring the Connections; Connection Failover; Failover Configuration; Coding for Failover; Failover Example; Summary; Part III: The X DevAPI; Chapter 6: The X DevAPI; The MySQL X Plugin; The mysqlx Module; Creating a Session; Passing Individual Options; Passing an URI; Connection Examples; Working with the Session; Transactions.

0

8

8

8

8

Text of Note

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.

Source for Acquisition/Subscription Address

Safari Books Online

Stock Number

CL0500000990

Title

MySQL Connector/Python revealed.

International Standard Book Number

9781484236932

MySQL (Electronic resource)

MySQL (Electronic resource)

Python (Computer program language)

Computer programming-- software development.

COMPUTERS-- Databases-- General.

Databases.

Programming & scripting languages: general.

Python (Computer program language)

COM-- 021000

UMT

UMT

UN

UN

Number

Edition

Class number

Krogh, Jesper Wisborg

Date of Transaction

20200823032212.0

Cataloguing Rules (Descriptive Conventions))

pn

Electronic name

[Book]

Y