Skip to content

Instantly share code, notes, and snippets.

@berkus

berkus/HOWTO.md

Created October 20, 2025 21:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save berkus/6bb2364daa3177516e17a7654b898992 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save berkus/6bb2364daa3177516e17a7654b898992 to your computer and use it in GitHub Desktop.
Download ZIP
How to extract data from the Yojimbo3 database:
Raw
HOWTO.md
  1. rg -a "text match", note the database file to use
  2. sqlite3 Database.db
  3. .tables
  4. .schema <table>
  5. select... until you find the ZBLOB's table primary key Z_PK
  6. Save it to file with SELECT writefile('out.plist', ZBYTES) FROM ZBLOB WHERE Z_PK=298; <-- use your pk
  7. Convert plist to text format with plutil -convert xml1 out.plist
  8. Open it with an editor and find your contents among shitloads of metadata
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment