November 12, 2019 — WordPress is built on a database, but have you ever taken a look at what’s in it? Come take a stroll through the tables and fields in the WordPress database and learn how they work together to make your site.

August 28, 2019 — For nearly a decade, developers have been encouraged to use custom post types and taxonomies for all of their needs, and life was good. Good enough, anyway. For the next decade of advanced computing, machine intelligence will require, at the very least, custom database tables. John will break down what a database really is and what WordPress got right and wrong, and share several solutions that plugin developers can use right now to interface with complex custom data structures inside of WordPress.

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