Skip to content

Instantly share code, notes, and snippets.

View ThomasTJdev's full-sized avatar

Thomas T. Jarløv ThomasTJdev

137 followers · 27 following
View GitHub Profile
@ThomasTJdev
ThomasTJdev / postgres_queries_and_commands.md
Last active November 16, 2022 09:30 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands

Postgres help

Active connections

SELECT * FROM pg_stat_activity;

SELECT pg_terminate_backend(pid)
    FROM pg_stat_activity
@ThomasTJdev
ThomasTJdev / chromium_self-signed_ssl.md
Last active May 13, 2021 08:35
Chromium accept self-signed SSL certificate

Make Chromium accept self-signed certificates on localhost server.

  • Arch
  • Nginx
# Navigate to folder
cd /etc/nginx/ssl

# Become a Certificate Authority
@ThomasTJdev
ThomasTJdev / nimPNG debug base64
Created September 25, 2020 08:26
nimpng-debug.nim
import base64, streams
import nimPNG
const b = """iVBORw0KGgoAAAANSUhEUgAAAXIAAAHtCAYAAAAEFPWfAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAABcqADAAQAAAABAAAB7QAAAAAHJkeTAABAAElEQVR4AUS92XJjWZamt0mABAlwJjjPk9OniIwhszNVVV1VbS2ZabiRSX0pM11KDyDTdb+BnkPXMtNFm6lbnfMcER4+cp4ngDNIECAJ6vsW0kus9HIPd+CcffZe61//+tfa+7T8X//n//F0X39M5bOrdH1VTZn29vT48Jj86evpSfmOXGo0HlKtVk+1ur/uU09Pd3p8fEgHu0dp7dNm2t7aSU9PKT02GokPp2KxK/3bf/v3aX55PtX43M1tLZVKZ6m9rS21t7elyemJ1JnvTLc3ldS4f0jV6+tUr9bSzU011bnEcek87R4cpqVnS2lyYizdVW9S7e4+7R0cp9LZOdcfSIVCIbVnM2lgoC/18uv46CStbWzzb8XU19eT2rKtqb+nN52fnaWJyYk0NDzIM1S5f46xP6bz83N+b6RMpo1neky3t7epg2dta8vyCE/p4uwinZ+eptGh3lQ+PEh/+tOP6ezshudsSY2nBr/zwKmR5hanUnGoPxW6C6mnty/d8Czt7dnU092ZFhbm0tXldapWq2l4bDgdHR2njs6ulG1rTz98/2NaXFpIPV15rvWYLi8vuX8hjY3PpD//5a+pNT2l4+PjlGlpSYuLs2liYoTvl9L7j+sxnw+MvZPxTk1MpLubu7T6aY35u43n78jnUl9/T7q/u03V26vUkWtNi/MzaWR4IN3dVdP9PWvYzdxcXKaT45PUPziY2nLtqcD9b6+uUxtrMME8Nu6u0/BQX7pnPrKdhXT91JquavfpDvt45M+ra1uMbT4Njwym1OJcZlJifq64xtXVZ
@ThomasTJdev
ThomasTJdev / how-to-copy-aws-rds-to-local.md
Created August 15, 2019 10:13 — forked from syafiqfaiz/how-to-copy-aws-rds-to-local.md
How to copy production database on AWS RDS(postgresql) to local development database.
  1. Change your database RDS instance security group to allow your machine to access it.
    • Add your ip to the security group to acces the instance via Postgres.
  2. Make a copy of the database using pg_dump
    • $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
    • you will be asked for postgressql password.
    • a dump file(.sql) will be created
  3. Restore that dump file to your local database.
    • but you might need to drop the database and create it first
    • $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>
  • the database is restored
@ThomasTJdev
ThomasTJdev / install.sh
Created April 19, 2019 14:29
NimHA install script
#!/usr/bin/env bash
# INSPIRED BY PIHOLE. PLEASE SEE PIHOLE LICENSE FOR USE.
# Pi-hole: A black hole for Internet advertisements
# (c) 2017-2018 Pi-hole, LLC (https://pi-hole.net)
#
# PIHOLE FILE CAN BE FOUND AT https://install.pi-hole.net
#
# THIS FILE IS NOT PUBLIC DOMAIN AND MAY NOT BE USED.
# THIS IS A PRIVATE DEVELOPMENT FILE.
@ThomasTJdev
ThomasTJdev / install.sh
Last active April 13, 2019 08:53
NimWC install.sh
#!/usr/bin/env bash
# INSPIRED BY PIHOLE. PLEASE SEE PIHOLE LICENSE FOR USE.
# Pi-hole: A black hole for Internet advertisements
# (c) 2017-2018 Pi-hole, LLC (https://pi-hole.net)
#
# PIHOLE FILE CAN BE FOUND AT https://install.pi-hole.net
#
# THIS FILE IS NOT PUBLIC DOMAIN AND MAY NOT BE USED.
# THIS IS A PRIVATE DEVELOPMENT FILE.
@ThomasTJdev
ThomasTJdev / AWS EC2 work.md
Last active March 2, 2019 06:41

Resize filesystem (extend partition)

Example:

  • Starting: 8GB
  • Goal: 12GB
  • Partition name: xdva

Update volume size

  1. Go to EC2 Dashboard
  2. Select EBS Volumes
@ThomasTJdev
ThomasTJdev / JS stuff
Created December 24, 2018 08:46
/*
Custom date
_____________________*/
$(function () {
formatDate("epochToDateHourInit", "YYYY-MM-DD HH:mm", false);
formatDate("epochToDateShortInit", "DD MMM", false);
formatDate("epochToDateExcelInit", "YYYY-MM-DD", false);
formatDate("epochToDateInit", "YYYY MMM DD", true);
});
@ThomasTJdev
ThomasTJdev / summernote-ext-checkbox.js
Last active October 30, 2018 19:10 — forked from onesimoh/summernote-ext-checkbox.js
Summernote 0.8.10 plugin for checkbox using Bootstrap 4 with Font Awesome 4
(function (factory) {
/* global define */
if (typeof define === 'function' && define.amd) {
// AMD. Register as an anonymous module.
define(['jquery'], factory);
} else if (typeof module === 'object' && module.exports) {
// Node/CommonJS
module.exports = factory(require('jquery'));
} else {
// Browser globals
@ThomasTJdev
ThomasTJdev / GIT commands.md
Last active January 4, 2024 14:33
GIT commands

Fix last commit message

Made a typo or wrong description in a commit message? Run and edit:

git commit --amend

Add a file to latest commit

git commit --amend --reuse-message HEAD
#or