Skip to content

Instantly share code, notes, and snippets.

@dzogrim
dzogrim / zipped-userData.db-sqlite3-diff.sh
Last active December 23, 2023 17:03
Compare sqlite 'userData.db' stored in ZIP archive and display differences without writing out files on disk (macOS only)
#!/bin/bash
# Description:
# This script aims to compare two zipped SQLite database files (<file1.zip> and <file2.zip>),
# each containing a 'userData.db' file. It extracts these databases, converts them into SQL dumps,
# and then compares the dumps using diff.
# The script is designed to avoid writing the SQLite databases to disk by using process substitution (for fun?).
# You should use the script as indicated in the usage instructions below ...
# Error handling
#!/usr/bin/env bash
### 補完関数。
_tmutil(){
list=$( tmutil | /usr/bin/grep -v ^$ | /usr/bin/grep ^Usage | awk '{print $3}' )
COMPREPLY=( $(compgen -W "$list" ${COMP_WORDS[COMP_CWORD]} ) )
}
complete -F _tmutil tmutil
@roachhd
roachhd / README.md
Last active June 14, 2025 05:31
EMOJI cheatsheet 😛😳😗😓🙉😸🙈🙊😽💀💢💥✨💏👫👄👃👀👛👛🗼🔮🔮🎄🎅👻

EMOJI CHEAT SHEET

Emoji emoticons listed on this page are supported on Campfire, GitHub, Basecamp, Redbooth, Trac, Flowdock, Sprint.ly, Kandan, Textbox.io, Kippt, Redmine, JabbR, Trello, Hall, plug.dj, Qiita, Zendesk, Ruby China, Grove, Idobata, NodeBB Forums, Slack, Streamup, OrganisedMinds, Hackpad, Cryptbin, Kato, Reportedly, Cheerful Ghost, IRCCloud, Dashcube, MyVideoGameList, Subrosa, Sococo, Quip, And Bang, Bonusly, Discourse, Ello, and Twemoji Awesome. However some of the emoji codes are not super easy to remember, so here is a little cheat sheet. ✈ Got flash enabled? Click the emoji code and it will be copied to your clipboard.

People

:bowtie: 😄

@ttscoff
ttscoff / speedmail.applescript
Last active March 23, 2025 03:08
Speed up Mail.app
(*
Speed up Mail.app by vacuuming the Envelope Index
Code from: http://www.hawkwings.net/2007/03/03/scripts-to-automate-the-mailapp-envelope-speed-trick/
Originally by "pmbuko" with modifications by Romulo
Updated by Brett Terpstra 2012
Updated by Mathias Törnblom 2015 to support V3 in El Capitan and still keep backwards compability
Updated by @lbutlr for V5 and Container folder in High Sierra and use du
*)
tell application "Mail" to quit