Skip to content

Instantly share code, notes, and snippets.

View johngruen's full-sized avatar
😐
Status

John Gruen johngruen

😐
Status
View GitHub Profile
WITH dates_list AS (
Select *
FROM UNNEST(GENERATE_DATE_ARRAY('2020-01-01', CURRENT_DATE())) AS dates
),
usage_dates AS (
SELECT
EXTRACT(date from timestamp) AS date,
jsonPayload.fields.fxa_uid AS users
FROM
`moz-fx-guardian-prod-bfc7.log_storage.stdout`
Error: Could not establish connection. Receiving end does not exist. background.js:525:20
Warning processing windowTypes: This property is deprecated 4 global.min.js:250
makeError resource://gre/modules/Schemas.jsm:500
logDeprecation resource://gre/modules/Schemas.jsm:1196
checkDeprecated resource://gre/modules/Schemas.jsm:1208
normalizeBase resource://gre/modules/Schemas.jsm:1331
normalize resource://gre/modules/Schemas.jsm:2162
r resource://gre/modules/Schemas.jsm:1856
withPath resource://gre/modules/Schemas.jsm:585
checkProperty resource://gre/modules/Schemas.jsm:1855
{
"description": "Lorem Ipsum",
"manifest_version": 2,
"name": "data-uri-test-svg",
"version": "1.0",
"homepage_url": "https://example.com",
"theme": {
"images": {
{
"description": "Lorem Ipsum",
"manifest_version": 2,
"name": "data-uri-test-svg",
"version": "1.0",
"homepage_url": "https://example.com",
"theme": {
"images": {
{
"description": "Lorem Ipsum",
"manifest_version": 2,
"name": "data-uri-test-svg",
"version": "1.0",
"homepage_url": "https://example.com",
"theme": {
"images": {
{
"1519763971760-971": {
"theme": {
"colors": {
"toolbar": {
"h": 20,
"s": 93,
"l": 88,
"a": 100
},
@johngruen
johngruen / userChrome.css
Last active January 6, 2024 06:23
kill drag space
/*
Create a userChrome.css file by finding your Firefox profile,
making a directory called chrome and in it, a file called userChrome.css inside that.
Pasting this CSS and restarting Firefox will kill the left drag strip
*/
@namespace url("http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul");
.titlebar-placeholder[type="pre-tabs"] {
width: 2px !important;
<!--created by https://thenounproject.com/parmentiers.joseph/-->
<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1" x="0px" y="0px" viewBox="0 0 100 125" style="enable-background:new 0 0 100 100;" xml:space="preserve"><style type="text/css">
.st0{fill:none;stroke:#000000;stroke-width:2;stroke-miterlimit:10;}
</style><g><path d="M86.3,13.5L75.7,24.1C52.4,13.9,24.2,18.2,5.1,37.3l9,9c14-14,34.1-18.1,51.7-12.3L55.3,44.5c-11.4-1.6-23.4,2-32.2,10.8 l9,9c2.8-2.8,6-4.8,9.5-6L17,82.8l3.7,3.7l69.3-69.3L86.3,13.5z"/><path d="M42.4,72l-1.3,1.3l8.9,8.9l9-9C54.5,68.7,47.4,68.3,42.4,72z"/><path d="M56.7,57.7c4.1,1.1,8,3.3,11.2,6.5l9-9c-3.1-3.1-6.6-5.6-10.4-7.4L56.7,57.7z"/><path d="M85.1,29.3l-9.2,9.2c3.6,2.1,6.9,4.7,10,7.8l9-9C91.9,34.3,88.6,31.6,85.1,29.3z"/></g></svg>
<?xml version="1.0" encoding="utf-8"?>
<svg xmlns="http://www.w3.org/2000/svg"
xmlns:xlink="http://www.w3.org/1999/xlink"
width="16"
height="16"
viewBox="0 0 16 16">
<style>
path {
fill: #000;
}
@johngruen
johngruen / gist:34ced8ad051f964d72b60756ac9adadd
Last active April 29, 2016 12:15
Tab Center Metrics Draft

Tab Center Metrics

A summary of the metrics the Tab Center add-on will record.

Definitions:

  • Tab Center — The vertical tab tray on the right side of the browser.
  • Pin/Unpin Tab Center — Locking or unlocking the tab center UI to/from a fixed position.

Data collection