How to connect to an existing SQLite database in Android project using Javascript?

Question

I have copied the Android project from below mentioned location:

http://groups.google.com/group/phonegap/browse_thread/thread/07cf9f48e3cd0663

I have created a SQLite database on my system, now I want to use the same database in my project. But, I want to connect to the database using Javascript (not using Java). Can any one of you give me some tips or any reference to achieve this task.

supakeen · Accepted Answer · 2011-08-05 09:39:46Z

1

If you are referring to javascript running in your browser you won't be able to do that.

A sqlite database is a file on your file system. Javascript which runs in browsers has no, or very limited, access to your file system.

However, modern browsers (and probably most modern mobile browsers as well) do allow you access to the IndexedDB storage API which is a SQL database running on the client and available to your website.

answered Aug 5, 2011 at 9:39

supakeen

2,94419 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Vadi Over a year ago

Thanks for the response Ikanobori, I think the way I asked the question was wrong, what I actually meant was, if you look at the reference code (URL I have mentioned), you can see a piece of code like :

Vadi Over a year ago

var db; var shortName = 'contactdb.db'; var version = '1.0'; var displayName = 'Contact Info'; var maxSize = 65535; And some where down the line you will also see : db = openDatabase(shortName, version, displayName,maxSize); I am not able to connect to my existing database using the above mentioned logic. I have put my database file "contactdb.db" under assets directory. After doing that I don't know what else I have to do. I don't know where am I going wrong.

pulancheck1988 Over a year ago

@Vadi: i have a similar situation (stackoverflow.com/questions/13014163/…) - aka do a query from javascript to the db from /data/data/databases/. Have you found a solution ?

Collectives™ on Stack Overflow

How to connect to an existing SQLite database in Android project using Javascript?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related