Skip to content

Instantly share code, notes, and snippets.

View rtanglao's full-sized avatar
😃
you rock :-)

Roland Tanglao rtanglao

😃
you rock :-)
91 followers · 164 following
View GitHub Profile
@rtanglao
rtanglao / gist:64315cf92dde24f5cce1cd840026816e
Last active June 1, 2024 00:09
how-does-build-and-release-work.md

tl;dr: Release management (relman) picks patches to add to a build based on what developers have flagged for that build in bugzilla and additional patches that relman deems necessary for that build. Build engineers merge those patches to the appropriate branch for that build. If a merge fails for a patch, build engineers (buildeng) use 3 way merge tools to manually merge. If that fails buildeng asks the developer to fix the patch so it can be merged.

blah blah blah :-)
@rtanglao
rtanglao / unicode-sparkline.md
Last active December 11, 2023 08:44

min: 22.000000; max: 52.000000 ▇█▅█▄▁▃

@rtanglao
rtanglao / testable.md
Last active December 7, 2023 18:49
id           Title                                                                                                      O T M A U Tags
  1: [1432854](https://supp
@rtanglao
rtanglao / something.md
Last active November 21, 2023 05:40
testing markdown
@rtanglao
rtanglao / tooltiptest.md
Last active November 20, 2023 04:59
testing tool tips
@rtanglao
rtanglao / issue-3686-still-fails.md
Last active April 12, 2023 02:29

April 11, 2023: ./testAPI-issue-3686.rb issue 3686 still fails i.e. the time on the website is Pacific but the time returned from the API says Z i.e. UTC but is actually PST

./testAPI-issue-3686.rb 
{
                "answers" => [
        [ 0] 1222018,
        [ 1] 1222044,
        [ 2] 1222056,
@rtanglao
rtanglao / 2023-02-15-image-from-emoji.rb
Last active September 17, 2023 20:51
# convert pango:'a🤳Hello! 😀How are you?' example.png # Selfie emoji is Unicdode Hex 1F933
require 'rmagick'
image = Magick::Image.read('pango:&#x1F933;The <b>bold</b> and <i>beautiful</i>').first
image.write('pango.png')
@rtanglao
rtanglao / vancouver-accident-location-data-full-data.csv
Created May 11, 2022 17:36
Vancouver location data
We can't make this file beautiful and searchable because it's too large.
Location,Crash Type,Municipality,Year,Crash Count,Latitude,Longitude
GRANDVIEW HWY S & TEMPLETON DR,Property damage only,VANCOUVER,2017,1,49.25909,-123.060191
BOUNDARY RD & REGENT ST,Property damage only,VANCOUVER,2017,1,49.259109,-123.023633
VINE ST & W 14TH AVE,Property damage only,VANCOUVER,2017,1,49.259265,-123.157816
E 13TH AVE & WATSON ST,Property damage only,VANCOUVER,2017,1,49.259302,-123.100497
ASH ST & W 13TH AVE,Property damage only,VANCOUVER,2017,3,49.259493,-123.117658
MACDONALD ST & W 14TH AVE,Property damage only,VANCOUVER,2017,3,49.259579,-123.168318
BALACLAVA ST & W 14TH AVE,Property damage only,VANCOUVER,2017,1,49.259663,-123.174155
FIR ST & W 13TH AVE,Property damage only,VANCOUVER,2017,1,49.259853,-123.141183
E 12TH AVE & KINGSWAY & MILLTOWN PL,Property damage only,VANCOUVER,2017,44,49.259878,-123.096571
@rtanglao
rtanglao / query.sql
Last active March 29, 2022 18:23
get-county-by-date-2021-firefox-sumo-questions.db
SELECT strftime('%Y-%m-%d', created) AS yyyymmdd, count (*) as 'num_SUMO_questions'
FROM "2021-yearly-ff-questions-en-us"
WHERE created >= date('2021-01-01', 'localtime')
AND created < date('2022-01-01', 'localtime')
GROUP BY yyyymmdd
@rtanglao
rtanglao / how-to-change-3-trailing-spaces-2-trailing-spaces.sh
Created July 8, 2021 07:13
find . -name '*-test.md' -exec sed -i -e "s/\s\s\s$/ /g" {} \;