Skip to content

Instantly share code, notes, and snippets.

@jueyang
jueyang / bike.jpg
Last active Mar 27, 2018
Bartering rules and faq's. @permanent.transience. March 31 & Apr 1.
View doublecheck.md

Install homebrew:

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Install hub

brew install hub

alias git=hub

View on-scratch.md

Even if you just want to set up a WordPress site (because that's what you've been conditioned to do), resist the urge. Try making something on your own first. You are not doing it for the sake of it, you are getting a better grasp of the anatomy of a structure, a structure that, once you get good at, will allow you more control and creative freedom.

Of course, like making anything from scratch, it's going to take a bit longer at first. Have you made a pumpkin pie from scratch? You roast the pumpkin, scoop out the seeds, puree the flesh. Meanwhile you make the dough with flour, very cold butter, and 1/4 cup of iced water with a pastry cutter. If you want it faster, you can always buy a can of pumpkin puree, and pour it into a pre-made pie crust. Or -- if you just want to eat -- you buy a pumpkin pie in a box from the store.

It's the same idea when it comes to making something from scratch on the internet. You can experiment when you know how it works. Otherwise, you are just consuming someone else's products

View the.train.explain.md

Leave your comments below if you have thoughts or concerns about @the.train. If you'd rather not sign up for GitHub (which is where this document is hosted on), you can text or leave a message at 929-266-4122. I will get back to you shortly. Thank you.

License

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Disclaimer

Due to the spontaneous nature of the project, the photographer might not have the opportunity to discuss with participants about the distribution of the work. All work will be published on @the.train, which is not associated with any organization, and does not serve

View scavenger-sites.md

Locations:

  • The old NY Daily News Building (until 1995)
  • The site of the old Biograph Studios
  • The Jacob Riis Neighborhood Settlement House
  • The site of the Lion's Head
  • Black Rock
  • NY1
  • Current offices of the NY Daily News
  • Current offices of The New York Post
  • BuzzFeed
View scavenger-hunt-2015.md

The 1st CUNY J-School New York Journalism History Hunt!

Your mission

Locate as many of the journalism-related sites from this list.

Instructions

View upsert.sql
$insert = "INSERT INTO spider_count (spider, tally) SELECT 'Googlebot', 1";
$upsert = "UPDATE spider_count SET tally=tally+1 WHERE date='today' AND spider='Googlebot'";
WITH upsert AS ($upsert RETURNING *) $insert WHERE NOT EXISTS (SELECT * FROM upsert);
--- expanded
WITH upsert AS (
UPDATE spider_counts
SET tally=tally+1
WHERE date='today' AND spider='Googlebot'
View update_and_insert.sql
WITH
-- write the new values
new(the_geom,description,name) AS (
VALUES (ST_SetSRID(ST_Point(12,12),4326),'an update',123456),
(ST_SetSRID(ST_Point(13,13),4326),'an insert',100000)
),
-- update existing rows
upsert AS (
UPDATE {table} original
SET the_geom=new.the_geom, description=new.description