Kartones

PSQL

Magic words:

psql -U postgres

Some 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)

hayd

#!/usr/bin/env python
# -*- coding: utf-8 -*-

'''
Follow these steps to configure the webhook in Slack:

  1. Navigate to https://<your-team-domain>.slack.com/services/new

  2. Search for and select "Incoming WebHooks".

jkubecki

// The following data should be run in the console while viewing the page https://read.amazon.com/
// It will export a CSV file called "download" which can (and should) be renamed with a .csv extension

var db = openDatabase('K4W', '3', 'thedatabase', 1024 * 1024);

getAmazonCsv = function() {
  // Set header for CSV export line - change this if you change the fields used
  var csvData = "ASIN,Title,Authors,PurchaseDate\n";

  db.transaction(function(tx) {

ageitgey

Install dlib and face_recognition on a Raspberry Pi

Instructions tested with a Raspberry Pi 2 with an 8GB memory card. Probably also works fine on a Raspberry Pi 3.

Steps

Download the latest Raspbian Jessie Light image. Earlier versions of Raspbian won't work.

Write it to a memory card using Etcher, put the memory card in the RPi and boot it up.

chadmayfield

#!/bin/bash
git clone https://github.com/hashcat/hashcat.git
mkdir -p hashcat/deps
git clone https://github.com/KhronosGroup/OpenCL-Headers.git hashcat/deps/OpenCL
cd hashcat/ && make
./hashcat --version
./hashcat -b -D 1,2
./example0.sh

carlosedp

# Rock64 Install (Adjust IPs/Hostnames/DNS to your deployment)

Disable NetworkManager and DHCP Client

    sudo systemctl stop dhcpcd
    sudo systemctl stop NetworkManager
    sudo systemctl disable dhcpcd
    sudo systemctl disable NetworkManager
    sudo systemctl daemon-reload

GermaniumSystem

Preface:
I have no idea if any of this is the "right" way of doing it. This is just how I got my unit working.
Good luck.

WARNING: Do not use a V1 Waveshare display module with a stock pwnagotchi! The pwnagotchi expects a V2 module, and may irreparably damage a V1 module!
A V1 display module *can* work, but you must modify `waveshare.py` and `display.py` beforehand. For the time being, this is left as an exercise for the reader.
If you have already burnt a V1 display, try disconnecting it from the Pi and leaving it overnight. This may rejuvenate the display somewhat, but it will likely still display signs of damage.

Installation:
1. `dd` Raspbian Lite to an SD card.

sbyx

blueprint:
  name: Low battery level detection & notification for all battery sensors
  description: Regularly test all sensors with 'battery' device-class for crossing
    a certain battery level threshold and if so execute an action.
  domain: automation
  input:
    threshold:
      name: Battery warning level threshold
      description: Battery sensors below threshold are assumed to be low-battery (as
        well as binary battery sensors with value 'on').