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: Connector/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 …
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 »
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 »
MySQL X DevAPI Connection Pool with Connector/Python
If you have an application that need to use multiple connections to the MySQL database for short periods of times, it can be a good to use a connection pool to avoid creating a new connection and going through the …
MySQL X DevAPI Connection Pool with Connector/Python Read more »
Using Django 2.1 with MySQL 8
A framework can be a great way to allow you to spend more time on the actual application or web site and less time on standard tasks. It can also greatly reduce the amount of custom code needed. Django is …