Skip to content

Instantly share code, notes, and snippets.

View LordEvron's full-sized avatar

Luke LordEvron

View GitHub Profile
@LordEvron
LordEvron / gist:efa0062dce18718a1680b1d81b7b3e44
Created September 1, 2021 09:19
Disable MASTER PASSWORD on PGADMIN 4.5 on Windows
Documentation on pgadmin is useless so they do not document where they store the config.py file,
making me lose 1 hour tring to find its location:
Here is the location of the config.py file in windows :
C:\Users\<YOURUSERNAME>\AppData\Local\Programs\pgAdmin 4\v5\web\config.py
Then change the MASTER_PASSWORD_REQUIRED to False.
Restart PGADMIN.
@LordEvron
LordEvron / purge_quassel_db-sqlite.sh
Created May 6, 2020 14:18 — forked from Und3rf10w/purge_quassel_db-sqlite.sh
Weekly purge of Quassel chat database for sqlite instances
#!/bin/sh
# Taken from http://blog.encomiabile.it/2011/02/03/prune-quassel-database/
BAK_PATH="${HOME}/.config/quassel-irc.org/quassel-storage.sqlite.bak"
CURRENT_PATH="${HOME}/.config/quassel-irc.org/quassel-storage.sqlite"
# first day of data that will be maintained
# -7 day means that *every* chatline stored before 8 days ago and so on are going to be eliminated.
# only the last 7 days are keeped.
DATE_TO_PRUNE='-7 day'