title: How to VACUUM a Core Data SQLite db?
body: <p>By design, Core Data does not issue a <strong>VACUUM</strong> SQL command to its SQLite database(s), as <a href="http://www.cocoabuilder.com/archive/message/cocoa/2008/3/5/200554" rel="noreferrer">detailed here</a>.  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.</p>
  
  <ul>
  <li>How can I progmatically issue a VACUUM command to Core Data's SQLite stores?</li>
  <li>Is it possible to do this through Core Data, or must I mount the SQLite db and connect to it directly to execute the VACUUM SQL?</li>
  </ul>