~/talk

Gain More Insight into Your Data with SQLite and Sequel Pro

TalkinDutchat WordCamp Antwerp 2018 · on Saturday, 2018-03-03· [wordpress, databases]
links:none on file
slides:none on file

Shows how to use SQLite (cross-platform) and Sequel Pro (macOS) to inspect and manipulate WordPress site data instead of relying on wp-admin, spreadsheets, CSVs or custom PHP scripts. Demonstrates leveraging SQL queries to simplify one-off data preparation and edits, making common import/export and data-cleanup tasks faster and more reliable.

AI-written summary · about

~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 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
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
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.