‘database’ Videos

  • Carlo Daniele: Dal Database alla Pagina - Le Query e i Post di WordPress

    Carlo Daniele: Dal Database alla Pagina – Le Query e i Post di WordPress

    WordCamp Milano 2019Speaker: Carlo Daniele

    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).

  • David Greenwald: How to Clean the WordPress Database

    David Greenwald: How to Clean the WordPress Database

    WordCamp Seattle 2018Speaker: David Greenwald

    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 »

  • Sal Ferrarello: Introduction to the WordPress Database

    Sal Ferrarello: Introduction to the WordPress Database

    WordCamp Lancaster 2019Speaker: Sal Ferrarello

    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).

  • David Greenwald: How to clean up the WordPress Database

    David Greenwald: How to clean up the WordPress Database

    WordCamp Portland 2018Speaker: David Greenwald

    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 »

  • John Dorner: A look at the database behind the curtain

    John Dorner: A look at the database behind the curtain

    WordCamp Asheville 2018Speaker: John Dorner

    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 »

  • Ben Greeley: Taming the WP Options Table

    Ben Greeley: Taming the WP Options Table

    WordCamp Europe 2018Speaker: Ben Greeley

    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 »

  • Константин Ковшенин: Произвольные таблицы в базе данных WordPress

    Константин Ковшенин: Произвольные таблицы в базе данных WordPress

    WordCamp Moscow 2017Speaker: Konstantin Kovshenin

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

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

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

  • Boone Gorges: Interrupting WordPress

    Boone Gorges: Interrupting WordPress

    WordCamp Chicago 2017Speaker: Boone Gorges

    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.

  • Mauricio Gelves: WordPress Database - What’s Behind Those 12 Tables?

    Mauricio Gelves: WordPress Database – What’s Behind Those 12 Tables?

    WordCamp Athens 2016Speaker: Mauricio Gelves

    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 »

  • La base de datos de WordPress: 12 tablas que valen pa'tó y un poco más

    La base de datos de WordPress: 12 tablas que valen pa’tó y un poco más

    WordCamp Santander 2016Speaker: Mauricio Gelves

    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 »