View pagination_example.sql
-- Reasonably efficient pagination without OFFSET
-- SQLite version (Adapted from MS SQL syntax)
-- Source: http://www.phpbuilder.com/board/showpost.php?p=10376515&postcount=6
SELECT foo, bar, baz, quux FROM table
WHERE oid NOT IN ( SELECT oid FROM table
ORDER BY title ASC LIMIT 50 )
ORDER BY title ASC LIMIT 10
View firefox_migration.rst

Disaster Plans for Firefox XUL Sunset

Public URL:Github Gist
Status: Incomplete
Last Updated:2017-06-01 05:08 EDT

Threat Summary

View boilerplate.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""[application description here]"""
__appname__ = "[application name here]"
__author__ = "Stephan Sokolow (deitarion/SSokolow)"
__version__ = "0.0pre0"
__license__ = "GNU GPL 3.0 or later"
import logging
View transmission_vpn.py
#!/usr/bin/env python
"""Simple wrapper to update Transmission's IPv4 binding on startup for use with VPNs.
(For Linux systems. Tested on Ubuntu 14.04 LTS)
"""
import json, os, subprocess
VPN_IF = "tun0"
TRANSMISSION_CFG = os.path.expanduser('~/.config/transmission/settings.json')
View partial_shell_parser.py
import shlex
def lex_shellscript(script_path, statement_cb):
"""Given a file-like object, use a POSIX-mode shlex.shlex object to split
it into statements and call the given statement processor to convert
statements into dicts.
"""
fields = {}
with open(script_path, 'r') as fobj:
View x11_watch_active_window.py
#!/usr/bin/env python
"""python-xlib example which reacts to changing the active window/title.
Requires:
- Python
- python-xlib
Tested with Python 2.x because my Kubuntu 14.04 doesn't come with python-xlib
for Python 3.x.
View restarted_since.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""Check if all processes matching a name were started after a config
file's mtime.
--snip--
Tested under Python 2.7 and 3.4
"""
View sftpget.bat
@echo off
REM Usage:
REM 1. Set up your DOS network and packet drivers
REM 2. Install sftpd386.exe
REM 3. Edit the line which calls sftpd386.exe for path/credentials/IP address
REM 4. Run "sftpget file1 file2 file3 ..."
REM Write sftp script
(
@echo off
View add_edl_association.sh
#!/bin/sh
# Sources:
# - https://stackoverflow.com/questions/30931/register-file-extensions-mime-types-in-linux
# - https://www.freedesktop.org/wiki/Specifications/AddingMIMETutor/
echo "* Adding file-type icons..."
for SIZE in 16 32 64; do
echo "* Adding ${SIZE}px icon"
xdg-icon-resource install --context mimetypes --size "$SIZE" "/usr/share/icons/hicolor/${SIZE}x${SIZE}/apps/mpv.png" application-x-mpv-edl
done
View wakeme
#!/usr/bin/env python2
# -*- coding: utf-8 -*-
"""Wrapper script for scheduling an alarm within the desktop session so
MPV has access to the audio and video outputs.
See --help output for more details.
Requirements:
- python-dateutil
- pytimeparse