Lots of applications use sqlite dbs. It can be useful to try and find them all. For this you can use the following command
find . -type f -exec sh -c 'head -c 16 "$1" 2>/dev/null | grep -q "^SQLite format" && echo "$1"' _ {} \;
as all sqlite files start with the header string: "SQLite format 3\000" , see: Database File Format
it can then be helpful to get the size of each result
find . -type f -exec sh -c 'head -c 16 "$1" 2>/dev/null | grep -q "^SQLite format" && echo "$1 $(stat -c%s "$1" | numfmt --to=iec)"' _ {} \;
Created 2024-11-25T09:16:45+01:00, updated 2024-11-25T09:20:43+01:00 · History · Edit