November 26, 2020 — Questo mese, grazie a Maria Luisa Raviol, abbiamo parlato del mondo dei database ed in particolare di MariaDB. 🎉

MariaDB è una fork di MySQL che è in grado di arricchire WordPress di migliori performance, scalabilità, alta disponibilità e sicurezza.
Da tempo, fa parte dei requisiti di installazione di WordPress.

Nella presentazione abbiamo fatto un’introduzione a MariaDB comprensibile anche per chi non è uno sviluppatore, parlato di come stia diventando il database relazionale open source di riferimento per moltissime aziende nel mondo e di come possa diventare un grande alleato degli sviluppatori WordPress.

July 10, 2018 — You’re a rockstar with the front end and the WordPress admin, but the back end is… a mystery. Ever wonder what happens when you create a user or save a post? Where does the data go? Let’s dive in to the MySQL database via phpMyAdmin. We’ll explore the WordPress core tables and investigate the fields to see how the data is stored. We’ll also touch on optimizing your tables and creating database backups without a plugin.

Presentation Slides »

January 31, 2017 — WordPress is built on 12 MySQL tables than can support the weight of almost any web project. But in some cases we need to set our custom tables in order to get better results. I will show in this talk the magic behind the default tables, how to create new ones, and what WordPress tools we may use to control them.

Presentation Slides »

November 20, 2016 — WordPress delega todo su potencial en 12 tablas de MySQL que relacionadas entre sí son capaces de soportar una gran variedad de proyectos webs.

Pero ¿qué pasa cuando queremos ir un poco más allá? Veremos en esta ponencia cómo funcionan las tablas por defecto de WordPress, sus relaciones y cómo podemos expandir la base de datos para proyectos más específicos.

Presentation Slides »

September 6, 2016 — Als Reaktion auf den Talk von Hans Helge auf dem WordCamp Nürnberg war mir klar das das Thema Synchronisation von Datenbanken zwischen Entwicklungs-, Test- und Livesystemen ein großes Problem darstellen.

In diesem Talk möchte ich einen Weg aufzeigen wie man mit diesem Problem umgehen kann, insbesondere wie man individuelle Tabellen in WordPress richtig anlegt und verwaltet.

Presentation Slides »

April 5, 2016 — MariaDB è un fork di MySQL il database relazionale, sviluppato da una community sotto licenza GNU GPL che intende mantenerlo come software libero.
Con ottimizzatore avanzato delle performance di MariaDB e le sue specifiche caratteristiche si possono facilmente migliorare le performance della tua applicazione.

Presentation Slides »

December 10, 2015 — Mirroring WordPress data to Elasticsearch enables breaking some of the constraints that MySQL imposes on performance and relevancy. There is a high barrier to entry, but some strong benefits. I’ll survey the different use cases I’ve heard about, compare some plugins and libraries, and talk about the impact I’ve seen Elasticsearch have so far.

August 1, 2015 — Talking about elasticsearch, why searching in WordPress/MySQL is bad and what next gen NLP technologies will allow WP to do.

January 1, 2015 — Protecting our WordPress sites is important to all of us; this talk will help provide you with the tools to secure your server. Learn the best practices to follow in securing your WordPress site, and the common pitfalls to avoid. This is for both new users who are setting up a WordPress installation from the ground up, and also experienced WordPress users for hardening their existing sites.

Presentation Slides »

February 24, 2009 — If your hosting package only allows you one MySQL database, then this video is for you. Kenneth Watt (founder
of TechnoFinger) shows you how to edit your wp-config.php file so that multiple versions of WordPress can be run on the one MySQL database.