SQLite3 Regex

sudo apt install sqlite3-pcre

sqlite3 /data/DBases/2022-01-housetemps.db -cmd ".load /usr/lib/sqlite3/pcre.so" "SELECT bed,downstairs,InsertedDatetime FROM housetemps WHERE InsertedDatetime REGEXP '\d\d\d\d-\d\d-1[4,5]';"

Popular posts from this blog

Opensuse Leap to Tumbleweed

 Edit /etc/sysconfig/proxy. zypper up zypper lr zypper mr -d repo-backports-update zypper mr -d repo-sle-update zypper lr mkdir /etc/zypp/repos.d/old mv /etc/zypp/repos.d/*.repo* /etc/zypp/repos.d/old zypper ar -f -c http://download.opensuse.org/tumbleweed/repo/oss repo-oss zypper ar -f -c http://download.opensuse.org/tumbleweed/repo/non-oss repo-non-oss zypper ar -f -c http://download.opensuse.org/tumbleweed/repo/debug repo-debug zypper ar -f -c http://download.opensuse.org/update/tumbleweed/ repo-update reboot to level 3. zypper cc -a && zypper ref && zypper dup --allow-vendor-change rpm --import https://dl.google.com/linux/linux_signing_key.pub zypper addrepo https://dl.google.com/linux/chrome/rpm/stable/x86_64 Google-Chrome zypper ref zypper install google-chrome-stable rpm --import https://packages.microsoft.com/keys/microsoft.asc zypper addrepo https://packages.microsoft.com/yumrepos/vscode vscode zypper ref zypper install code
Read more

MacOS VNC Screensaver fix

defaults write /Library/Preferences/com.apple.PowerManagement.{UID}.plist "AC Power" -dict-add "System Sleep Timer" 0 defaults write /Library/Preferences/com.apple.PowerManagement.{UID}.plist "AC Power" -dict-add "Display Sleep Timer" 0
Read more