slpsys

require 'json'

fo = File.open('/tmp/tweetstorm.txt','w')

Dir['./data/js/tweets/*.js'].each do |file|
  begin
    fh = File.open(file)
    data = fh.read
    # My Twitter dump had a first line that assigns the JSON data to a variable,
    # the rest was valid JSON. Example:

slpsys

"Pretty stoked on Gmail. Now I (Hate) New plans"
"Dominic Fernow's dad fronting New App to most conferences = fancy pirate hat hat?"
"#seapunk is the Console wizard's "Add a large American Life Choice""
"CSS is Google bus before coffee. And _that_ comfortable."
"Pro Tip: Blacklist coworkers."
"null objects don't want a webserver."
"Seems like sludge metal"
"Keep trollin' trollin' trollin' trollin' trollin' trollin' trollin' trollin' trollin' trollin' trollin' trollin' trollin' trollin' trollin'"
"I be to get rid of Emergency & Poor's."
"Editor's note: there was pitiful, in Ohio."

slpsys

warehouse=# CREATE VIEW events.events AS SELECT * FROM events.a UNION SELECT * FROM events.b;
CREATE

warehouse=# CREATE VIEW events.events AS SELECT * FROM events.a UNION ALL SELECT * FROM events.b;
CREATE

slpsys

/* lexical grammar */
%lex
%%

\s+                   /* skip whitespace */
[0-9]+("."[0-9]+)?\b  return 'NUMBER'
"+"                   return '+'
<<EOF>>               return 'EOF'
.                     return 'INVALID'

slpsys

select
  cast(use2.usename as varchar(50)) as owner,
  pgc.oid,
  trim(pgdb.datname) as Database,
  trim(pgn.nspname) as Schema,
  trim(a.name) as Table,
  (b.mbytes / 1024) gbytes,
  a.rows,
  ((case when a.rows > 0 then b.mbytes / a.rows::real end) * 1024) kb_per_row,
  round(b.mbytes / (sum(b.mbytes) over ())::real * 100, 4) pct_of_cluster

slpsys

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

slpsys

# Drop the Coderpad default tables
drop table if exists alerts;
drop table if exists departments;
drop table if exists employees;
drop table if exists employees_projects;
drop table if exists projects;
drop table if exists sales;
drop table if exists signup_flow_events;
drop table if exists stores;
drop table if exists products;

slpsys

(ns utils)

(def ^:private baphomet
  ["              ._                                            ,"
   "               (`)..                                    ,.-')"
   "                (',.)-..                            ,.-(..`)"
   "                 (,.' ,.)-..                    ,.-(. `.. )"
   "                  (,.' ..' .)-..            ,.-( `.. `.. )"
   "                   (,.' ,.'  ..')-.     ,.-( `. `.. `.. )"
   "                    (,.'  ,.' ,.'  )-.-('   `. `.. `.. )"

slpsys

(ns generativity 
  (:use [cascalog api]))

(defn one_of [seq] (vec (map vector seq)))
(deffilterop forbid
    ([var comparator val]
      (not (comparator var val)))
    ([var op val comparator comparee]
      (not (comparator (op var val) comparee))))

slpsys

Essential Bruce Springsteen All albums and tracks appear in chronological order.

1. Greetings from Asbury Park

• lolno

2. The Wild, The Innocent, & The E Street Shuffle

• Rosalita (Come out Tonight)
• Incident on 57th Street