Skip to content

Instantly share code, notes, and snippets.

Example of current searchClientsByAttributes in main, for a particular client attribute value, providing increasing offset values.

explain analyze select ce1_0.ID
   from CLIENT ce1_0
   join CLIENT_ATTRIBUTES a1_0
     on ce1_0.ID=a1_0.CLIENT_ID
  where ce1_0.REALM_ID='redacted'
    and a1_0.NAME='redacted'
    and substr(a1_0.VALUE,1,255)=substr('true',1,255)
@patrickjennings
patrickjennings / nvfanctl.sh
Created October 14, 2017 07:34
Bash script to control the fan of an NVIDIA GPU.
#!/bin/bash
# Requirements:
# Coolbits bit 2 to enable fan control.
# Dependencies:
# GNU BC: https://www.gnu.org/software/bc/
sleep_time="5s"
# On close, set fan speed back to automatic mode.
@patrickjennings
patrickjennings / pacup.sh
Created January 8, 2017 01:52
Backup utility for pacman
#!/bin/bash
# Creates a backup of modified files originally installed by pacman as well as
# a list of all installed packages through pacman.
# Usage: ./pacup.sh [OPTION] [ARCHIVE]
# Options:
# -t Only print the files which will be included in the backup. Can be used to
# build a blacklist file.
# Notes:
### Keybase proof
I hereby claim:
* I am patrickjennings on github.
* I am patrickjennings (https://keybase.io/patrickjennings) on keybase.
* I have a public key ASDUDCwI_ygXrVjuVrAW6y1FAZj4fSadJSa1LP5XnLWfrwo
To claim this, I am signing this object: