Notifications
Clear all

SQLite vacuum

ForensicITDerby
(@forensicitderby)
New Member

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

Quote
Topic starter Posted : 17/06/2020 11:25 am
Topic Tags
Rich2005
(@rich2005)
Senior Member

https://www.techonthenet.com/sqlite/auto_vacuum.php

ReplyQuote
Posted : 17/06/2020 11:27 am
ForensicITDerby
(@forensicitderby)
New Member

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

ReplyQuote
Topic starter Posted : 17/06/2020 11:46 am
minime2k9
(@minime2k9)
Active 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.

ReplyQuote
Posted : 17/06/2020 8:04 pm
ForensicITDerby
(@forensicitderby)
New Member

thank you for your replies.

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

ReplyQuote
Topic starter Posted : 17/06/2020 8:07 pm
minime2k9
(@minime2k9)
Active 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.

ReplyQuote
Posted : 17/06/2020 9:57 pm
Share:
Share to...