Daniel Serodio dserodio

## nrql.sql
-- Query APM agent version
SELECT agentHostname, apmAgentVersion, apmAppName, apmLanguage
  FROM NrDailyUsage
 WHERE apmLanguage IS NOT NULL
 SINCE 1 day ago
 LIMIT MAX

## parseDuration.gs
/* Based on: https://stackoverflow.com/a/44018490/31493 */

var duration = /(-?\d*\.?\d+(?:e[-+]?\d+)?)\s*([a-zμ]*)/ig

/**
 * conversion ratios
 */


## userChrome.css
/*
 * Bookmarks toolbar is visible only on new tab page, just like Chrome.
 *
 * Screenshot: https://vimeo.com/235059188
 * Video: https://vimeo.com/240436456
 *
 * Contributor(s): https://www.reddit.com/user/AJtfM7zT4tJdaZsm and Andrei Cristian Petcu
 *                 https://www.reddit.com/r/FirefoxCSS/comments/7evwow/show_bookmarks_toolbar_only_on_new_tab/
 */

## ublock-filters.txt
!Source: https://www.reddit.com/r/brasil/comments/93zlgh/e_reclamam_do_adblock/e3ikvb9/
!
!Desabilitar notificações
||onesignal.com^
||pushcrew.com^
||widget.intercom.io^
||pushnews.eu^

! Block Pushnews (heavily abused by Exame, and other Brazilian media sites)
/pushnews-sw.js

## psql_check_ssl.sql
SELECT s.pid, s.ssl, s.version, a.client_addr, a.usename, a.datname, a.query
  FROM pg_stat_ssl AS s
  JOIN pg_stat_activity AS a ON a.pid = s.pid;

-- You can see `t|f` in `ssl` field

## toggle_zero_columns.gs
/*
 * Usage: Tools > Script Editor
 *        replace all code with below
 *        Click Run
 *
 * Source: https://stackoverflow.com/a/13591754/31493
 */

function onOpen() {
  // get active spreadsheet

## test-psql-connectivity.sh
while true; do
  date -Isec | sed -e 's/+00:00//' | tr '\n' ' '
  pg_isready -h YOUR_RDS_INSTANCE.rds.amazonaws.com -U USER -d DB_NAME
  sleep 1
done | tee connection-test-$(date -Imin).log

## rename_lambda_tags.py
"""Replace 'name' tag with 'Name' and 'application' with 'Application'
"""

import boto3


def uppercaseTagKeys(arn, name, application=None):
    tags = {}
    if name:
        tags['Name'] = name

## Dockerfile
# Dockerfile for a multi-stage build of a Ruby app which needs Node at build time
#
# Thanks to https://github.com/gomex for sharing

FROM ruby:2.5.1 as builder

RUN curl -sL https://deb.nodesource.com/setup_8.x | bash - &&\
    curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add - &&\
    echo "deb https://dl.yarnpkg.com/debian/ stable main" | tee /etc/apt/sources.list.d/yarn.list

## say.sh
# gTTS (Google Text-to-Speech), a Python library and CLI tool to interface with Google Translate's text-to-speech API
# https://github.com/pndurette/gTTS

pipsi install gTTS
sudo apt install mpg123

say() {
  gtts-cli "$@" | mpg123 -
}
	-- Query APM agent version
	SELECT agentHostname, apmAgentVersion, apmAppName, apmLanguage
	FROM NrDailyUsage
	WHERE apmLanguage IS NOT NULL
	SINCE 1 day ago
	LIMIT MAX
	/* Based on: https://stackoverflow.com/a/44018490/31493 */

	var duration = /(-?\d\.?\d+(?:e[-+]?\d+)?)\s([a-zμ]*)/ig

	/**
	* conversion ratios
	*/
	/*
	* Bookmarks toolbar is visible only on new tab page, just like Chrome.
	*
	* Screenshot: https://vimeo.com/235059188
	* Video: https://vimeo.com/240436456
	*
	* Contributor(s): https://www.reddit.com/user/AJtfM7zT4tJdaZsm and Andrei Cristian Petcu
	* https://www.reddit.com/r/FirefoxCSS/comments/7evwow/show_bookmarks_toolbar_only_on_new_tab/
	*/
	!Source: https://www.reddit.com/r/brasil/comments/93zlgh/e_reclamam_do_adblock/e3ikvb9/
	!
	!Desabilitar notificações
	\|\|onesignal.com^
	\|\|pushcrew.com^
	\|\|widget.intercom.io^
	\|\|pushnews.eu^

	! Block Pushnews (heavily abused by Exame, and other Brazilian media sites)
	/pushnews-sw.js
	SELECT s.pid, s.ssl, s.version, a.client_addr, a.usename, a.datname, a.query
	FROM pg_stat_ssl AS s
	JOIN pg_stat_activity AS a ON a.pid = s.pid;

	-- You can see `t\|f` in `ssl` field
	/*
	* Usage: Tools > Script Editor
	* replace all code with below
	* Click Run
	*
	* Source: https://stackoverflow.com/a/13591754/31493
	*/

	function onOpen() {
	// get active spreadsheet
	while true; do
	date -Isec \| sed -e 's/+00:00//' \| tr '\n' ' '
	pg_isready -h YOUR_RDS_INSTANCE.rds.amazonaws.com -U USER -d DB_NAME
	sleep 1
	done \| tee connection-test-$(date -Imin).log
	"""Replace 'name' tag with 'Name' and 'application' with 'Application'
	"""

	import boto3


	def uppercaseTagKeys(arn, name, application=None):
	tags = {}
	if name:
	tags['Name'] = name
	# Dockerfile for a multi-stage build of a Ruby app which needs Node at build time
	#
	# Thanks to https://github.com/gomex for sharing

	FROM ruby:2.5.1 as builder

	RUN curl -sL https://deb.nodesource.com/setup_8.x \| bash - &&\
	curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg \| apt-key add - &&\
	echo "deb https://dl.yarnpkg.com/debian/ stable main" \| tee /etc/apt/sources.list.d/yarn.list
	# gTTS (Google Text-to-Speech), a Python library and CLI tool to interface with Google Translate's text-to-speech API
	# https://github.com/pndurette/gTTS

	pipsi install gTTS
	sudo apt install mpg123

	say() {
	gtts-cli "$@" \| mpg123 -
	}