Skip to content
Decks extracted with Video2Any

"Some SQL tricks of an application DBA" — FOSDEM 2021

67 slides Video2Any pulled straight from the conference recording — no upload, all in the browser.

Haki Benita · FOSDEM 2021, PostgreSQL devroom · video.fosdem.org/2021/D.postgresql/postgresql_some_sql_tricks_of_an_application_dba.webm

"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 1
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 2
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 3
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 4
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 5
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 6
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 7
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 8
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 9
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 10
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 11
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 12
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 13
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 14
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 15
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 16
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 17
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 18
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 19
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 20
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 21
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 22
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 23
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 24
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 25
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 26
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 27
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 28
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 29
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 30
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 31
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 32
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 33
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 34
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 35
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 36
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 37
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 38
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 39
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 40
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 41
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 42
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 43
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 44
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 45
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 46
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 47
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 48
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 49
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 50
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 51
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 52
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 53
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 54
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 55
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 56
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 57
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 58
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 59
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 60
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 61
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 62
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 63
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 64
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 65
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 66
"Some SQL tricks of an application DBA" — FOSDEM 2021 — slide 67

Haki Benita spoke in the PostgreSQL devroom at FOSDEM 2021 on the SQL that application developers tend not to reach for — bulk loading, upserts, indexing choices — with a measured timing on almost every slide. Video2Any stepped through the 28-minute recording and kept 67 clean frames, one per slide change. Slides like these are the case where a picture of a slide is a real limit: the queries are the content, and the deck gives you them to read and retype rather than to copy. Every image below is real output, extracted in a browser tab with nothing uploaded.

Slides from FOSDEM, used under CC BY 2.0 BE. Extracted from the original recording (linked above) and credited to FOSDEM; not affiliated with or endorsed by them. Rights concern? request removal.

Private by design

Uploaded files are decoded, compared, and assembled inside your browser tab. They never touch our servers; close the tab and nothing is left behind.

FAQ

Are these the actual slides from the talk?
Yes. Video2Any read the published recording and kept one image per slide change. FOSDEM publishes its 2021 recordings under CC BY 2.0 BE, which permits reuse with credit; we credit FOSDEM and link to the original file above.
Can I copy the SQL out of these slides?
Not by selecting them. Each slide here is the frame as it was on screen, so a command is part of the picture — you can read it and type it out, but not copy it. The video of the talk is linked above if you want to pause on a line.
Can I do this with a talk I have?
Yes, and it is free for your own files. Drop the recording in and Video2Any detects each slide, keeps one clean frame per change, and exports an .pptx or PDF — in your browser, with nothing uploaded.