Skip to content

Instantly share code, notes, and snippets.

View kawells's full-sized avatar
👨‍💻
Lost in the sauce code

Kevin Wells kawells

👨‍💻
Lost in the sauce code
  • Parker Hannifin
  • Oxnard, CA
View GitHub Profile
@Deathproof76
Deathproof76 / plexdb_healthcheck.sh
Last active March 26, 2025 16:24
Crontab restart/repair script for Plex "Sqlite3: Sleeping for 200ms to retry busy DB"
#!/bin/bash
# Plex busy DB workaround
# Set the maximum number of allowed occurrences of the Sqlite3: Sleeping for 200ms to retry busy DB string
# about 3 times usually indicates an instance that can't recover by itself
# if your instance restarts your docker logs should reset, or "cover up" the busy DB lines, afaik
MAX_OCCURRENCES=3
# this part "docker logs --tail 10 plex" "--tail 10" means the last ten lines of the container logs
# of the container named "plex", change the name according to your setup
@kuyazee
kuyazee / google-sheets-colour-preview.js
Created September 20, 2018 07:38 — forked from Pathoschild/google-sheets-color-preview.js
A Google Sheets script which adds colour preview to cells. When you edit a cell containing a valid CSS hexadecimal colour code (like #000 or #000000), the background colour will be changed to that colour and the font colour will be changed to the inverse colour for readability.
/*
This script is meant to be used with a Google Sheets spreadsheet. When you edit a cell containing a
valid CSS hexadecimal colour code (like #000 or #000000), the background colour will be changed to
that colour and the font colour will be changed to the inverse colour for readability.
To use this script in a Google Sheets spreadsheet:
1. go to Tools » Script Editor » Spreadsheet;
2. erase everything in the text editor;
3. change the title to "Set colour preview on edit";
@JonnyWong16
JonnyWong16 / update_all_metadata.py
Last active June 27, 2025 03:41
Updates all metadata in the Tautulli database after moving Plex libraries.
#!/usr/bin/env python
# -*- coding: utf-8 -*-
#
# Description: Updates all metadata in the Tautulli database after moving Plex libraries.
# Author: /u/SwiftPanda16
# Requires: plexapi, requests
from plexapi.server import PlexServer
import requests