Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'How to vacuum all sqlite databases' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
How to vacuum all sqlite databases
Authored by: dille on Mar 03, '09 03:29:32PM

Nifty, but not all .db files are actually SQLite databases. Expanding this to more lines to do a quick "file" on the filename before vacuuming it helps that.

Otherwise, neat. And gosh, there's a lot of databases in there.



[ Reply to This | # ]
How to vacuum all sqlite databases
Authored by: lincd0 on Mar 04, '09 08:29:01AM

Faster and easier just to let the sqlite3 command fail on non-database files and ignore the error messages.



[ Reply to This | # ]