© Jesper Wisborg Krogh 2018
Jesper Wisborg KroghMySQL Connector/Python Revealedhttps://doi.org/10.1007/978-1-4842-3694-9_8

8. SQL Tables

Jesper Wisborg Krogh1 
(1)
Hornsby, New South Wales, Australia
 

Thus far, the main focus of the X DevAPI has been on using it with the MySQL Document Store. However, as explained in Chapter 6, it also supports “good old” SQL tables. In fact, there are two interfaces to work with SQL tables. The create-read-update-delete (CRUD) actions that were the focus of Chapter 7 also exist for SQL tables and provide a NoSQL API. Also, the X DevAPI can be used to execute arbitrary SQL statements.

This chapter will first give an overview of the workflow when using SQL tables and then go through how the X DevAPI can use SQL tables ...

Get MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.