Kirill Salyamov ksalyamov

Изучения английского

Общяя информация:

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

Upgrade ibus to v1.5.x in Ubuntu 14.04

Install dependencies

sudo apt-get update -qq
sudo apt-get install -y gtk+-2.0 gtk+-3.0
sudo apt-get install -y libdconf-dev libnotify-dev
sudo apt-get install -y libdbus-1-dev

Importing and exporting CSV files with PostgreSQL

Let’s see how to use PostgreSQL to import and export CSV files painlessly with the COPY command.

Import CSV into table t_words:

COPY t_words FROM '/path/to/file.csv' DELIMITER ',' CSV;

You can tell quote char with QUOTE and change delimiter with DELIMITER.

How to Use Mercurial Bookmarks

Note: This document is specific to the FocusVision development environment, however it's mostly applicable elsewhere.

by Christopher Hiller

Mercurial branches are not "cheap". Unlike Git, to create or destroy a branch, you actually have to commit a changeset to the repository. Branches are great for…something…but whatever that is, we're not doing it.

Enter Bookmarks.

	#!/usr/bin/env python3
	"""
	Very simple HTTP server in python for logging requests
	Usage::
	./server.py [<port>]
	"""
	from http.server import BaseHTTPRequestHandler, HTTPServer
	import logging

	class S(BaseHTTPRequestHandler):

	Alt + Home = Navigation Bar
	Alt + Ctrl + Shift + N = Search by symbols
	Shift x2 = Last open files
	F11 = Add anonymous bookmark
	Ctrl + F11 = Add named bookmark
	Shift + F11 = View all bookmark
	Alt + Shift + F9 = Run debug
	Alt + F = Distraction Free Mode (Custom shortcut)
	Alt + Insert = Create New (class, module, file, etc)
	Ctrl + Shift + Space = Smart autocomplete

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'