Skip to content

Instantly share code, notes, and snippets.

View tonyd256's full-sized avatar

Tony DiPasquale tonyd256

59 followers · 0 following
  • San Francisco, CA
View GitHub Profile
@tonyd256
tonyd256 / update.sql
Last active February 20, 2023 18:55
Batch update Adobe Lightroom Classic Catalog missing (sub)folder
# To open catalog: sqlite3 ~/Documents/Genesis\ Catalog/Genesis.lrcat
# Get root folder ID
select * from AgLibraryRootFolder;
# 155051|F3A8D711-D752-4376-9ACE-C11EC8936AAB|/Volumes/Media Archive 1/Photos/2020/|2020|
# 5218438|D1AD0E9E-BB44-41AD-8306-02F9EC4C5D4A|/Volumes/Media Archive 1/Photos/2018/|2018|
# 5218440|DBF52D44-70C9-4D76-8FC7-A4C99FA0BACB|/Volumes/Media Archive 1/Photos/2019/|2019|
# 5949288|744CF540-6D82-4AFF-931E-0ED02052E6FC|/Volumes/Media Archive 1/Photos/2021/|2021|
# 8233240|4E2E6714-6C4B-4608-90B9-4D0E556C536F|/Volumes/Photo SSD/Photos/2022/|2022|../Photos/2022/
@tonyd256
tonyd256 / RequestThrottler.swift
Last active June 2, 2016 23:44
Throttling network requests
/// Adapted from https://gist.github.com/onmyway133/e90ce3e294fb75d927af
import Foundation
final class RequestThrottler {
private var currentTask: NSURLSessionDataTask?
private var source: dispatch_source_t?
private let callback: (NSData?, NSURLResponse?, NSError?) -> Void
private let debounceDelay: NSTimeInterval
init(debounceDelay: NSTimeInterval, callback: (NSData?, NSURLResponse?, NSError?) -> Void) {
@tonyd256
tonyd256 / keybase.md
Last active August 29, 2015 13:57
keybase.md

Keybase proof

I hereby claim:

  • I am tonyd256 on github.
  • I am tonyd (https://keybase.io/tonyd) on keybase.
  • I have a public key whose fingerprint is DB7B 3706 AAAF 5508 CFF5 6162 F643 7D6A E2BF E9CE

To claim this, I am signing this object: