Matthew Lincoln mdlincoln
wcaleb
/ waybackup.py
Last active
December 29, 2020 06:55
Quick script to save URL to Wayback Machine
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #! /usr/bin/env python | |
| import sys, requests | |
| # Usage: Pass URL to script, get back URL to Wayback Machine snapshot | |
| base_url = 'http://web.archive.org' | |
| r = requests.get(base_url + '/save/' + sys.argv[1]) | |
| if r.status_code == requests.codes.ok: |
kjmph
/ A_UUID_v7_for_Postgres.sql
Last active
February 26, 2026 23:14
Postgres PL/pgSQL function for UUID v7 and a bonus custom UUID v8 to support microsecond precision as well. Read more here: https://datatracker.ietf.org/doc/rfc9562/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/ | |
| create or replace function uuid_generate_v7() | |
| returns uuid | |
| as $$ | |
| begin | |
| -- use random v4 uuid as starting point (which has the same variant we need) | |
| -- then overlay timestamp | |
| -- then set version 7 by flipping the 2 and 1 bit in the version 4 string | |
| return encode( |
OlderNewer