‘database’ Videos

  • Patrick Alexander: How to Backup Your WordPress Site

    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

    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)

    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

    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

    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

    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.

  • Mo Jangda: The Database Schema

    Mo Jangda: The Database Schema

    WordCamp Montréal 2014Speaker: Mo Jangda

    May 17, 2015 — Understanding how the database schema of WordPress is setup, including a walk-through of the tables and how WordPress stores the data and helps you interact with it via its APIs. We’ll also dive into the benefits and dangers of the schema and how to adapt it to go beyond just blog posts.

    Presentation Slides »

  • Rick Radko: Backing Up Your WordPress Website – It’s Not Optional

    Rick Radko: Backing Up Your WordPress Website – It’s Not Optional

    WordCamp Montréal 2014Speaker: Rick Radko

    May 14, 2015 — Could you recover your WordPress website if it was lost due to a hardware failure, hacked, or corrupted during an update or plugin install? Having reliable automated backups can make the difference between taking 10 minutes to restore your site, and needing to do a complete site rebuild that may take a week or more. This presentation will look at the many options and plugins for backing up your WordPress site including backing up to Amazon S3.

    Presentation Slides »

  • Evan Volgas: HyperDB

    Evan Volgas: HyperDB

    WordCamp Atlanta 2015Speaker: Evan Volgas

    May 5, 2015 — This session looks at what HyperDB is, when you might want to use it, how to use it in the first place, as well as some other flavors of MySQL that you might consider taking a look at (in particular MariaDB and Percona MySQL). This session is aimed at advanced developers who are looking to level-up their database chops.

    Presentation Slides »

  • Hristo Pandjarov: WordPress Migration 101

    Hristo Pandjarov: WordPress Migration 101

    WordCamp Orlando 2014Speaker: Hristo Pandjarov

    March 28, 2015 — In this talk I will go through the process of migrating a WordPress website to a new server. I will list the issues that users will probably face and how to overcome them. I will show easy to follow tips and tricks that will make moving WordPress possible even for beginners.

    Presentation Slides »


Get every new post delivered to your Inbox.

Join 20,403 other followers