November 1, 2018

August 1, 2018 — Letos bych se chtěl lépe podívat na problematiku mergování databází – proč je to důležité, jak to pomáhá s každodenní prací WordPress vývojářů, jaké jsou možné přístupy a co v této oblasti čekat do budoucna. Přednáška určitě půjde za hranice VersionPressu.

Cílem je podat hlavně dobrý přehled, který posluchačům umožní lépe se orientovat v nástrojích, které jim v praxi můžou ušetřit spoustu času a nervů.

February 27, 2018 — WordPress delega tutta la sua potenza in 12 tabelle di MySQL che insieme sono capaci di supportare una vasta gamma di progetti web. Ma cosa succede quando vogliamo andare un po’ più in là?

Vedremo in questo talk come funzionano le tabelle di WordPress, che relazioni esistono e come possiamo espandere il database per realizzare progetti più specifici e complessi.

February 8, 2018 — This talk is about very heavy database schema / information architecture topics:

– Some anecdotes of slow WordPress / WooCommerce sites, examples to illustrate the need to talk about this
– Rundown on why they were slow
– Detailed explanation of what indexes are, how they work conceptually and what MySQL does if they aren’t available
– Rundown of WordPress / WooCommerce database schema
– Common scenarios of user / client wishes and why the same doesn’t work in a large site (query / order by postmeta values for example)
– What can be done about it (WooCommerce 3.0 data accessor classes, custom database tables, indexing)
– References / links to learn more about this