persistence.js with PhoneGap SQL backend

1,002 views
Skip to first unread message

Dennis Z Jiang

unread,
May 25, 2011, 5:13:41 PM5/25/11
to persistence.js
Zef,

Is it possible to use persistence.js with the PhoneGap SQL
implementation as its database store? In case you didn't know,
PhoneGap is a cross-platform mobile development platform. It has a
mobile SQL implementation that is said to be W3C compliant. I am
mostly interested in getting this to work with the upcoming IE9 in
Windows Phone 7, which, like its desktop big brother, does not support
SQL database on the browser. If you think this can be done, how much
effort will we be looking at to make it happen? Thanks.

See link below for more information about the PhoneGap SQL
implementation.
http://docs.phonegap.com/phonegap_storage_storage.md.html

Zef Hemel

unread,
May 26, 2011, 3:25:40 AM5/26/11
to persis...@googlegroups.com
Last I heard Phonegap works fine with persistence.js, you don't have
to do anything, just use it like in any other browser. I tested it at
least on iOS, not sure about other operating systems.

Best,

Zef

--
Zef Hemel
http://zef.me
http://twitter.com/zef

Dennis Z Jiang

unread,
May 26, 2011, 2:44:14 PM5/26/11
to persistence.js
Zef, you are correct. persistence.js works with phonegap. I am
currently using such setup and it works on iOS, Andorid and
BlackBerry(playbook). However, it does not work on WP7. That is
because WP7 does not support SQLite on the browser. The point of my
question is that how about making persistence.js work on WP7, by using
a out-of-the-browser SQL implementation, which phonegap happens to
provide one. Take a look at the link below for the phonegap SQL
javascript APIs. I believe that a "phonegap database store" can be
made so that persistence.js can be used on mobile devices that don't
have SQL browser database. Do you agree? Is it going to be a big
effort to support such database store? Thanks.

http://docs.phonegap.com/phonegap_storage_storage.md.html

On May 26, 3:25 am, Zef Hemel <z...@zef.me> wrote:
> Last I heard Phonegap works fine with persistence.js, you don't have
> to do anything, just use it like in any other browser. I tested it at
> least on iOS, not sure about other operating systems.
>
> Best,
>
> Zef
>

Zef Hemel

unread,
May 26, 2011, 2:51:07 PM5/26/11
to persis...@googlegroups.com
Hi Dennis,

The API you link to is exactly the W3C API that persistence.js
supports, so if that doesn't work on WP7, likely PhoneGap does not yet
implement it on that platform yet? Can't really test it, not a Windows
or WP7 user.

Zef

--

Dennis Z Jiang

unread,
May 26, 2011, 3:00:08 PM5/26/11
to persistence.js
Zef,

You are right again :-) Currently the phonegap SQL APIs do not support
WP7 devices yet. There is work on the phonegap side to make this
happen. I was trying to be ahead of the game in case there was work on
the persistence.js side as well. Your answer was exactly what I was
looking for. Thanks!

On May 26, 2:51 pm, Zef Hemel <z...@zef.me> wrote:
> Hi Dennis,
>
> The API you link to is exactly the W3C API that persistence.js
> supports, so if that doesn't work on WP7, likely PhoneGap does not yet
> implement it on that platform yet? Can't really test it, not a Windows
> or WP7 user.
>
> Zef
>
> Zef Hemelhttp://zef.mehttp://twitter.com/zef- Hide quoted text -
>
> - Show quoted text -

Zef Hemel

unread,
May 26, 2011, 3:20:26 PM5/26/11
to persis...@googlegroups.com
Ok good :-)

--

p.de...@themangomedia.com

unread,
Aug 29, 2013, 6:24:01 AM8/29/13
to persis...@googlegroups.com
Hi, Can you Give me some code Examples or Tutorial to connect with PhoneGap. connection syncronization between Mysql and SQlite

Thanks,
Reply all
Reply to author
Forward
0 new messages