Python and SQLs: How I Create Universal SQL CLI Client using PEP 249 standards – PyCon Taiwan 2019
Day 3, R2 10:50–11:20
The SQL client is ubiquitous and impossible for developers not to have one in their toolbag. However potentially there is a unforeseen situation that the developers are forbid to use SQL client to access the cloud/on-premise SQL DB. This proposal primarily addresses the issue of such scenario and provides a solution based on the hacker's mindset. In this proposal, the author will show how he tackles this pain point in his workplace, by creating a universal SQL client CLI that allows him to connect to the SQL DB in his DB cluster, hence extends this project to other SQL DB using the API standardization in PEP 249. Apart from integrating all the SQL connectors, the author also implemented standardize hotkey for all the SQL DB, by studying the internal core of the SQL standards, and retrieving SQL metadata using pure SQL queries through the hotkeys.
Slides not uploaded by the speaker.
Speaker: Ing Wei Tang
Ing Wei is the chair for PyCon MY 2019, the co-chair of PyCon MY 2018, and vice president of MyPOP. He has spoken in various PyCons, particularly in PyCon APAC 2018, as well as involving in PyCon communities actively in Malaysia.
He uses python a lot in his daily work, especially coding the automation process and flow. During his past time, he likes to experience and perform hacking different things on operating system level.
Apart from programming language, he can also speak 5 different types of languages concurrently in one sentence. Please ask for demo if time permits.
Смотрите видео Python and SQLs: How I Create Universal SQL CLI Client using PEP 249 standards – PyCon Taiwan 2019 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь PyCon Taiwan 01 Ноябрь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 261 раз и оно понравилось 6 людям.