momer

There are a number of good introductory SQL resources available for free and online. There are also some paid resources which I recommend for beginners, that are very effective, and well worth expensing in my opinion.

A couple of notes:

• I haven’t used all of these resources, but they come with strong recommendations around the web or myself/my peers.
• You absolutely don’t need to use every single resource. Find a couple that work for you, and go to town.
• You can always reach out to me if you have questions. I always paste this online when people are new to asking very technical questions – it’s not meant to be snarky – it's a gentle guide on how to compose your questions and gather necessary resources in order to best give technical people the information needed to get a quick/effective response: http://www.mikeash.com/getting_answers.html

Video/Class/Mini-course based:

1. Stanford Self-paced ‘Database’ course

• The original Coursera

momer

package main

import (
    "myapp/webserver/app/common"
    "github.com/golang/glog"
    "github.com/gorilla/mux"
    "encoding/json"
    "strconv"
    "flag"
    "fmt"

momer

Privacy Policy

Last revised on [DATE]

The Gist

[COMPANY] will collect certain non-personally identify information about you as you use our sites. We may use this data to better understand our users. We can also publish this data, but the data will be about a large group of users, not individuals.

We will also ask you to provide personal information, but you'll always be able to opt out. If you give us personal information, we won't do anything evil with it.

momer

Terms of Service

Last revised on [DATE]

The Gist

[COMPANY] operates the [SERVICE] service, which we hope you use. If you use it, please use it responsibly. If you don't, we'll have to terminate your account.

For paid accounts, you'll be charged on a monthly basis. You can cancel anytime, but there are no refunds.

momer

{
    "name": {
        "title": "Full Name",
        "type": "string",
        "githubKey": "name"
    },
    "email": {
        "title": "E-Mail",
        "type": "string",
        "githubKey": "email",

momer

package main

import "fmt"
import "time"
import "encoding/hex"
import "hash/fnv"

func main() {
  h := fnv.New64a()

momer

Talks (video)

• The Data Model is Dead, Long Live the Data Model - Patrick McFadin
  • slides
• Become a Super Modeler - Patrick McFadin
  • slides
• The World's Next Top Data Model - Patrick McFadin
  • slides

Talks (slides)

• C* Summit 2013: Eventual Consistency != Hopeful Consistency by Christos Kalantzis

momer

  def moderate_plus_vigorous_durations_adjusted(start_date=(1.week.ago.beginning_of_day), end_date=(DateTime.now))
    query_args = [{value: self.id}, {value: start_date}, {value: end_date}]
    sql = %Q[
      WITH my_vars(intensity_2_duration, intensity_3_duration) AS (VALUES 
        (
          (SELECT SUM(duration) as intensity_2_duration
            FROM users 
            INNER JOIN workouts 
              ON workouts.user_id = users.id
            WHERE 

momer

WITH my_vars(intensity_2_duration, intensity_3_duration) AS (VALUES 
  (
    (SELECT (SUM(duration)*2) FROM users INNER JOIN workouts ON workouts.user_id = users.id
      WHERE intensity = 3 AND workouts.deleted_at IS NULL),
    (SELECT SUM(duration) FROM users INNER JOIN workouts ON workouts.user_id = users.id
      WHERE intensity = 2 AND workouts.deleted_at IS NULL)
    )
)
SELECT MAX(date), (SELECT (intensity_2_duration + intensity_3_duration) FROM my_vars) as total_duration, SUM(duration)
FROM workouts

momer

upstream unicorn {
  # fail_timeout=0 means we always retry an upstream even if it failed
  # to return a good HTTP response (in case the Unicorn master nukes a
  # single worker for timing out).
  # for UNIX domain socket setups:
  server unix:/tmp/unicorn.examplesitehere.sock fail_timeout=0;
}

server { 
    listen 80;