‘database’ Videos

  • 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 »

  • Christoph Daum: Lightning Talk – Friends will be friends – Dev, Staging und Live als Team

    Christoph Daum: Lightning Talk – Friends will be friends – Dev, Staging und Live als Team

    WordCamp Frankfurt 2016Speaker: Christoph Daum

    September 8, 2016 — Früher oder später kommen wir alle an den Punkt an dem wir neben dem Livesystem noch mindestens ein weiteres System haben, ein lokales Entwicklungssystem oder im besten Fall noch ein Preview System um dem Kunden Änderungen zur Freigabe vorzulegen.

    Da kommen diverse Probleme und Fallstricke.

    Wie synchronisiere ich die Datanbank, oder muss ich das überhaupt?
    Wie halte ich Bilder synchron?
    Wie vermeide ich aus Fahrlässigkeit auf dem Livesystem etwas zu testen?
    Wie kann ich schnell und komfortabel zwischen den Systemen wechseln?
    Was ist mit Updates?

    Presentation Slides »

  • WordPress Community Interview With John Sterrett

    WordPress Community Interview With John Sterrett

    WordPress Community Interview SeriesSpeaker: John Sterrett

    August 5, 2016 — John Sterrett is a Microsoft MVP and is a consultant in the SQL Server field. He specializes in SQL Server performance tuning, high availability, disaster recovery, database design, development and database administration.