~/talk

Python with NoSQL + SQL = MySQL 8.0

on YouTube 56m
Talkat PyCon APAC 2019 · on Sunday, 2019-02-24· [python, databases]

speaker

name:Ronen Baran
links:none on file

resources

video:https://youtu.be/yaqevCd8rU8
slides:none on file

summary

Python code uses MySQL 8.0’s X protocol to treat tables as collections of JSON data type documents, with generated id columns and CRUD operations; SQL queries run analytics like window functions (running sum, rank, partition by) without ETL. Live demo runs on a three‑node InnoDB cluster, shows seamless failover while ~240 documents persist, and builds/updates JSON fields and indexes from Python; performance isn’t the fastest, but the single‑engine approach reduces cross‑database complexity.

AI-written summary · about

chapters (6)

  1. 0:00Start
  2. 6:41Problem of no Sql Databases
  3. 12:36Create the Schema
  4. 14:36Finding a Collection
  5. 34:30Window Functions
  6. 49:28Performance

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.