Skip to content

Instantly share code, notes, and snippets.

View pporche87's full-sized avatar

Patrick Porche pporche87

25 followers · 37 following
View GitHub Profile
@pporche87
pporche87 / postgres-cheatsheet.md
Created October 27, 2018 17:39 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
@pporche87
pporche87 / 020518_workplan_PatrickP.md
Created February 6, 2018 18:19

Overview

Closing up odds and ends at the guild, attending dev week, prepare for next round of interviews.

Study Plan

  • Finish Outco Runway
  • Finish Udemy Data Structures and Algorithms Course
  • Finish FrontEnd Masters DS and Algs Course
  • Sign up for LeetCode Pro
  • Update Resume/Profiles
@pporche87
pporche87 / 012917_WorkPlan_PatrickP.md
Created January 29, 2018 19:42

Overview

Move Queers in Tech forward by creating app and acting as product manager to divide out work

Plans

  • Meet with Judy to build out small features cards
  • Divide out work
  • Deep dive into git project management

Additional

  • Finish advanced React/Redux course
@pporche87
pporche87 / 2018-01-16_work_plan.md
Last active August 7, 2019 08:34

Overview

Create a flexible but focused plan to move forward job search efforts and continue learning. This week I have a technical interview with Going Merry, a phone screen with Metal, a fundamentals check with Outco, and a video call with Teachfx. I also intend to apply to the Twilio internship. I need to build in React with Ethereum and Solidity, do some Algorithms and Data Structures, and study front-end interview questions. There were some awesome companies at the hackathon, I want to identify about 3 companies to research and apply to this week.

Work Plan

Learning

@pporche87
pporche87 / queerHelloApp.js
Created January 7, 2018 04:21
import React, { Component } from 'react';
import logo from './logo.svg';
import './App.css';
import Queers from './components/queers/queers'
class App extends Component {
render() {
return (
<div className="App">
<header className="App-header">
@pporche87
pporche87 / queerHello.css
Created January 7, 2018 04:19
ul {
list-style: none;
padding: 0;
width: 30%;
margin: auto;
}
li {
font-size: 1.3rem;
line-height: 2rem;
@pporche87
pporche87 / queerHello.js
Created January 7, 2018 04:18
import React, { Component } from 'react';
import './queers.css';
class Queers extends Component {
constructor() {
super()
this.state = {
queers: []
}
}
@pporche87
pporche87 / 2018-01-02_work_plan.md
Last active March 20, 2018 04:50

Overview

Interview prep and portfolio/resume focus. Identify open source project.

Areas of Focus

  1. Interview Preparation
  2. Algorithms/Data Structures
  3. Portfolio
  4. Resume
  5. Pick open source project
@pporche87
pporche87 / story_building.md
Last active August 7, 2019 08:36

Story Building Workshop

"Let's get to know each other" questions

Well, long story short. I started my career in health and wellness. After college I worked as an independent personal trainer, before taking a position as a Wellness Director for a non-profit. In my career I sort of specialized in

  1. Who are you? Tell me about yourself?
    • I got my start in health and wellness, first as a personal trainer... After a few years I turned my focus to corporate wellness. I took a position as the Wellness Director for a non-profit senior living facility in San Francisco.
    • As I began my work there, I started to focus my energy on dimensions of wellness outside of the realm of purely physical or nutritional.
  • I focused on helping people find their passion in life through some holistic lifestyle coaching methodologies that focused primarily on emotional and spritual well-being.
@pporche87
pporche87 / curriculumspencerpatrick.MD
Last active August 7, 2019 08:36
Intended structure for self-directed study plan.

Curriculum Spencer & Patrick

Intended structure for self-directed study plan.

Meta-Goals

  1. Master Concepts of Core Data Structures and Algorithms
  2. Master Advanced Web Development Fundamentals
  3. Develop Expert Technical Interviewing Skills
  4. Launch Queers In Tech Networking Organization
  5. Develop Linq Mobile Application in Production Environment