Jasur Yusupov jzr-supove

Falsehoods programmers believe about time

This is a compiled list of falsehoods programmers tend to believe about working with time.

Don't re-invent a date time library yourself. If you think you understand everything about time, you're probably doing it wrong.

Falsehoods

There are always 24 hours in a day.
February is always 28 days long.
Any 24-hour period will always begin and end in the same day (or week, or month).

`vs` Questions

http://stackoverflow.com/questions/804115 (rebase vs merge).
https://www.atlassian.com/git/tutorials/merging-vs-rebasing (rebase vs merge)
https://www.atlassian.com/git/tutorials/undoing-changes/ (reset vs checkout vs revert)
http://stackoverflow.com/questions/2221658 (HEAD^ vs HEAD~) (See git rev-parse)
http://stackoverflow.com/questions/292357 (pull vs fetch)
http://stackoverflow.com/questions/39651 (stash vs branch)
http://stackoverflow.com/questions/8358035 (reset vs checkout vs revert)

How to add a collapsible section in markdown

1. Example

Click me

Heading

Foo
Bar
- Baz

Qux

collapsible markdown?

CLICK ME

yes, even hidden code blocks!

print("hello world!")

psql: FATAL: Peer authentication failed for user “postgres” (or any user)

The connection failed because by default psql connects over UNIX sockets using peer authentication, that requires the current UNIX user to have the same user name as psql. So you will have to create the UNIX user postgres and then login as postgres or use sudo -u postgres psql database-name for accessing the database (and psql should not ask for a password).

If you cannot or do not want to create the UNIX user, like if you just want to connect to your database for ad hoc queries, forcing a socket connection using psql --host=localhost --dbname=database-name --username=postgres (as pointed out by @meyerson answer) will solve your immediate problem.

But if you intend to force password authentication over Unix sockets instead of the peer method, try changing the following pg_hba.conf* line:

from

Aligning images

This is a guide for aligning images.

See the full Advanced Markdown doc for more tips and tricks

`left` alignment

Pushing to Multiple Git Repos

If a project has to have multiple git repos (e.g. Bitbucket and Github) then it's better that they remain in sync.

Usually this would involve pushing each branch to each repo in turn, but actually Git allows pushing to multiple repos in one go.

If in doubt about what git is doing when you run these commands, just

	#!/bin/sh

	# Credits: http://stackoverflow.com/a/750191

	git filter-branch -f --env-filter "
	GIT_AUTHOR_NAME='Newname'
	GIT_AUTHOR_EMAIL='new@email'
	GIT_COMMITTER_NAME='Newname'
	GIT_COMMITTER_EMAIL='new@email'
	" HEAD


	Steps to Install Oracle Instant client and cx_Oracle on Fedora/CentOS/RHEL

	1) Download Instant client from oracle website
	http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
	e.g. for Linux 86_64
	http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
	Download

	1) oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm