Skip to content

Instantly share code, notes, and snippets.

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

Install homebrew:

/usr/bin/ruby -e "$(curl -fsSL"

Install hub

brew install hub

alias git=hub


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


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.


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


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



  • 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

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

Your mission

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


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
-- 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