LBRY Block Explorer

LBRY Claims • python-and-sqls-how-i-create-universal

ad130f38e323caac707885e5272cc68c0da72ecb

Published By
Created On
5 Nov 2021 14:40:17 UTC
Transaction ID
Cost
Safe for Work
Free
Yes
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.
...
https://www.youtube.com/watch?v=3tP3UHfv9rs
Author
Content Type
Unspecified
video/mp4
Language
English
Open in LBRY

More from the publisher

Controlling
VIDEO
CODE
Controlling
VIDEO
[PYCO
Controlling
VIDEO
FROM
Controlling
VIDEO
#PYCA
VIDEO
DRAW
Controlling
VIDEO
(PYTH
Controlling
VIDEO
用PY
Controlling
VIDEO
PYTHO
Controlling
VIDEO