Cargando…
MySQL Connector/Python revealed : SQL and NoSQL data storage using MySQL for Python programmers /
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 conne...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[United States] :
Apress,
2018.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_on1046990448 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu|||unuuu | ||
| 008 | 180802s2018 xxu o 001 0 eng d | ||
| 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 |d AUD |d OCLCQ |d OCLCO | ||
| 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.) | ||
| 020 | |z 9781484236932 | ||
| 020 | |z 1484236939 | ||
| 024 | 7 | |a 10.1007/978-1-4842-3694-9 |2 doi | |
| 029 | 1 | |a AU@ |b 000063892973 | |
| 029 | 1 | |a AU@ |b 000067499786 | |
| 029 | 1 | |a CHNEW |b 001073691 | |
| 029 | 1 | |a CHVBK |b 579464938 | |
| 029 | 1 | |a UKMGB |b 019140225 | |
| 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 | ||
| 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 |
| 049 | |a UAMI | ||
| 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. | ||
| 588 | 0 | |a Online resource; title from PDF title page (Ebsco, viewed August 7, 2018). | |
| 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. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource) |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 fast |
| 650 | 0 | |a Python (Computer program language) | |
| 650 | 6 | |a Python (Langage de programmation) | |
| 650 | 7 | |a Programming & scripting languages: general. |2 bicssc | |
| 650 | 7 | |a Computer programming |x software development. |2 bicssc | |
| 650 | 7 | |a Databases. |2 bicssc | |
| 650 | 7 | |a COMPUTERS |x Databases |x General. |2 bisacsh | |
| 650 | 7 | |a Python (Computer program language) |2 fast | |
| 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://learning.oreilly.com/library/view/~/9781484236949/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 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 IZTAP | ||