[mobio9471]

Hi,

what I am looking for is a database concept to use in my app.

If you have experience with it I would be very happy if you share it with me.

I already spent a lot of time to find a solution that meets my needs.

A local database on my app should make me independent of a server connection.
But if a connection is available, the local DB should sync automaticly with the serverside DB.

Important for me is:
– easy scaling
– easy replication, syncing
– works at least on IOS and Android
– works also on older versions of IOS and Android

Less important for me:
– respond time

CouchDB seems to meet my needs perfectly on server-side.

PouchDB looks like (in principal) the perfect approach on mobile-side.

But there come some restrictions with it.

– PouchDB runs on the browser. And the memory available is limited there to some MB. If pouchDB needs more, the browser asks for permission.

I need around 50 MB (maximum). What are the standard limits on IOS and Android ?

– If indexedDB is available, more memory is available but indexDB is not available on older versions of IOS and Android.

– To run pouchDB on older versions of Android (<4.0) the file es5-shim.js is necessary to be included.
But comments I found on the web say, it does not work reliable.

May someone show me, how to include this file to mobione ? The content is not pure javascript. It is a html document that contains javascript.

A sqlite plugin for phonegap/cordova can be used. Does this enable to overcome the memory limitations ?
Also for older versions of IOS and Android ?

What is your experience/knowledge on pouchDB ?
Is it an approach that works reliable ?

An alternative to pouchDB seems to me couchbase-lite.
Does anybody have experience/knowledge with it ?

Is there a better alternative to pouchDB ?
Does a better approach exist ?
Without CouchDB, PouchDB, couchbase-lite ?

I would be very happy to get more information.

[support-michael]

@mobio9471

I don’t know that I can be of that much assistance as I can not recommend a specific solution. I will share the little bit that I know on the topic. Perhaps others can share their experiences and insights as well?

Regarding nonsql dbs, we have only tinkered with them. So I can’t say anything about production usage. I sort of recall some ability to sync data between different dbs.

HTML5 websql implementations and storage quotas vary across the ios and android platforms and versions. You can learn more here:
http://www.html5rocks.com/en/tutorials/offline/quota-research/
Similar to your issue with pouchdb, websql will typically request permission to grow storage from the user. We have built internal corporate apps that use websql. But they were relatively small amount of data, a few mb in size tops. They all use a simple sync model to merge data with other app users through a php webservice api in front of mysql on a lamp stack.

>A sqlite plugin for phonegap/cordova can be used. Does this enable to overcome the memory limitations ? Also for older versions of IOS and Android ?

See this documentation on the cordova sql storage: http://docs.phonegap.com/en/2.9.0/cordova_storage_storage.md.html#Storage
Notice the doc claims it uses the local implementation if available. Thus it is more of a websql polyfill.

Good luck with your implementation. Please share the direction you decide to take. I would be interested in how it goes.

[mobio9471]

Hi Michael,

thanks a lot for your reply.

I will have a closer look to the documentation you recommended.

And I will report the direction I choose and the experience I get.

But If someone, who already has experience with the topic reads this, I will encourage once again to share experience.

[Author]

Posts