Difference between websql and sqllite

1,404 views
Skip to first unread message

Divesh Salian

unread,
Aug 30, 2013, 5:58:31 AM8/30/13
to phon...@googlegroups.com

After a long search still am not able to find a difference between websql and sqlite.

  • are both html5 based ?
  • websql has storage limit where as sqlite there is no storage limit ?
  • Is external plugin required for sqllite in phonegap ? as documentation states that following code will create a sqlite database

    var db = window.openDatabase("test", "1.0", "Test DB", 1000000);

any suggestion is much appreciated

srikanth vm

unread,
Aug 30, 2013, 6:21:45 AM8/30/13
to phon...@googlegroups.com
Both are SQLite based, not related to HTML5.

Web SQL has a 5 MB limit, but once it reaches 5 MB it will give an option to user to increase the limit to 25MB. But in general for a normal app(login based, tracking user data in plain text ) 5 MB should be more than enough.

Yes for SQLite you need an additional plugin.

window.openDatabase() will create a Web SQL Database.


--
-- You received this message because you are subscribed to the Google
Groups "phonegap" group.
To post to this group, send email to phon...@googlegroups.com
To unsubscribe from this group, send email to
phonegap+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/phonegap?hl=en?hl=en
 
For more info on PhoneGap or to download the code go to www.phonegap.com
 
To compile in the cloud, check out build.phonegap.com
---
You received this message because you are subscribed to the Google Groups "phonegap" group.
To unsubscribe from this group and stop receiving emails from it, send an email to phonegap+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
There are 10 kinds of people
Those who understand binary and those who dont.

tru...@sphererays.net

unread,
May 31, 2014, 2:05:00 AM5/31/14
to phon...@googlegroups.com
Thanks tobi,

I had same doubt.
Reply all
Reply to author
Forward
0 new messages