How to VACUUM a Core Data SQLite db?

By design, Core Data does not issue a VACUUM SQL command to its SQLite database(s), as detailed here. I'm creating a Core Data application that'll store, and later delete, large binary files (2-10MB in size) in a SQLite db. Over time this will lead to fragmentation and a larger-than-necessary SQLite database. I'd like to periodically issue a VACUUM command, say, during a cleanup operation I run.

• How can I progmatically issue a VACUUM command to Core Data's SQLite stores?
• Is it possible to do this through Core Dat开发者_StackOverflow中文版a, or must I mount the SQLite db and connect to it directly to execute the VACUUM SQL?

The supported way to do this, on OS X 10.6 / iOS 3.0 and later, is to set the NSSQLiteManualVacuumOption in the options when you are adding the store to the persistent store coordinator.

Yes, vacuum is a recognized SQL statement in SQLite. It can be used as a normal query, or so it says.

Beware, though, as it can lead to excessive file system reads and writes—the bottleneck of practically any system—not to mention server file system fragmentation on Windows servers.

Here's how you can vacuum your CoreData container

Example:

let container = NSPersistentContainer(name: "someName")

// Enable history tracking and remote notifications
guard let description = container.persistentStoreDescriptions.first else {
    fatalError("###\(#function): Failed to retrieve a persistent store description.")
}

description.setOption(true as NSNumber, forKey: NSSQLiteManualVacuumOption)

//... The rest of your setup

By doing this, the CoreData container will perform the vacuum command and thus resize itself accordingly.