Skip to content

Instantly share code, notes, and snippets.

View selenamarie's full-sized avatar

Selena Deckelmann selenamarie

View GitHub Profile
@selenamarie
selenamarie / foo.pl
Created March 8, 2010 21:44 — forked from rbuels/foo.pl
my ($attr) = @$token[2];
next unless exists $attr->{rel};
chomp $attr->{rel};
my @rels = split ' ', $attr->{rel};
for my $rel (@rels) {
if( $rel && $rel eq "hub") {
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>GeoJSON to Google Maps</title>
<style type="text/css">
#left{
width: 100%;
height: 500px;
float:left;
}
@selenamarie
selenamarie / gist:3355230
Created August 15, 2012 02:51 — forked from garann/gist:3353532
Crowdsourced career mentorship for female developers

I was inspired by Selena Deckelmann's list of Career Resources for Women (http://www.chesnok.com/daily/career-resources-for-women/), but couldn't think of much to contribute. So I thought maybe those of us already in the field and in a position to mentor could work on creating more. Please fork or comment and add your own!

Applying for jobs

Interviewing

Professional behavior

@selenamarie
selenamarie / gist:5155906
Last active October 15, 2017 05:46 — forked from jallspaw/gist:5154620
Links to presentations about sharding
== PostgreSQL
Braintree
* https://www.braintreepayments.com/braintrust/scaling-postgresql-at-braintree-four-years-of-evolution
Instagram
* http://www.databasesoup.com/2012/04/sharding-postgres-with-instagram.html
* http://media.postgresql.org/sfpug/instagram_sfpug.pdf
* http://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-at-instagram#_=_
* http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram
WITH j_1 AS (
SELECT subject
FROM wb_v_latest_triples a
WHERE
a.predicate = 'type' AND a.obj_value = 'http://indx.ecs.soton.ac.uk/ontology/root-box/#server'
),
WITH j_2 AS (
SELECT subject
FROM wb_v_latest_triples a
WHERE
-- we should probably add an index on product_versions.sunset_date
-- addons
WITH crash AS (
SELECT json_array_elements(processed_crash->'addons') AS addons,
product_version_id,
signature_id,
reports_clean.date_processed::date,
reports_clean.os_name
FROM processed_crashes
-- this output is interesting :)
SELECT json_object_field_text(ucm.rewrite, 'rewrite_to') as release_channel,
json_array_elements(ucm.rewrite->'BuildID') as buildid, -- yeah this is not good here :D
product_versions.product_version_id,
trim(both '"' from (ucm.rewrite->'Version')::text) as version_string,
product_versions.version_string
FROM
product_productid_map ppm
JOIN update_channel_map ucm USING (productid)
JOIN product_versions ON ppm.product_name = product_versions.product_name