Vishes vishes-shell

Changing Postgres' `log_min_duration_statement` setting on the fly

Check the setting:

SELECT * FROM pg_settings WHERE name = 'log_min_duration_statement';

Change the setting:

SET log_min_duration_statement TO 1000; >

Hyperlinks (a.k.a. HTML-like anchors) in terminal emulators

[ Update 2025-03-24: Commenting is disabled permanently. Previous comments are archived at web.archive.org. ]

Most of the terminal emulators auto-detect when a URL appears onscreen and allow to conveniently open them (e.g. via Ctrl+click or Cmd+click, or the right click menu).

It was, however, not possible until now for arbitrary text to point to URLs, just as on webpages.

How to recover lost Python source code if it's still resident in-memory

I screwed up using git ("git checkout --" on the wrong file) and managed to delete the code I had just written... but it was still running in a process in a docker container. Here's how I got it back, using https://pypi.python.org/pypi/pyrasite/ and https://pypi.python.org/pypi/uncompyle6

Attach a shell to the docker container

Install GDB (needed by pyrasite)

apt-get update && apt-get install gdb

Про токены, JSON Web Tokens (JWT), аутентификацию и авторизацию. Token-Based Authentication

Last major update: 25.08.2020

Что такое авторизация/аутентификация
Где хранить токены
Как ставить куки ?
Процесс логина
Процесс рефреш токенов
Кража токенов/Механизм контроля токенов

Introduction

C-a == Ctrl-a
M-a == Alt-a

General

:q        close
:w        write/saves
:wa[!]    write/save all windows [force]
:wq       write/save and close

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

	// ==UserScript==
	// @name Jira Issue Copy Button
	// @namespace http://tampermonkey.net/
	// @version 0.1
	// @description Add a copy button on the tickets so we can Copy ticket number and summary with just one click to share somewhere else
	// @author Sam Bossen
	// @match https://jira.audible.com/*
	// @grant none
	// ==/UserScript==

	#!/usr/bin/python3

	"""Runs autoflake on commit. Blocks commit and requests adding changed files
	if autoflake fires.

	Installation
	------------
	1. You will need to install autoflake: https://pypi.org/project/autoflake/
	$ pip install --upgrade autoflake
	or

	@startuml
	' uncomment the line below if you're using computer with a retina display
	' skinparam dpi 300
	!define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
	' we use bold for primary key
	' green color for unique
	' and underscore for not_null
	!define primary_key(x) <b>x</b>
	!define unique(x) <color:green>x</color>
	!define not_null(x) <u>x</u>

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