Python and the New MySQL Shell
summary
MySQL Shell runs three modes—SQL, JavaScript and Python—and connects over X Protocol on 33060 to treat MySQL as both relational and JSON document store; default connections use TLS AES‑256 and utf8mb4. Python mode imports libraries, runs scripts, and calls _sql for ad hoc queries; extensions and reports register in Python or JavaScript and can be persisted (example: plugin in a dozen lines). Built utilities include json import/export, fast table export, and a server upgrade checker; reports like watch sessions every 2s run live.
AI-written summary · about
chapters (8)
- 0:00MySQL Shell and Python intro
- 2:01New MySQL Shell features
- 3:45Python and JavaScript in Shell
- 6:12NoSQL JSON with X DevAPI
- 8:38Extending Shell with plugins
- 10:42Data management utilities
- 12:28Resources and community
- 13:52Q&A
related talks
28mJavaScript Mode and the MySQL Shell
27mMySQL Shell: the daily tool for devs and admins
56mPython with NoSQL + SQL = MySQL 8.0
30mSponsored talk" MySQL 8 loves JavaScript"
26mScaling MySQL with Python
26mMySQL Without the SQL -- Oh My!
40mPython & MariaDB: A Match?
49mNew Client Tool for Developers and DBAs