jeffwidman

Effective Engineer - Notes

• By Edmond Lau
• Highly Recommended 👍
• http://www.theeffectiveengineer.com/

What's an Effective Engineer?

• They are the people who get things done. Effective Engineers produce results.

Adopt the Right Mindsets

jeffwidman

#!/usr/bin/env python
# -*- coding: utf-8 -*-
from flask import Flask, render_template

app = Flask(__name__)

@app.route('/')
def index():
    return render_template('index.html')

jeffwidman

# The problem is that from time to time the GitHub issue import API returns a status url for the issue import
# that when I check that status url, I get a 404 response.

# Below is an example of a request/response pair that came back with a status url that 404'd:

# All of these requests use the header = {'Accept': 'application/vnd.github.golden-comet-preview+json'} 
# Also I authenticate via my username/personal access token. 
# Neither the header nor the auth should pose a problem because it successfuly imports dozens of issues before 
# hitting any issues. 

jeffwidman

WordPress database clean up queries

• Orphan rows
  • wp_posts -> wp_posts (parent/child)
  • wp_postmeta -> wp_posts
  • wp_term_taxonomy -> wp_terms
  • wp_term_relationships -> wp_term_taxonomy
  • wp_usermeta -> wp_users
  • wp_posts -> wp_users
• Other
  • wp_postmeta dupes