MySQL Connector/Python revealed : SQL and NoSQL data storage using MySQL for Python programmers
Description
Loading Description...
More Details
Format
Language
English
ISBN
9781484236949, 1484236947
UPC
10.1007/978-1-4842-3694-9
Notes
General Note
Includes index.
Description
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.
Local note
O'Reilly,O'Reilly Online Learning: Academic/Public Library Edition
Also in this Series
Checking series information...
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Krogh, J. W. (2018). MySQL Connector/Python revealed: SQL and NoSQL data storage using MySQL for Python programmers . Apress.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Krogh, Jesper Wisborg. 2018. MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers. Apress.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Krogh, Jesper Wisborg. MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers Apress, 2018.
MLA Citation, 9th Edition (style guide)Krogh, Jesper Wisborg. MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers Apress, 2018.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
87fb7f01-9fb1-720c-85d2-3b641ab2974f-eng
Grouping Information
| Grouped Work ID | 87fb7f01-9fb1-720c-85d2-3b641ab2974f-eng |
|---|---|
| Full title | mysql connector python revealed sql and nosql data storage using mysql for python programmers |
| Author | krogh jesper wisborg |
| Grouping Category | book |
| Last Update | 2024-06-04 09:42:47AM |
| Last Indexed | 2024-06-26 02:25:55AM |
Book Cover Information
| Image Source | contentCafe |
|---|---|
| First Loaded | Aug 16, 2023 |
| Last Used | Jan 5, 2024 |
Marc Record
| First Detected | Mar 21, 2023 11:48:16 AM |
|---|---|
| Last File Modification Time | Mar 21, 2023 11:48:16 AM |
| Suppressed | Record had no items |
MARC Record
| LEADER | 06928cam a2200661 i 4500 | ||
|---|---|---|---|
| 001 | on1046990448 | ||
| 003 | OCoLC | ||
| 005 | 20230321114626.0 | ||
| 006 | m o d | ||
| 007 | cr cnu|||unuuu | ||
| 008 | 180802s2018 xxu o 001 0 eng d | ||
| 015 | |a GBB8M4688|2 bnb | ||
| 016 | 7 | |a 019140225|2 Uk | |
| 019 | |a 1047656979|a 1050710409|a 1052565727|a 1081294357|a 1086468846 | ||
| 020 | |a 9781484236949|q (electronic bk.) | ||
| 020 | |a 1484236947|q (electronic bk.) | ||
| 024 | 7 | |a 10.1007/978-1-4842-3694-9|2 doi | |
| 035 | |a (OCoLC)1046990448|z (OCoLC)1047656979|z (OCoLC)1050710409|z (OCoLC)1052565727|z (OCoLC)1081294357|z (OCoLC)1086468846 | ||
| 037 | |a CL0500000990|b Safari Books Online | ||
| 040 | |a N$T|b eng|e rda|e pn|c N$T|d N$T|d GW5XE|d YDX|d EBLCP|d UAB|d OCLCF|d UPM|d VT2|d UMI|d STF|d U3W|d CEF|d G3B|d LVT|d OCLCQ|d OCLCO|d UKMGB|d CAUOI|d SNK|d YOU|d K6U|d MERER|d OCLCQ|d AU@|d UKAHL|d OCLCQ|d OCLCO|d LEAUB|d OCLCQ|d BRF|d OCLCQ|d OCLCO|d COM|d OCLCQ | ||
| 049 | |a MAIN | ||
| 050 | 4 | |a QA76.9.D32 | |
| 072 | 7 | |a COM|x 021000|2 bisacsh | |
| 072 | 7 | |a UN|2 bicssc | |
| 072 | 7 | |a UMT|2 bicssc | |
| 072 | 7 | |a UN|2 thema | |
| 072 | 7 | |a UMT|2 thema | |
| 082 | 0 | 4 | |a 005.74|2 23 |
| 100 | 1 | |a Krogh, Jesper Wisborg,|e author. | |
| 245 | 1 | 0 | |a MySQL Connector/Python revealed :|b SQL and NoSQL data storage using MySQL for Python programmers /|c Jesper Wisborg Krogh. |
| 264 | 1 | |a [United States] :|b Apress,|c 2018. | |
| 264 | 2 | |a New York, NY :|b Distributed to the Book trade worldwide by Springer | |
| 264 | 4 | |c ©2018 | |
| 300 | |a 1 online resource | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 347 | |a text file | ||
| 347 | |b PDF | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 520 | |a 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. | ||
| 588 | 0 | |a Online resource; title from PDF title page (Ebsco, viewed August 7, 2018). | |
| 590 | |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource)|9 21171 |
| 630 | 0 | 7 | |a MySQL (Electronic resource)|2 fast|0 (OCoLC)fst01395715|9 21171 |
| 650 | 0 | |a Python (Computer program language)|9 71333 | |
| 776 | 0 | 8 | |i Print version:|a Krogh, Jesper Wisborg.|t MySQL Connector/Python revealed.|d [United States] : Apress, 2018|z 1484236939|z 9781484236932|w (OCoLC)1030915033 |
| 856 | 4 | 0 | |u https://library.access.arlingtonva.us/login?url=https://learning.oreilly.com/library/view/~/9781484236949/?ar|x O'Reilly|z eBook |
| 938 | |a Askews and Holts Library Services|b ASKH|n AH35659982 | ||
| 938 | |a EBSCOhost|b EBSC|n 1861221 | ||
| 938 | |a YBP Library Services|b YANK|n 15620654 | ||
| 994 | |a 92|b VIA | ||
| 999 | |c 286754|d 286754 | ||