Notifications
Clear all

SQLite vacuum

6 Posts
3 Users
0 Reactions
2,397 Views
(@forensicitderby)
Posts: 18
Active Member
Topic starter
 

Hello,

 

At what point does an SQLite database vacuum?

 

When a vacuum occurs, do all the SQLite databases on the device vacuum at the same time?

 

Is there a reoccurring time where it might vacuum without reason? Like every 4 weeks?

Thanks

 
Posted : 17/06/2020 11:25 am
Topic Tags
(@rich2005)
Posts: 540
Honorable Member
(@forensicitderby)
Posts: 18
Active Member
Topic starter
 

This implies an auto vacuum will only occur if the app creator has added it individually to a particular app?

 
Posted : 17/06/2020 11:46 am
minime2k9
(@minime2k9)
Posts: 481
Honorable Member
 
Posted by: @forensicitderby

This implies an auto vacuum will only occur if the app creator has added it individually to a particular app?

Correct - it is disabled by default and only activated if the software using it enables it.

 
Posted : 17/06/2020 8:04 pm
(@forensicitderby)
Posts: 18
Active Member
Topic starter
 

thank you for your replies.

Does anyone happen to know if Photos, iMessage, WhatsApp and Facebook Messenger “auto vacuum” on iOS?

 
Posted : 17/06/2020 8:07 pm
minime2k9
(@minime2k9)
Posts: 481
Honorable Member
 

You can tell by looking at the header of the database:

https://www.sqlite.org/fileformat.html

Offset 52 Length 4 bytes

The page number of the largest root b-tree page when in auto-vacuum or incremental-vacuum modes, or zero otherwise.

 
Posted : 17/06/2020 9:57 pm
Share: