Where is my SQLite DB file???

quest_capital
quest_capital used Ask the Experts™
on
Please see the attached file, it shows my db opening
var db = openDatabase("AddressBook", "1.0", "Address Book", 200000);

However when I do a search I can not find the db, so I have a couple of questions:

1. Can someone tell me where or how to find the physical DB (is it hidden?).
2. I know how to create a SQLite DB from the consol, how could I use that DB instead (so at lease I know where the DB is located that way.)

Also
I am opening the web site from a jump drive and I noticed that on one computer the SQLite DB holds my data, but on the other computer the the data doesn't show up, so it seems like the the DB is not saved in side of my project. I would like to beable to control the location of the DB so that I can update and modify it out side of the the web site.
sqldb.html
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
C:\Documents and Settings\YourLogin\Local Settings\Application Data\Google\Chrome\User Data\Default\databases\file__0\5

Author

Commented:
Mikal613

How can I point it to my root folder under my web site project?
you can copy it and just access it via the path
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Author

Commented:
Thanks Mikal613

I'm a newby to this can you show me the syntax intergrated with this code below
db = openDatabase("AddressBook", "1.0", "Address Book", 200000);
var dataset;
createTable();

Author

Commented:
Mikal613

It seems like that syntax works in some lang called QT how does it work in Javascript.

Author

Commented:
Mikal613

That works in Java but not in Javascript.
Cant you just specify a location when you call openDatabase()
Kusala WijayasenaSoftware Engineer
Commented:
In here you are dealing with HTML5 "Web SQL Database" and you don't have a option to change it location or delete existing db

----------- Note ---------------

On November 18, 2010, the W3C announced that Web SQL database is a deprecated specification. This is a recommendation for web developers to no longer use the technology as effectively the spec will receive no new updates and browser vendors aren't encouraged to support this technology.

------------------------------------


-Kusala

Author

Commented:
Mikal613 & Kusala

Thanks to your replys
It is realy wierd how this is setup.
I found a database called databases.db located:
C:\Users\USERNAME\AppData\Local\Google\Chrome\User Data\Default\databases
When I opened databases.db I saw a list of all of the databases that I created in a table called Databases. The table showed:
origin=http_Localhost_47783 (which was a folder under databases),
name=AddressBook.db
ID=1 thr 8
The databases where listed by the ID number with no .db extensions.

So the db was located
C:\Users\USERNAME\AppData\Local\Google\Chrome\User Data\Default\databaseshttp_Localhost_47783\8

Crazy ha...

Author

Commented:
:-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial