MySQL Server was originally released as an SQL database in 1995. SQL statements executed as shown in Chapters 2 and 3 are still by far the most common way to execute queries in MySQL, and the mysql.connector module uses the traditional protocol. There is, however, another way: the new X Protocol.
This chapter will start out with a brief introduction to the X Plugin (the back end) and the X DevAPI (the API used by the application) and the features in-between. The rest of the chapter will focus on the parts of the MySQL Connector/Python implementation ...