‘database’ Videos

  • 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

    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

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

  • Patrick Alexander: How to Backup Your WordPress Site

    WordCamp Miami 2016Speaker: Patrick Alexander

    April 17, 2016 — This session will describe the ultimate safety net for one of your key investments: your WP site.
    A brief overview of the moving parts of a WP install/Setup such as database, application and data files will be covered first. Next, we’ll delve more into the tools and procedures required to perform a manual (non-plugin) backup of a WP Site.

    Presentation Slides »

  • Maria Luisa Raviol: MariaDB – Il database che può migliorare le performance delle tue applicazioni WordPress

    WordCamp Torino 2016Speaker: Maria Luisa Raviol

    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 »

  • Evan Volgas: Things You Always Wanted To Know About WordPress (but were afraid to ask)

    WordCamp US 2015Speaker: Evan Volgas

    December 10, 2015 — This talk will cover a few key “Aha” moments that you should have about the way WordPress works. We’ll talk about things like the template hierarchy, what’s going on in wp-config, where WordPress content is stored (the database vs. the file system), how posts and pages and custom post types are represented in the database, what folks are talking about when they talk about hooks and filters, and just generally review the “behind the scenes” mechanics of how WordPress works. We’ll also touch on a few “tricks of the trade” that you might not realize are out there (version control, staging sites, caching, Vagrant, and other fun tools to make development with WordPress just a little bit easier).

    This talk is aimed at designers and new developers who maybe have a few PHP tricks up their sleeves, but still haven’t figured out some of the details behind the scenes.

    If you’ve never edited functions.php and don’t know what it is, this probably isn’t a good talk for you just yet. If you’ve written a plugin or modified several .php files in your WordPress themes, this talk will probably be a bit too basic for you. If you’ve set up a child theme before and know what functions.php is, even if you haven’t really used it all that much, or even at all…. you’re probably the exact person who will get a lot out of this talk. And if that’s you, you should be able to walk away with a solid mental model of how WordPress works “behind the scenes” and be in a much better position to do development with it

    Presentation Slides »

  • Martin Krcho: WordPress a cachovanie modulov

    WordCamp Slovakia 2015Speaker: Martin Krcho

    November 18, 2015 — Cachovanie modulov – WordPress API + Redis/memcached cachovanie na urovni databazy WordPress best practices.

  • Jonathan Daggerhart: Database Interactions with WP_Query and $wpdb

    WordCamp Asheville 2015Speaker: Jonathan Daggerhart

    September 20, 2015 — This session teachs developers how to write custom WP_Query loops, the different functions available for interacting with WP_Query objects, and how to use each function appropriately. We discuss the cases where WP_Query doesn’t fit your needs, and how to deal with the global $wpdb object directly. And we look at the most useful methods available with the $wpdb object, and discuss responsible usage and implementation there of.

  • Michael Cain: The Truth on Theme Security

    WordCamp Boston 2015Speaker: Michael Cain

    August 5, 2015 — Theme security is an intimidating topic for both new and experienced developers but ignoring the issue will make you a target and leave your site vulnerable to attacks. In this talk you’ll learn theme security best practices, the common types of attacks, and many of the functions that WordPress and PHP provide to keep your site safe.