Artem Tiumentcev darland

darland / kill-all-connections-to-db.sql

Created April 15, 2021 10:45 — forked from jeffjohnson9046/kill-all-connections-to-db.sql

How to kill all connections to a Postgres database

	-- Accepted answer from here: https://stackoverflow.com/questions/5408156/how-to-drop-a-postgresql-database-if-there-are-active-connections-to-it
	SELECT pg_terminate_backend(pg_stat_activity.pid)
	FROM pg_stat_activity
	WHERE pg_stat_activity.datname = '[your database name goes here]'
	AND pid <> pg_backend_pid();

darland / bash-to-zsh-hist.py

Created August 20, 2020 02:57 — forked from muendelezaji/bash-to-zsh-hist.py

Convert Bash history to Zsh history

	#!/usr/bin/env python
	# -- coding: utf-8 --
	#
	# This is how I used it:
	# $ cat ~/.bash_history \| python bash-to-zsh-hist.py >> ~/.zsh_history

	import sys
	import time

darland / mic_mute_script.workflow

Created July 16, 2018 18:28 — forked from jframos/mic_mute_script.workflow

AppleScript - Microphone mute

	if input volume of (get volume settings) = 0 then
	set level to 90
	display notification "On" with title "Mic"
	tell application "System Events"
	tell appearance preferences
	set dark mode to false
	end tell
	end tell
	else
	set level to 0

darland / scaleway-virtualbox-module-build.sh

Created March 11, 2018 08:01 — forked from nictuku/scaleway-virtualbox-module-build.sh

	#!/bin/bash

	# Expects Ubuntu 16.06 (xenial) and kernel 4.x.
	# Based upon a blog post by Zach at http://zachzimm.com/blog/?p=191

	set -eux

	# Have the user call sudo early so the credentials is valid later on
	sudo whoami

darland / tmux-cheatsheet.markdown

Created May 11, 2017 11:42 — forked from MohamedAlaa/tmux-cheatsheet.markdown

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname