Skip to content

Instantly share code, notes, and snippets.

View enockseth's full-sized avatar

Enock Seth Nyamador enockseth

View GitHub Profile
@enockseth
enockseth / postgres-cheatsheet.md
Created November 10, 2024 20:17 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

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)
@enockseth
enockseth / map.geojson
Created April 15, 2020 07:33
Yaoundé OCA AOI
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@enockseth
enockseth / map.geojson
Created April 15, 2020 06:55
Niamey OCA AOI
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@enockseth
enockseth / gist:140aaadb96011bb20e14a9c36c24546d
Created March 26, 2020 02:20 — forked from pitch-gist/gist:2999707
HTML: Simple Maintenance Page
<!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>
@enockseth
enockseth / arch-linux-install
Created December 18, 2019 08:39 — forked from mattiaslundberg/arch-linux-install
Minimal instructions for installing arch linux on an UEFI system with full system encryption using dm-crypt and luks
# 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
@enockseth
enockseth / map.geojson
Created March 1, 2019 00:28
2016 Accident Severity
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@enockseth
enockseth / latex-letter.tex
Created February 28, 2019 12:23 — forked from ashwin/latex-letter.tex
Simple letter template for LaTeX
%-----------------------------------------------------------------------------%
% Letter class
\documentclass[a4paper, 10pt]{letter}
% Name of sender
\name{Joe Fox}
% Signature of sender
\signature{Joe Fox}
@enockseth
enockseth / map.geojson
Created February 12, 2019 22:59
Accra OCA AOI - Alajo
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@enockseth
enockseth / map.geojson
Last active February 12, 2019 23:00
Accra OCA AOI - Akweteyman
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@enockseth
enockseth / map.geojson
Created February 4, 2019 18:31
Accra OCA AOI
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.