Magic words:
psql -U postgresSome interesting flags (to see all, use -h or --help depending on your psql version):
-E: will describe the underlaying queries of the \ commands (cool for learning!)-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
| <!doctype html> | |
| <title>Site Maintenance</title> | |
| <style> | |
| body { text-align: center; padding: 150px; } | |
| h1 { font-size: 50px; } | |
| body { font: 20px Helvetica, sans-serif; color: #333; } | |
| article { display: block; text-align: left; width: 650px; margin: 0 auto; } | |
| a { color: #dc8100; text-decoration: none; } | |
| a:hover { color: #333; text-decoration: none; } | |
| </style> |
| # Install ARCH Linux with encrypted file-system and UEFI | |
| # The official installation guide (https://wiki.archlinux.org/index.php/Installation_Guide) contains a more verbose description. | |
| # Download the archiso image from https://www.archlinux.org/ | |
| # Copy to a usb-drive | |
| dd if=archlinux.img of=/dev/sdX bs=16M && sync # on linux | |
| # Boot from the usb. If the usb fails to boot, make sure that secure boot is disabled in the BIOS configuration. | |
| # Set swedish keymap |
| %-----------------------------------------------------------------------------% | |
| % Letter class | |
| \documentclass[a4paper, 10pt]{letter} | |
| % Name of sender | |
| \name{Joe Fox} | |
| % Signature of sender | |
| \signature{Joe Fox} |
| sudo pacman -S ruby | |
| gem update --user-install | |
| gem install jekyll --user-install | |
| gem install jekyll-paginate --user-install | |
| gem install pygments.rb --user-install | |
| echo "export PATH=/home/bast/.gem/ruby/2.3.0/bin:\$PATH" >> ~/.localrc |
| #!/usr/bin/env python3 | |
| # This script is provided to show how I migrated from Ghost 0.4.2 | |
| # to Jekyll 2.3.0 and is used at your own risk. Back up your blog | |
| # before trying it out. | |
| def getPostTemplate(): | |
| with open('post-template.md', 'r') as f: | |
| posttemplate = f.read() | |
| f.closed |
##How to get started contributing to a Humanitarian OpenStreetMap Team task
###Overview
OpenStreetMap (OSM) is an open-source map of the world that anyone can edit. But like any map, it's incomplete.
The Humanitarian OpenStreetMap Team (HOT) helps organize people to improve the OSM map for crisis areas, mostly so aid workers can find their way around and make decisions about undermapped places. The data in these crisis areas is often very poor, or completely non-existent. Therefore any contribution you make at all will be a vast improvement, and could materially help people who are on the ground right now, looking at this data as you edit it, and deciding where to go and who to help.
There are many HOT tasks active at once. As of August 2014, the highest-priority tasks are Gaza and areas affected by the West African Ebola outbreak.