Carmer

A deposit of SQL information

• https://stackoverflow.com/questions/50406816/one-composite-index-or-many-indexes-for-foreign-keys

Carmer

https://www.cybertec-postgresql.com/en/index-your-foreign-key/

SELECT c.conrelid::regclass AS "table",
       /* list of key column names in order */
       string_agg(a.attname, ',' ORDER BY x.n) AS columns,
       pg_catalog.pg_size_pretty(
          pg_catalog.pg_relation_size(c.conrelid)
       ) AS size,

Carmer

graphql and Relay learning

Helpful Links:

• Thinking in Relay
• Thinking in GraphQL

Carmer

graphql and Relay learning

Carmer

https://blog.hubspot.com/agency/ask-design-feedback

10 Tips for Receiving Useful Feedback from Clients

1. State the goal of the project
2. Control the environment - Use a Project Management Tool
3. Limit the options
4. Provide data to support your design decisions
5. Present the design as a part of the bigger marketing plan
6. Ask specific questions

Carmer

Keybase proof

I hereby claim:

• I am carmer on github.
• I am ajcarmer (https://keybase.io/ajcarmer) on keybase.
• I have a public key ASAws1buAEplqCgjug2LDW1MkPg-TS6o01ggRoSoxlIfaAo

To claim this, I am signing this object:

Carmer

A Hacker's Guide to learning rhythm and lead guitar FAST!

I've been playing guitar for over 30 years. I never took formal lessons - only ocassional ones targeted to a specific topic. I love the discovery process and the relationship I've created with the instrument.

Five years ago or so, I had an a-ha moment, which fundamentaly changed the way I approach my learning of the guitar. After internalizing all the content I consumed, I thing I've come up with a formula for learning both rhythm and lead guitar in a very streamlined and systematic fashion. This method will teach you how to find chords across the entire fretboard so you can create chord progresssions for your own songs, or to make it easier to figure out the chords of your favorite songs.

However, what I like the most about it is that it gets you ready to play lead guitar, without putting too much emphasis on the pentatonic scale. Also, it teaches the guitar from the standpoint of understanding its symetry, and dare I say, the mathematics

Carmer

Actions

• Adds 'ready_for_release' label to the pull request
• Merges the PR
• Adds the Merge and Branch to Tracker story
• Add release_label to Tracker
• Sets tracker story state to 'Accepted'

Usage:

Carmer

1. Define CRUD.

2. Why do we use set method_override: true?

3. Explain the difference between value and name in this line: <input type='text' name='task[title]' value="<%= @task.title %>"/>.

4. What are params? Where do they come from?

5. Check out your routes. Why do we need two routes each for creating a new Task and editing an existing Task?

Carmer

Self Direction Plan - Due Tomorrow

What?

For the final 2 weeks of module 4, we'd like to offer the option to to some extention exploration outside of the cirriculum if you desire.

In class we will be studying the JavaScript library, React.

Past examples of students self-directed study include: