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: X DevAPI
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.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 »
Slides and Workbooks From Oracle OpenWorld & CodeOne
First of all, thanks to everyone who attended my sessions at the recent Oracle OpenWorld and Code One in San Francisco. It was a great privilege to be allowed to make a number of presentations. All of the workbooks and …
Slides and Workbooks From Oracle OpenWorld & CodeOne Read more »
NoSQL/X DevAPI Tutorial with MySQL Connector/Python 8.0
The MySQL Document Store became general available (GA) with MySQL 8. One of the nice features of the MySQL Document Store is the X DevAPI that allows you to query the data from a multitude of programming languages using the …
NoSQL/X DevAPI Tutorial with MySQL Connector/Python 8.0 Read more »