~/Library/Application Support/iPhone Simulator/User/Library/Caches/com.apple.WebAppCache/ApplicationCache.db
$ sqlite3 ApplicationCache.dbSQLite version 3.4.0Enter ".help" for instructionssqlite> .mode columnsqlite> .headers onsqlite> .tablesCacheEntries CacheResourceData CacheWhitelistURLs FallbackURLs CacheGroups CacheResources Caches SchemaVersion sqlite> select * from CacheGroups;id manifestHostHash manifestURL newestCache---------- ---------------- ------------------------------------------------- -----------1 906983082 http://mail.google.com/mail/s/?v=ma&name=sm 1
sqlite> select * from Caches;id cacheGroup---------- ----------1 1
sqlite> select * from CacheEntries limit 1;cache type resource ---------- ---------- ----------1 2 1
sqlite> select * from CacheResources where id=1;id url statusCode responseURL ---------- ------------------------------------------- ---------- -----------------------1 http://mail.google.com/mail/s/?v=ma&name=sm 200 http://mail.google.c...mimeType textEncodingName headers data------------------- ---------------- --------------text/cache-manifest utf-8 sqlite> .schema CacheResourceDataCREATE TABLE CacheResourceData (id INTEGER PRIMARY KEY AUTOINCREMENT, data BLOB);
sqlite> select type,url,mimeType,statusCode from CacheEntries,CacheResources where resource=id;type url mimeType statusCode---------- ---------------------------------------------- ------------------- ----------2 http://mail.google.com/mail/s/?v=ma&name=sm text/cache-manifest 200 4 http://mail.google.com/mail/images/xls.gif image/gif 200 4 http://mail.google.com/mail/images/pdf.gif image/gif 200 4 http://mail.google.com/mail/images/ppt.gif image/gif 200 4 http://mail.google.com/mail/images/sound.gif image/gif 200 4 http://mail.google.com/mail/images/doc.gif image/gif 200 4 http://mail.google.com/mail/images/graphic.gif image/gif 200 1 http://mail.google.com/mail/s text/html 200 4 http://mail.google.com/mail/images/generic.gif image/gif 200 4 http://mail.google.com/mail/images/zip.gif image/gif 200 4 http://mail.google.com/mail/images/html2.gif image/gif 200 4 http://mail.google.com/mail/images/txt.gif image/gif 200
CACHE MANIFEST# version: 3f1b9s84jsfile1.js... other URLs ...
CACHE MANIFESTjsfile1.jsNETWORK:/images/FALLBACK:/thumbnails/ images/missing_thumb.jpg
if (window.applicationCache.status == 0) { // Page was loaded from the Network.} else { // Page was loaded from AppCache}
CACHE MANIFESTjsfile1.jsjsfile2.jsstyles.css/images/image1.png/images/image2.png
<html manifest="/sitemanifest">
