The MySQL X DevApi: Working with NULL Values
There was an excellent question from Francis on my MySQL X DevAPI tutorial on how to work with NULL values: Is it possible to store an attribute with the null value, and how to find it (xxx is null ? …
Category: Python
Connector/Python C Extension Prepared Statement Support
MySQL Connector/Python 8 made the C Extension the default for the platform/Python version combinations supporting it. One thing that was missing from the C Extension implementation (unless you used the _mysql_connector module) was support for prepared statements. That has been …
Connector/Python C Extension Prepared Statement Support Read more »
Connector/Python Connection Attributes
MySQL Server has since version 5.6 supported connection attributes for the clients. This has allowed a client to provide information such as which program or connector the client is, the client version, the license, etc. The database administrator can use …
MySQL Shell 8.0.16: User Defined Reports
In my blog yesterday, I wrote about the new reporting framework in MySQL Shell. It is part of the 8.0.16 release. I also noted that it includes the possibility to create your own custom reports and use those with the …
Using SQLAlchemy with MySQL 8
I few months ago, I wrote about using the Django framework with MySQL 8. There are also other Python frameworks that are worth considering. In this blog, I will look at using SQLAlchemy with MySQL 8. In order for you …
MySQL Connector/Python 8.0.14+: Changed Expression Handling in mysqlx
The X DevAPI allows you to work with JSON documents and SQL tables at the same time. Furthermore, the CRUD style API is more intuitive than SQL statements for some programmers. Either way, the X DevAPI allows you to mix …
MySQL Connector/Python 8.0.14+: Changed Expression Handling in mysqlx Read more »
MySQL Connector/Python 8.0.15: allow_local_infile Disabled by Default
MySQL Server has a feature where you can insert data into a table from a file with the data delimited by commas, tabs, or another delimiter. This is particularly useful when you need to bulk import data, for example when …
MySQL Connector/Python 8.0.15: allow_local_infile Disabled by Default Read more »
Automatic Decryption of MySQL Binary Logs Using Python
One of the new features in MySQL 8.0.14 is support for encrypting the binary logs. While encryption makes the data more secure (provided the key is secret of course), it can make life a bit more difficult in terms of …
Automatic Decryption of MySQL Binary Logs Using Python Read more »
MySQL Connector/Python 8.0.14 X DevAPI: Default Schema
The MySQL X DevAPI is the new API that provides a uniform API across the supported programming languages. It has from the beginning supported that you can specify a default schema, when you connect. Originally it was not used for …
MySQL Connector/Python 8.0.14 X DevAPI: Default Schema Read more »
MySQL 8: Drop Several Stored Events, Procedures, or Functions
Maybe the biggest new feature in MySQL 8 is the new transaction data dictionary that improves the consistency of schema objects among other things. To further protect the data in the data dictionary, the data dictionary tables are hidden and …
MySQL 8: Drop Several Stored Events, Procedures, or Functions Read more »