3

I am developing a playbook app, where I am creating multiple databases. Can I get the location of the file/db created. I need to delete that Database, but I couldn't find a way to drop it, so I am planning to delete the file that it is stored in.

Alex Gyoshev
  • 11,929
  • 4
  • 44
  • 74
Nandakumar R
  • 1,404
  • 11
  • 17
  • Why not simply drop all the tables in your database? – Ben Aug 03 '11 at 08:22
  • 1
    Even if all the tables are dropped, the db will still be there. In the description, it says that he want to remove the db itself – Nithin Aug 03 '11 at 08:47
  • I realise that. My suggestion is just being pragmatic: it's not straightforward to remove an SQLite database on a device like the PlayBook, so why not consider other options? – Ben Aug 04 '11 at 08:38

2 Answers2

1

It depends on the OS and browser you are using, I have no experience with Playbook and its browser, but for example under Windows XP and using Firefox it's stored on:

C:\Documents and Settings\USERNAME\Application Data\Mozilla\Firefox\Profiles\YOURPROFILE

and in Chrome there are two possible places:

C:\Documents and Settings\USERNAME\Local Settings\Application Data\Google\Chrome\User Data\Default\

There you have LocalStorage and Databases folders.

Hope it helps

jasalguero
  • 4,142
  • 2
  • 31
  • 52
1

You can't drop SQLite databases, as you have found (hence my suggestion to simply drop all the tables).

However, if you really must delete the physical db file, I think your best bet is to mount the PlayBook's file system, and then track the file down. This link may help in explaining the file system layout on the PlayBook:

http://supportforums.blackberry.com/t5/Tablet-OS-SDK-for-Adobe-AIR/BlackBerry-PlayBook-File-System-Layout/ta-p/773327

Ben
  • 7,548
  • 31
  • 45
  • Thanks for the response. Now I am dropping all the tables and not showing its reference. I believe if I drop all the atbles, it won't consume much memory. – Nandakumar R Aug 04 '11 at 06:15