Re: Location of the SQLite DB file?

[Rémi Grumeau]

Offline storage is different from localStorage
SQLite Studio is, i assume, for LocalDatabase.

R.

Le 14 déc. 10 à 20:28, KCL a écrit :

> When using the offline storage capability of safari/mobile safari,
> where does the file get stored?
>
> I'm trying to debug using SQLite Studio and I can't find the
> location of the database file. I've hunted around a bit on the web,
> but no luck.
>
>
> Scott.
>
> --
> You received this message because you are subscribed to the Google
> Groups "iPhoneWebDev" group.
> To post to this group, send email to iphone...@googlegroups.com.
> To unsubscribe from this group, send email to iphonewebdev...@googlegroups.com
> .
> For more options, visit this group at http://groups.google.com/group/iphonewebdev?hl=en
> .

[sc...@kallenconsulting.com]

(and no, I was hunting on the web for my answer, not the database file itself.)

[Peter Rust]

Scott,

 

> When using the offline storage capability of safari/mobile safari, where does the file get stored?

On Windows 7, take a look in C:\Users\%USERNAME%\AppData\Local\Apple Computer\Safari. There’s a Databases folder, a LocalStorage folder, and 4 SQLite files in the root of that folder (ApplicationCache.db, Cache.db, SafeBrowsing.db and WebpageIcons.db).

 

On the mac and other versions of Windows, I would think they would be in a similar location.

 

-- peter

[Scott Kallen]

Hey, thanks Peter!

I found it in:

/Users/[Local Username]/Library/Safari/Databases/http_[URL of the site creating the DB]_0

The database itself was something like, "0000000008.db"  Not sure where the numbering came from, but there it is.

Hope this helps others looking for it as well.

Scott.

--