onedr0p

select setval('public."AutoTagging_Id_seq"', (SELECT MAX("Id")+1 FROM "AutoTagging"));
select setval('public."Commands_Id_seq"', (SELECT MAX("Id")+1 FROM "Commands"));
select setval('public."Config_Id_seq"', (SELECT MAX("Id")+1 FROM "Config"));
select setval('public."CustomFilters_Id_seq"', (SELECT MAX("Id")+1 FROM "CustomFilters"));
select setval('public."CustomFormats_Id_seq"', (SELECT MAX("Id")+1 FROM "CustomFormats"));
select setval('public."DelayProfiles_Id_seq"', (SELECT MAX("Id")+1 FROM "DelayProfiles"));
select setval('public."DownloadClientStatus_Id_seq"', (SELECT MAX("Id")+1 FROM "DownloadClientStatus"));
select setval('public."DownloadClients_Id_seq"', (SELECT MAX("Id")+1 FROM "DownloadClients"));
select setval('public."DownloadHistory_Id_seq"', (SELECT MAX("Id")+1 FROM "DownloadHistory"));
select setval('public."EpisodeFiles_Id_seq"', (SELECT MAX("Id")+1 FROM "EpisodeFiles"));

Roxedus

So you hate SQLite

This document will go over the key items for migrating and setting up Postgres support in Prowlarr.

Creation of initial database

We do this also when migrating, this is to ensure Prowlarr sets up the required schema.

Setting up Postgres

AlexanderMakarov

#!/usr/bin/env python3
import os
import bencode
import re
import sys

# Inspired by https://github.com/ctminime/QB_Migrate_to_Linux
# Need `pip3 install bencode.py`.
# Run in folder like "/home/user/.local/share/data/qBittorrent/BT_backup/" (configured in qBitTorrent).
# Takes 2 parameters:

hjbotha

#! /bin/bash

# NEWLY ADDED BACKUP FUNCTIONALITY IS NOT FULLY TESTED YET, USE WITH CARE, ESPECIALLY DELETION
# Developed for DSM 6 - 7.0.1. Not tested on other versions.
# Steps to install
# Save this script in one of your shares
# Edit it according to your requirements
# Backup /usr/syno/share/nginx/ as follows:
# # cd /usr/syno/share/
# # tar cvf ~/nginx.tar nginx

gboudreau

Generating Authy passwords on other authenticators

---

*update: TBC, but this new might affect how easy it is to use this technique past August 2024: Authy is shutting down its desktop app | The 2FA app Authy will only be available on Android and iOS starting in August

---

This gist, based in part on a gist by Brian Hartvigsen, allows you to export from Authy your TOTP tokens you have stored there.
Those can be "standard" 6-digits / 30 secs tokens, or Authy's own version, the 7-digits / 10 secs tokens.

nrdmn

#!/usr/bin/python3
# reads a list of IP subnets in CIDR notation from stdin and collapses it

import sys
import ipaddress

subnets6 = []
subnets4 = []

input_list = sys.stdin.readlines()

7596ff

import urllib
import json
import string
import sys
import ConfigParser
import tweepy

def craftTweet(match_id, level, hero, kills, deaths, assists):
    unformatted = 'Just played a match: Hero: Lvl. {} {} K/D/A: {}/{}/{}\nDotabuff: {}'

denji

• https://gitlab.com/qratorlabs/plag
• https://github.com/job/aggregate6
• https://github.com/flowchartsman/cidr-convert
• https://github.com/mhausenblas/cidrchk
• https://github.com/houqp/vpcstudio
• https://github.com/projectdiscovery/mapcidr
• https://github.com/FvDxxx/pfxaggr
• https://github.com/yl2chen/cidranger
• https://github.com/Kentik/patricia
• https://github.com/bgp/bgpq4

jasonrudolph

# Credit http://stackoverflow.com/a/2514279
for branch in `git branch -r | grep -v HEAD`;do echo -e `git show --format="%ci %cr" $branch | head -n 1` \\t$branch; done | sort -r