~/talks

David Stokes

what they talk about

where they keep going back

no series more than once — all 4 in the filters

on a stage with

never shared a talk

who talks about the same things

nobody close enough yet

titleconferencedate
MySQL Indexes and Histograms to Speed Up Your QueriesData Con LA 20212021-09-17
Shows how to use MySQL indexes, clustered primary keys, and histograms to give the optimizer real numbers instead of bad guesses — e.g., adding a multi-column…
Talk on
JavaScript Mode and the MySQL ShellOpenJS World 20212021-06-02
The MySQL Shell runs three modes and the JavaScript mode uses the X DevAPI to treat MySQL as a JSON document store, returning 237 documents from the example…
Talk on
Windowing Functions for Database AnalyticsData Love 20212021-04-16
Demos windowing functions available in mysql and other relational databases that make per-group analytics feasible inside SQL, including partition by…
Talk on
Windowing Functions for Database AnalyticsData Love 20212021-04-16
Introduction to SQL window functions with concrete MySQL 8.0 examples showing how to get running totals, moving averages, quartiles and percent ranks from…
Talk on
How De-normalizing Your Data with JSON Can Boost Query PerformancePHP UK Conference 20192019-02-20
Argues that denormalizing into JSON columns and using MySQL Document Store plus the X Dev API cuts the number of costly joins, keeps frequently changing or…
Talk on
~/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.