Tag: database

WordPress Grand Rapids Building Web Apps

Building Web Apps with WordPress: Jan 2015 meetup

We talked about Building Web Apps with WordPress at our Jan 15, 2015 meetup. Below are the notes.

WordPress Grand Rapids Building Web Apps

WordPress as a Web App

Presented by Brian Richards

  1. Components
    1. Custom post types
    2. Custom taxonomies
    3. Custom meta: post meta, user meta, comment meta
    4. User roles & restrictions
    5. Post relationships (via Posts 2 Posts)
  2. Methods
    1. WP_Query
    2. pre_get_posts: can be more specific than above
    3. $wpdb: can be even more specific than above
    4. AJAX: save users time and reduce server load
  3. Tools
    1. zapier.com: like IFTTT, but with more options
    2. AppPresser.com: Convert your WordPress website into a mobile app, publish on the app stores
    3. WP-API (coming soon): Access your WordPress site’s data through an easy-to-use HTTP REST API

Misc.

  • Ask: who is your core audience? What are they trying to do with the data? Answers help with information architecture.
  • BadgeOS: free plugin that lets you easily create achievements and issue sharable badges as your users succeed
  • Why start with WordPress? You can build very quickly because of the tools available in WordPress.
  • Caching: use transients, Varnish, memcached

Using WordPress to Power an Application: How we built a rewards platform in just a few weeks

Presented by Bob Orchard

  1. Choose Your Features
  2. Plan Your Development
  3. Install WordPress
  4. Create Your Plugin

Announcements

We’ve started planning WordCamp Grand Rapids 2015! We’ll have our first volunteer meeting after the next meetup (Feb 19). You’re welcome to join us!

WordPress Backups WordPress Grand Rapids

WordPress Backups, Oct. 2014 meetup

We talked about backing up WordPress sites at our Oct 16, 2014 meetup. We covered a few backup plugins and management services. Below are the notes.

WordPress Backups WordPress Grand Rapids
Chad Warner speaking to WordPress Grand Rapids
WordPress Backups WordPress Grand Rapids
Peter DeHaan speaking to WordPress Grand Rapids

BackupBuddy & Amazon S3, etc.

Presented by Chad Warner

BackupBuddy

BackupBuddy is a premium plugin. Instructions: How to use BackupBuddy with Amazon S3.

BackWPup

BackWPup is a free backup plugin. These instructions are several months old, and may not be 100% accurate.

  1. Create Amazon IAM user and add to BackupBuddy group.
  2. Create S3 bucket named ow-sitename
  3. Settings
    1. General
      1. uncheck Show BackWPup links in admin bar.
    2. Jobs
      1. clear Key to start jobs externally with an URL
  4. Add New Job
    1. General
      1. Job Name: Database, files, uploads (local & offsite)
      2. Tasks: all except WordPress XML export
      3. Destinations: Folder, S3 Service
      4. Email address
    2. Schedule
      1. with WordPress cron
      2. basic, weekly, Monday (or daily or monthly)
    3. DB Backup: exclude unnecessary
    4. Files
      1. exclude unnecessary root, plugins, themes, cache
    5. To: Folder
      1. File Deletion: 6
    6. To: S3 Service
      1. Access Key and Secret Key: generate for user in Amazon IAM
      2. Bucket: select bucket for this site
      3. File Deletion: 6

Duplicator

Duplicator is a free plugin. Instructions (may be outdated): Copy and migrate WordPress sites with the Duplicator plugin

Backup Services

Online Backup for WordPress

Presented by Peter DeHaan

Online Backup for WordPress is a free plugin

  • many destinations
  • incremental backup

WordPress Management Tools & Hosting

Presented by Bob Orchard

WP Remote

  • TinyPint uses for backups
    • manual, not automatic; run backup, save to machine
    • downloads zip of files and database
    • can download entire site (files and database) or just database
    • can exclude files
  • setup
    • add site to WP Remote
    • install plugin
    • activate plugin
    • enter API key
    • in WP Remote, refresh

ManageWP

  • can run security check of site
  • many more options than WP Remote
  • performance test
  • can show WP admin screen within iframe
  • can back up database only or files and database
  • can exclude files or folders
  • can backup to multiple destinations, including Amazon S3, Dropbox, Google Drive, FTP
  • can clone and restore sites

Amazon S3

3Hub for accessing Amazon S3

Flywheel

  • made for agencies who create and manage WordPress sites
  • free demo sites for 14 days
  • automatic backups
  • fast; caching automatically configured

Media Temple Premium WordPress Hosting

  • backups
  • staging
  • cloning
  • easy migration
  • GoDaddy’s hosting with MediaTemple interface
WordPress Grand Rapids logo

WordPress Q&A/Study Hall: Nov 2013 meetup

Our November 2013 meetup topic was WordPress Q&A/Study Hall. We discussed questions and helped each other with our WordPress sites. Here’s a summary of the questions, answers, and other items discussed.

If I missed any, please leave a comment, and I’ll add to the post.

Relational database to relate custom fields

  • Posts 2 Posts: Efficient many-to-many connections between posts, pages, custom post types, users
  • Pods: a framework for creating, managing, and deploying customized content types and fields

Responsive Mega Menu

  • Hide Mega Menu on mobile, display simple navigation instead
  • See MSNBC for reference
  • UberMenu: user-friendly, highly customizable responsive Mega Menu WordPress plugin

Featured images in Genesis

  • For archives, Genesis first looks for a featured image; if it can’t find it, it looks for the first image attached to the post
  • Video Thumbnails will set video thumbnail as featured image

Fork a plugin and prevent updates

Must change plugin’s directory name

Breadcrumbs for CPTs

  • Create archive and style it as desired
  • Set archive to true for CPT, use rewrite API to point to desired page

Image resizing and compressing

Imsanity: automatically resizes huge image uploads

Cool stuff

  • Advanced Automatic Updates: Adds extra options to WordPress’ built-in Automatic Updates feature

  • MP6: preview future WP admin UI
  • Genericons: vector icons embedded in a webfont
  • Mentionable: Mention WordPress content with inline autocomplete inside tinyMCE (Topher DeRosia’s plugin)
  • Widget Customizer: Edit widgets and preview changes in Theme Customizer, with a control for each widget form in sections added for each sidebar rendered in the preview (Topher DeRosia’s plugin)
  • Dependency Minification: automatically concatenates and minifies any scripts and stylesheets enqueued using the standard dependency system
  • Query Monitor: View debugging and performance information on database queries, hooks, conditionals, HTTP requests, redirects and more.
  • AppPresser: Build iOS/Android apps using WordPress
  • Add From Server: allows you to import media & files into the WordPress uploads manager from the web server

Mentions

  • GiveCamp Grand Rapids: a weekend-long event where software developers, designers, and database administrators donate their time to create custom software for non-profit organizations.
  • The User is Drunk: create UI that’s so good that drunks can use it
  • SiteGround: web host
  • DigitalOcean: web host
  • WPSessions: training sessions by WordPress experts (run by Brian Richards)