Skip to content

Instantly share code, notes, and snippets.

@tenntenn
Created July 6, 2014 15:56
Show Gist options
  • Save tenntenn/9ae8684e8c6d49cd576c to your computer and use it in GitHub Desktop.
Save tenntenn/9ae8684e8c6d49cd576c to your computer and use it in GitHub Desktop.
iOSのWebviewのキャッシュはどこにいくのだろう ref: http://qiita.com/tenntenn/items/eab6d12b6ca1f228659b
% sqlite3 Cache.db
sqlite> .tables
cfurl_cache_blob_data cfurl_cache_response
cfurl_cache_receiver_data cfurl_cache_schema_version
sqlite> .schema cfurl_cache_response
CREATE TABLE cfurl_cache_response(entry_ID INTEGER PRIMARY KEY
AUTOINCREMENT UNIQUE, version
INTEGER, hash_value INTEGER, storage_policy INTEGER, request_key TEXT
UNIQUE, time_stamp NOT NULL
DEFAULT CURRENT_TIMESTAMP, partition TEXT);
CREATE INDEX request_key_index ON cfurl_cache_response(request_key);
CREATE INDEX time_stamp_index ON cfurl_cache_response(time_stamp);
sqlite> select * from cfurl_cache_response where request_key like '%/1x50.png';
108|0|3915446248|0|http://xxxxx/img/1x50.png|2014-07-06 14:24:26|
sqlite> select entry_ID, isDataOnFS, hex(receiver_data) from cfurl_cache_receiver_data where entry_ID=108;
108|0|89504E470D0A1A0A0000000D4948445200000001000000320802000000129926DD0000001649444154789C626A68686062606018EA18100000FFFF51AF01E5F024F2350000000049454E44AE426082
sqlite> select * from cfurl_cache_receiver_data where isDataOnFS=1 limit 1;
140|1|327B2D66-B3E5-428D-B3EB-30FFA815875B
% file fsCachedData/327B2D66-B3E5-428D-B3EB-30FFA815875B
fsCachedData/327B2D66-B3E5-428D-B3EB-30FFA815875B: PNG image data, 1634 x 2224, 8-bit/color RGBA, non-interlaced
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment