3 ms·
Out of curiosity I wondered what was the biggest Sqlite databse in my filesystem: find / -name *.sqlite -printf '%s %p\n' 2>/dev/null | sort -nr | head -n 1 T
by NewEntryHN 6y ago
Out of curiosity I wondered what was the biggest Sqlite databse in my filesystem:
find / -name *.sqlite -printf '%s %p\n' 2>/dev/null | sort -nr | head -n 1
The winner is `favicons.sqlite` from Firefox profile directory, which is 40 MB.
- proto-n 6y agoMake sure to include .etilqs files as well
- kevincox 6y agoI found the source. It appears that it is an etilqs_ prefix rather than .etilqs but the story is somewhat humorous: https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db733dd38f96896cd825f/src/os.h#L52-L66 https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db...
- why_only_15 6y agomacos version: mdfind "kMDItemDisplayName == *.sqlite" -0 | xargs -0 stat "-f%z %N" | sort -nr | head -n 5 should be fairly fast because mdfind uses the spotlight backend and already has this data cached.
- Hello71 6y agodoes it include system files?
- why_only_15 6y agoYeah -- the top 5 for me includes photos and notes
- rasz 6y agoChrome History at ~500MB