Nogas’s gists

Nogas / download_anonymous_icons_from_drive.rb

Created June 19, 2022 00:09 — forked from rockwotj/download_anonymous_icons_from_drive.rb

Downloads all of the icons of anonymous animals from Google Drive

	#!/usr/bin/env ruby

	icon_list = "alligator, anteater, armadillo, auroch, axolotl, badger, bat, beaver, buffalo, camel, chameleon, cheetah, chipmunk, chinchilla, chupacabra, cormorant, coyote, crow, dingo, dinosaur, dolphin, duck, dragon, elephant, ferret, fox, frog, giraffe, gopher, grizzly, hedgehog, hippo, hyena, jackal, ibex, ifrit, iguana, koala, kraken, lemur, leopard, liger, llama, manatee, mink, monkey, narwhal, nyan cat, orangutan, otter, panda, penguin, platypus, python, pumpkin, quagga, rabbit, raccoon, rhino, sheep, shrew, skunk, slow loris, squirrel, turtle, walrus, wolf, wolverine, wombat"

	for icon in icon_list.split ', ' do
	element = icon.sub ' ', ''
	`curl https://ssl.gstatic.com/docs/common/profile/#{element}_lg.png -o icons/#{element}.png`
	end

Nogas / send_email.php

Created March 22, 2021 16:46 — forked from davidnknight/send_email.php

PHP Send Mail (Plaintext and HTML)

	<?php
	/**
	* Send email
	* @param string\|array $email
	* @param object $from
	* @param string $subject
	* @param string $message
	* @param string $headers optional
	*/
	function send_email($email, $from, $subject, $message, $headers = null)

Nogas / appsScript_ListFilesFolders_ver.2.js

Created August 16, 2020 17:36 — forked from mesgarpour/appsScript_ListFilesFolders_ver.2.js

[Google Apps Script] List all files & folders in a Google Drive folder, & write into a speadsheet

	/*
	* Copyright 2017 Mohsen Mesgarpour
	*
	* Licensed under the Apache License, Version 2.0 (the "License");
	* you may not use this file except in compliance with the License.
	* You may obtain a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*
	* Unless required by applicable law or agreed to in writing, software

Nogas / postgres-cheatsheet.md

Created April 1, 2020 16:50 — forked from Kartones/postgres-cheatsheet.md

PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Nogas / psql_useful_stat_queries.sql

Created October 24, 2019 15:07 — forked from anvk/psql_useful_stat_queries.sql

List of some useful Stat Queries for PSQL

	--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
	--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192

	-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.

	------------
	-- Basics --
	------------

	-- Get indexes of tables