opnchaudhary

wget https://github.com/sdepold/pHash/archive/master.zip
unzip master.zip
cd pHash-master
./configure --enable-video-hash=no --enable-audio-hash=no
make
make install
cd bindings/php
./configure --disable-video_hash --disable-audio_hash

unhammer

#!/bin/bash

set -e -u

wget -q http://packages.leonerd.org.uk/pool/main/x/xseticon/xseticon_0.1-0leo1_amd64.deb

mkdir tmp
dpkg -x xseticon_0.1-0leo1_amd64.deb tmp

mkdir -p ~/.local/bin

oinopion

-- Create a group
CREATE ROLE readaccess;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;