Posting Data from Websql to server

[Ramlaxman.gunda]

How to send data from websql(browser) to server(asp.net) using sencha.

[ericbowden]

Sencha Touch and Extjs do not currently support WebSql. However you can program WebSql with them side by side.

Check out this thread for more details on touch: http://www.sencha.com/forum/showthre...ha-Application

This Extjs tutorial is pretty handy too: http://superdit.com/2010/09/30/stick...-sql-database/

[Ramlaxman.gunda]

Thanks for you reply
We are new to sencha
We are builiding offline apps using sencha framework
suggest the database type to offline application using sencha framework.

[ericbowden]

If you are trying to take the app offline using Sencha check out this tutorial:

http://www.sencha.com/learn/taking-s...-apps-offline/

Basically you have to create a localstorage proxy to store data in the browser's local storage. You can see how it works in the docs here http://docs.sencha.com/touch/2-0/#!/...y.LocalStorage

[Ramlaxman.gunda]

Thanks.

Actually we want to store more than 1000 records of different tables like accounts and products. So if we use local storage key value pairs maintenance is very difficult.
What is the preferred way of storing data locally.

[ericbowden]

You can also try to use indexeddb, however at the moment it is not supported by many mobile or desktop browsers while websql is.

Here is a pretty good article on the differences between them: http://csimms.botonomy.com/2011/05/html5-storage-wars-localstorage-vs-indexeddb-vs-web-sql.html

Here are some pretty good tutorials on each, but I think your best bet would be to use websql for large data.

http://www.html5rocks.com/en/tutorials/indexeddb/todo/

http://www.html5rocks.com/en/tutoria...database/todo/

[Möhre]

Sencha Touch supports indexedDB from 2.1 on.

Have a look at the current release candidate.

Api doc: Ext.data.proxy.SQL

[aconran]

You are correct, the new version of Sencha Touch 2.1 will have Web SQL support.

[Ramlaxman.gunda]

We are using the below code to exit the app
navigator.app.exitApp();
the above is working in android but not in iphone
Can you please help us how to exit the app in iphone