| -- 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 |
| -- 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 |
| 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 |
| == PostgreSQL | |
| Braintree | |
| * https://www.braintreepayments.com/braintrust/scaling-postgresql-at-braintree-four-years-of-evolution | |
| * 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 |
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!
| <!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; | |
| } |
| 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") { | |