phonegap - lawnchair question

Question

I'm thinking about switching from titanium developer to phonegap mainly because there is virtually zero support with titanium (their q/a section often has questions asked nearly a year ago without any answers) and the android emulators are beyond slow to launch.

My only concern is the lawnchair db performance in phonegap. I've been using sqlite in titanium and it works great with datasets of a few thousand records.

Does anyone know how well lawnchair performs in phonegap with thousands of records?

Answer 1

LawnChair is supported on all devices I believe.

it is json based storage, and you can configure the filestore based on specific platform, take a look at the git hub page there are sqlite adapters

A final comment on zero support on titanium... PhoneGap has a very active user community, but the API and support is not as robust as you will find in Titanium. I use both... I think each one has strengths and weaknesses, but the grass is not always greener on the otherside

Answer 2

Lawnchair is optional with PhoneGap projects - it doesn't depend on PhoneGap, nor vice versa. It's a thin wrapper around the native storage APIs for each platform, including SQLite. Because it doesn't do a whole lot, there isn't much of a performance hit - the benefit is that you have a unified API to lots of different data stores.

One thing to note is that Lawnchair is a strictly key value based store - with the SQLite adapater, for instance, it sets up a single Lawnchair table with two fields (key and value). If you have a large relational dataset, you may want to use the SQLite APIs directly rather than switching to a key-value interface.