agopaul’s gists

levelsio / showFirstCellInGoogleSheetAsiOSWidget.js

Last active March 10, 2025 23:55

	// Modified from @mutsuda's https://medium.com/@mutsuda/create-an-ios-widget-showing-google-spreadsheets-data-856767a9447e
	// by @levelsio

	// HOW TO
	// 1) Make a Google Sheet, we'll pull the first cell e.g. A1
	// 2) Publish your Google Sheet, File -> Publish To Web
	// 3) Copy the SHEET_ID in the URL, put it in here below:
	const endpoint = "https://spreadsheets.google.com/feeds/cells/SHEET_ID/1/public/full?alt=json"
	// 4) Install Scriptable @ https://apps.apple.com/us/app/scriptable/id1405459188
	// 5) Copy this entire script in to Scriptable (tip: you can send it to your iPhone via Whatsapp/Messenger/Telegram etc)

arzzen / install-php7.2-mcrypt.sh

Last active July 27, 2025 14:48

Install PHP 7.2 / PHP 7.3 MCrypt extension (see https://lukasmestan.com/install-mcrypt-extension-in-php7-2/ )

	##
	## How to install mcrypt in php7.2 / php7.3
	## Linux / MacOS / OSX
	##

	## https://lukasmestan.com/install-mcrypt-extension-in-php7-2/



	#

oinopion / read-access.sql

Created October 5, 2016 13:00

How to create read only user in PostgreSQL

	-- Create a group
	CREATE ROLE readaccess;

	-- Grant access to existing tables
	GRANT USAGE ON SCHEMA public TO readaccess;
	GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

	-- Grant access to future tables
	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

learncodeacademy / webpack.config.js

Created January 8, 2016 03:55

Sample Basic Webpack Config

	var debug = process.env.NODE_ENV !== "production";
	var webpack = require('webpack');

	module.exports = {
	context: __dirname,
	devtool: debug ? "inline-sourcemap" : null,
	entry: "./js/scripts.js",
	output: {
	path: __dirname + "/js",
	filename: "scripts.min.js"

msikma / rfc5646-language-tags.js

Created February 26, 2015 13:51

RFC 5646 Language Tags

	// List of language tags according to RFC 5646.
	// See <http://tools.ietf.org/html/rfc5646> for info on how to parse
	// these language tags. Some duplicates have been removed.
	var RFC5646_LANGUAGE_TAGS = {
	'af': 'Afrikaans',
	'af-ZA': 'Afrikaans (South Africa)',
	'ar': 'Arabic',
	'ar-AE': 'Arabic (U.A.E.)',
	'ar-BH': 'Arabic (Bahrain)',
	'ar-DZ': 'Arabic (Algeria)',

rach / seach_conf_unaccented.sql

Created March 1, 2014 13:44

	CREATE TEXT SEARCH CONFIGURATION fr ( COPY = french );
	ALTER TEXT SEARCH CONFIGURATION fr ALTER MAPPING
	FOR hword, hword_part, word WITH unaccent, french_stem;

	CREATE TEXT SEARCH CONFIGURATION en ( COPY = english );
	ALTER TEXT SEARCH CONFIGURATION en ALTER MAPPING
	FOR hword, hword_part, word WITH unaccent, english_stem;

	CREATE TEXT SEARCH CONFIGURATION de ( COPY = german );
	ALTER TEXT SEARCH CONFIGURATION de ALTER MAPPING

diogomonica / urbanspoon_reservations.rb

Created July 25, 2013 04:32

	require 'rubygems'
	require 'mechanize'

	FIRST_NAME = 'FIRST_NAME'
	LAST_NAME = 'LAST_NAME'
	PHONE = 'PHONE'
	EMAIL = '[email protected]'

	PARTY_SIZE = 2
	SCHEDULE_RANGE = { :start_time => '19:00', :end_time => '20:30' }

adamloving / temporary-email-address-domains

Last active December 10, 2025 15:36

A list of domains for disposable and temporary email addresses. Useful for filtering your email list to increase open rates (sending email to these domains likely will not be opened).

	0-mail.com
	0815.ru
	0clickemail.com
	0wnd.net
	0wnd.org
	10minutemail.com
	20minutemail.com
	2prong.com
	30minutemail.com
	3d-painting.com

bazilio91 / gist:3910116

Created October 18, 2012 06:00

PhpUnit image assert function

	protected function assertImage($expected, $actual, $message = '')
	{
	$descriptors = array(
	array('pipe', 'r'),
	array('pipe', 'w'),
	array('pipe', 'w'),
	);
	$command = 'compare -metric RMSE ' . escapeshellarg($expected) . ' ' . escapeshellarg($actual) . ' /dev/null';
	$proc = proc_open($command, $descriptors, $pipes);

rgreenjr / postgres_queries_and_commands.sql

Last active December 5, 2025 09:56

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

Paolo Agostinetto agopaul