Alex Zaitsev azaitsev

IanColdwater / twittermute.txt

Last active October 25, 2025 19:14

Here are some terms to mute on Twitter to clean your timeline up a bit.

	Mute these words in your settings here: https://twitter.com/settings/muted_keywords

	ActivityTweet
	generic_activity_highlights
	generic_activity_momentsbreaking
	RankedOrganicTweet
	suggest_activity
	suggest_activity_feed
	suggest_activity_highlights
	suggest_activity_tweet

darklow / get-social-shares

Last active April 7, 2016 21:19 — forked from ihorvorotnov/get-social-shares

rgreenjr / postgres_queries_and_commands.sql

Last active October 29, 2025 19:10

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%'

adamawolf / Apple_mobile_device_types.txt

Last active November 4, 2025 08:23

List of Apple's mobile device codes types a.k.a. machine ids (e.g. `iPhone1,1`, `Watch1,1`, etc.) and their matching product names

	Facebook*:
	https://api.facebook.com/method/links.getStats?urls=%%URL%%&format=json
	+ works, returns shares, likes, comments and total

	Twitter:
	http://urls.api.twitter.com/1/urls/count.json?url=%%URL%%&callback=twttr.receiveCount
	+ v1 API but still works

	Reddit:
	http://buttons.reddit.com/button_info.json?url=%%URL%%