Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.



macos 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.


does it include system files?


Yeah -- the top 5 for me includes photos and notes


Make sure to include .etilqs files as well


I 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/3cf493d4018042c70a4db...


Chrome History at ~500MB




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: