quephird

SQL Tricks

Contents

• Purpose
• Nota bene
• Example schema
• Selecting records
  • How do I get a list of items and the sum of another column in a table?
  • How do I concatenate a list of string values each relavant to a row?
• How do I get a list of items and filter the result set on some aggregate?

bishboria

These links no longer work. Springer have pulled the free plug.

Graduate texts in mathematics

duplicates = multiple editions

A Classical Introduction to Modern Number Theory, Kenneth Ireland Michael Rosen

A Classical Introduction to Modern Number Theory, Kenneth Ireland Michael Rosen

rbxbx

[Original Thread](https://twitter.com/rbxbx/status/604492988065169408)

Specific Novels / Series 
========================
Closer to Home, The Fairy Godmother - Mercedes Lackey
The Earthsea Trilogy, The Dispossessed (SF) - Ursula K. Le Guin
Ship of Magic - Robin Hobb
The Killing Moon – N. K. Jemisin
The Goblin Emperor - Katherine Addison
Karen Memory – Elizabeth Bear

rafer

# coding: utf-8

# Can ruby have method names have newlines/be crazy?

class BadKitty
  FACE = "
    |\\_/|
   / @ @ \\
  ( > º < )
   `>>x<<´

jamesarosen

Some questions about optional dependencies

1. A small ruby library

I'm writing a small Ruby library:

class FizzBuzzEndpoint

  def call(env)

coreyhaines

// put this in your address bar, or, better yet, make a bookmark. It removes all traces of comments.
javascript:var subtexts = document.getElementsByClassName("subtext"); Array.prototype.forEach.call(subtexts, function(subtext) { subtext.style.display = 'none'; });

coreyhaines

--colour
-I app

jamis

BASIC BAECHU KIMCHI
--------------------------------------------------------------------------

Baechu (Napa cabbage) kimchi is one of the staple foods in Korea. Spicy
and tangy, it is typically served as a side dish, with rice, but is also
found in various Korean soups and stews.

This basic version has just the fundamentals; once you're comfortable
with this version, you might try adding shredded carrots, Daikon radish,
pickled baby shrimp, or any number of other things. Search around online

zhengjia

=Navigating=
    visit('/projects')
    visit(post_comments_path(post))

=Clicking links and buttons=
    click_link('id-of-link')
    click_link('Link Text')
    click_button('Save')
    click('Link Text') # Click either a link or a button
    click('Button Value')