Magic words:
psql -U postgres
If run with -E
flag, it will describe the underlaying queries of the \
commands (cool for learning!).
Most \d
commands support additional param of __schema__.name__
and accept wildcards like *.*
#!/bin/bash | |
# This bash script copies pictures from Mapillary folders stored on an iPhone | |
# then update the pictures EXIF data to get the GPS and timestamp | |
# written by Christian Quest - August 2016 | |
# requires jq and exiftool, if missing: apt install jq exiftool | |
# tested on Ubuntu 16.04 | |
# copy Mapillary internal json data (contains GPS info, and more) | |
rsync /run/user/1000/gvfs/afc*/com.mapillary.app/cameras/internal/ internal -a |
import nltk | |
import pandas as pd | |
import re | |
import pprint | |
import operator | |
import csv | |
import logging | |
from stop_words import get_stop_words | |
from collections import defaultdict | |
from gensim import corpora |
#!/bin/bash | |
fileA="$1" | |
shift | |
for fileB in "$@"; do | |
( | |
# diff once grep twice with the help of tee and stderr | |
diff $fileA $fileB | \ | |
tee >(grep -cE '^< ' >&2) | \ | |
grep -cE '^> ' >&2 |
This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
- name: DO | |
hosts: localhost | |
vars: | |
project_name: "PUT A NAME FOR YOUR PROJECT HERE" | |
do_token: "PUT YOUR DIGITAL OCEAN API KEY HERE ==> https://cloud.digitalocean.com/settings/api/tokens" | |
repository: "PUT YOUR REPOSITORY URL HERE" | |
- name: NODE | Clone/Pull repo | |
git: | |
repo: "{{repository}}" |