November 2, 2020 — È molto facile salvare le informazioni nel database di WordPress, tanto che non ce ne accorgiamo nemmeno. Lo facciamo quasi inconsciamente quando ci muoviamo come un pesce nell’acqua attraverso il WordPress Manager premendo i pulsanti, configurando i plugin o aggiornando gli stati dell’ordine.

Ma, come possiamo fare per recuperare manualmente quei dati e modellarli per un successivo utilizzo nei nostri progetti?

WordPress ci offre diversi strumenti per accedere al database in modo sicuro, ma senza dubbio la classe WP_Query sarà il nostro miglior alleato per tuffarci nel mare dei dati.

In questo discorso spiegherò cos’è e come si può usare WP_Query, una delle più grandi e potenti classi di WordPress per estrarre informazioni preziose dal database.

August 13, 2020 — In this step, we are going to create the database based on the information we passed to the wp-config.php file in step #2.

December 21, 2019 — In questo speech, Carlo cercherà di far venir voglia di provare a sviluppare con WordPress a chi conosce un po’ di PHP . Non sarà un discorso sullo sviluppo dei temi o dei plugin, ma su come accedere via PHP ai dati presenti nel database: spiegherà infatti come si modificano le query di WordPress per personalizzare in modo granulare i risultati mostrati a video.

Questo è l’indice degli argomenti che tratterà.

Il database e i dati:
cosa sono i post;
i tipi di post;
le tabelle di archiviazione dei post.
Le query di WordPress:
la classe WP_Query;
i parametri della classe WP_Query;
la trasmissione dei parametri;
le query variable (pubbliche e private).
La visualizzazione dei dati:
la classe WP_Post;
il Loop;
le liste (la funzione get_posts()).
Come personalizzare le query:
modifica del Loop (pre_get_posts o tramite nuove istanze di WP_Query).

December 19, 2019 — Is your website running slowly? If you’ve had a WordPress site for a few years, it could be the MySQL database—the silent killer of WordPress performance. The database can be the biggest drain on WordPress speed and stability but for many of us, it’s the most intimidating part to address, which can leave sites bloated, expensive, and ready to crash under high traffic.

But it’s actually not that scary. Using WordPress plugins and phpMyAdmin, we’ll build the skills to diagnose database issues, go over some common problems and a few weird edge cases from abandoned plugin data to blog imports gone wrong, and learn how to safely fix and maintain the database for top performance.

Presentation Slides »

June 2, 2019 — All of the data for your WordPress site is stored in the database. We’ll look at what this means and how this information is organized. Understanding the WordPress database has allowed me to perform emergency maintenance on sites and made me a better developer. Join me for this light-hearted romp through the WordPress database (no prior database experience necessary).

April 30, 2019 — Is your website running slowly? If you’ve had a WordPress site for a few years, it could be the MySQL database—the silent killer of WordPress performance. For many of us, the database is the most intimidating optimization challenge, leaving it to make sites bloated, expensive, and ready to crash under high traffic. But it’s actually not that scary. Using WordPress plugins and phpMyAdmin, we’ll build the skills to diagnose database issues, go over some common problems and weird edge cases, and learn how to safely fix and maintain the database for top performance.

Presentation Slides »

January 8, 2019 — Sometimes, it’s easier to edit something in the database than use the dashboard. BUT only if you know what you are doing!

Come learn about the database that powers WordPress and how you can use it to your advantage.

Takeaways:

How is the WordPress database structured
How to change your password without logging into your site
What you can change about your site from the database and how

Presentation Slides »

July 12, 2018 — The wp_options database table is the center of all WordPress websites. It stores critical site data and is used on nearly every page in WordPress. However, it’s also very easy for the wp_options table to slow your site to a grinding halt. This talk will review best practices for keeping your wp_options table in check to keep your site performant.

Presentation Slides »

December 25, 2017 — На WordCamp Moscow в этом году Константин расскажет о том, как создавать собственные таблицы в базе данных WordPress, как ими пользоваться и как их правильно обновлять.

Речь пойдет о функции dbDelta(), некоторых методах объекта $wpdb, а так же о существенной разнице в скорости между произвольными таблицами и произвольными типами записей (CPT) в WordPress.

Доклад рассчитан на разработчиков, но любому владельцу сайта будет также интересно знать, почему разница в схеме данных может погубить производительность их проекта.

August 31, 2017 — Synopsis: Request a page on a WordPress-powered website, and WordPress responds roughly as follows. Core libraries are loaded, followed by plugins. The URL is parsed to determine which items are being requested from the database, and a corresponding theme template is selected. The HTML is then rendered and sent to the browser.

When building client sites or advanced plugins, it’s often necessary to intervene in this process: to perform an early redirect, to modify the rules for parsing URLs, to load an alternate theme template. In this talk, I’ll outline some of the key places where you can (and where you shouldn’t!) interrupt and modify WordPress’s loading process for your purposes.