Am developing an application which will work for Android, iPhone and mobile web. I need to access data from Sqlite tables. but it is observed that Titanium doesnot have support for mobile web. Is there any other workarounds to store data and access for mobileweb applications...?
Please help me out...
Titanium Mobile Web does not and never will support Ti.Database. The Web SQL DB spec is deprecated and isn't implemented for some browsers like Firefox. Furthermore, Ti.Database is synchronous whereas Web SQL DB is asynchronous only (unless using from a Web Worker, which is async).
Your options for storing data client side are Ti.App.Properties and Ti.FileSystem... both of which use the browser's local storage mechanism which has a 5MB limit on most devices.
I've created a ticket to fix Mobile Web's Ti.Filesystem so that the temp directory uses session storage instead of local storage, which doesn't appear to have any storage limits. The ticket is here: https://jira.appcelerator.org/browse/TIMOB-10287.
If your application is able to store data in the cloud or server side, then you could use ACS or use Ti.Network.HTTPClient to talk to your server where you can store data in MySQL or whatever database you prefer.
Think you can help? Login to answer this question!