Finding the largest SQLite files on a Mac

This runs using Spotlight so it's really fast:

mdfind "kMDItemDisplayName == *.sqlite" -0 | xargs -0 stat "-f%z %N" | sort -nr | head -n 20

I have a lot of files in my Dropbox so I excluded those like this:

~ % mdfind "kMDItemDisplayName == *.sqlite" -0 | xargs -0 stat "-f%z %N" | sort -nr | grep -v Dropbox | head -n 20
852422656 /Users/simon/Pictures/Photos Library.photoslibrary/database/Photos.sqlite
301924352 /Users/simon/Library/Reminders/Container_v1/Stores/Data-A8BA15F3-C80E-43B3-9E21-F7D1CD42AB6A.sqlite
51343360 /Users/simon/Pictures/Photos Library.photoslibrary/database/search/psi.sqlite
47349760 /Users/simon/Library/Application Support/Firefox/Profiles/ljj897b8.default-release/webappsstore.sqlite
47185920 /Users/simon/Library/Application Support/Firefox/Profiles/ljj897b8.default-release/places.sqlite
33779712 /Users/simon/Library/Group Containers/group.com.apple.notes/NoteStore.sqlite

Figured out via this comment by why_only_15 on Hacker News.

SQLite files in a specific directory

The -onlyin directory/ option searches just within a specified folder.

Here's how to see all of the SQLite files that have been created by Firefox (which is a lot, because it is used as a disk format for websites that use localStorage):

mdfind "kMDItemDisplayName == *.sqlite" -onlyin ~/Library/Application\ Support/Firefox

Related

• macos Browse files (including SQLite databases) on your iPhone with ifuse - 2022-09-13
• macos Seeing files opened by a process using opensnoop - 2022-04-26
• macos Using lsof on macOS - 2021-12-11
• macos Using fs_usage to see what files a process is using - 2023-06-15
• sqlite One-liner for running queries against CSV files with SQLite - 2022-06-20
• sqlite Trying out SQLite extensions on macOS - 2022-08-03
• sqlite List all columns in a SQLite database - 2020-05-06
• sqlite Importing CSV data into SQLite with .import - 2021-07-13
• mediawiki How to run MediaWiki with SQLite on a macOS laptop - 2021-03-06
• homebrew Running the latest SQLite in Datasette using Homebrew - 2022-02-28

Created 2020-08-19T08:11:46-07:00, updated 2022-07-26T14:33:15-07:00 · History · Edit