Skip to content

Instantly share code, notes, and snippets.

View ginatrapani's full-sized avatar
🏳️‍🌈
a work in progress

Gina Trapani ginatrapani

🏳️‍🌈
a work in progress
View GitHub Profile

Keybase proof

I hereby claim:

  • I am ginatrapani on github.
  • I am ginatrapani (https://keybase.io/ginatrapani) on keybase.
  • I have a public key whose fingerprint is 765B 58F7 1667 C797 D76D E072 CE76 96B8 B249 855D

To claim this, I am signing this object:

<?php
header( 'Location: http://localhost/thinkup/plugins/twitter/auth.php?oauth_token='.$_GET['oauth_token'] ) ;
// Assumes http://localhost/thinkup is the URL to access ThinkUp on your local server.
?>
/**
* LICENSE:
*
* This file is part of ThinkUp.
*
* ThinkUp is free software: you can redistribute it and/or modify it under the terms of the GNU General Public
* License as published by the Free Software Foundation, either version 2 of the License, or (at your option) any
* later version.
*
* ThinkUp is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied
CREATE TABLE tu_posts_tmp ( post_id bigint(11) NOT NULL );
INSERT INTO tu_posts_tmp
SELECT p.post_id FROM tu_posts p
INNER JOIN tu_posts p1 ON p.in_reply_to_post_id = p1.post_id
WHERE p.network = 'facebook' AND p1.network='facebook page';
UPDATE tu_posts, tu_posts_tmp
SET network = 'facebook page'
@ginatrapani
ginatrapani / Favorites crawl log
Created November 16, 2010 23:18
I deleted all rows from tu_favorites, and set all the favorite-related tu_instance table fields to 0 and ran the crawler. Here's what happened.
2010-11-16 15:24:33 | 3.27 MB | ginatrapani | CrawlerTwitterAPIAccessorOAuth:Errors to tolerate: 10
2010-11-16 15:24:36 | 3.91 MB | ginatrapani | CrawlerTwitterAPIAccessorOAuth:API request: https://api.twitter.com/1/account/rate_limit_status.xml
2010-11-16 15:24:36 | 3.91 MB | ginatrapani | CrawlerTwitterAPIAccessorOAuth:Parsing XML data from https://api.twitter.com/1/account/rate_limit_status.xml
2010-11-16 15:24:36 | 3.91 MB | ginatrapani | CrawlerTwitterAPIAccessorOAuth:45 of 350 API calls left this hour; 7 for crawler until 15:43:11
2010-11-16 15:24:36 | 3.91 MB | ginatrapani | TwitterCrawler:***in fetchInstanceUserTweets
2010-11-16 15:24:37 | 3.91 MB | ginatrapani | CrawlerTwitterAPIAccessorOAuth:API request: https://api.twitter.com/1/users/show/ginatrapani.xml
2010-11-16 15:24:37 | 3.91 MB | ginatrapani | CrawlerTwitterAPIAccessorOAuth:44 of 350 API calls left this hour; 6 for crawler until 15:43:11
2010-11-16 15:24:37 | 3.97 MB | ginatrapani | UserMySQLDAO:User ginatrapani updated in system.
2010-11-1
@ginatrapani
ginatrapani / gist:1072329
Created July 8, 2011 17:32
TODOTXT_FINAL_FILTER
#!/bin/bash
export COLOR_CONTEXT=$GREEN
export COLOR_PROJECT=$RED
export COLOR_DATE=$LIGHT_GREEN
# Force gawk to behave posixly. Comment out if you get an error about
# no such option -W.
# AWK_OPTIONS="-W posix"
if [ "$TODOTXT_PLAIN" -eq "0" ]; then
awk $AWK_OPTIONS '
function highlight(colorVar, color) {
@ginatrapani
ginatrapani / entries.md
Created March 29, 2012 14:49 — forked from samuelclay/entries.md
Top entries in Knight News Challenge 2012
language: php
php:
- 5.3
- 5.4
before_script:
- sudo apt-get install apache2
- sudo a2enmod actions
- sudo a2enmod rewrite

I'm writing in response to events that have recently come to light involving a sexual assault at a tech conference. Background information can be found [here][1], [here][2], and [here][3] as well as on twitter and google.


I've been watching this from the sidelines, and I've been wrestling with several questions that I can't seem to shake and that I really don't have answers to.

I wear many hats, both in the tech community and others. I'm a coder, a speaker, a user group organizer, a conference organizer, and even a boss. Each of those roles colors how I see this, but there's one role that is overpowering in my reaction.

See, I'm a Dad. A dad of two beautiful and innocent girls who are 3 and 2. They have their whole lives in front of them and so the questions I'm struggling with are:

@ginatrapani
ginatrapani / gist:11303222
Last active May 25, 2016 17:35
New insight issue template

One-liner

Describe what this insight is in a single sentence. This is the description that appears in ThinkUp's insights list, so phrase it like the others are. Current insights single sentences are:

  • Post activity spikes for the past 7, 30, and 365 days.
  • How often you referred to yourself ("I", "me", "myself", "my") in the past week.
  • How many more users a message has reached due to your reshare or retweet.

Full explainer