Database with Sencha

[alfred13]

I'm new with Sencha and I try to work with a database that Sencha could be update with data in an application for iOS.

Does anyone do something like this? With Sqlite database or Mysql database?

I don't understand if "Store" can do that for me.

Thanks,

Alfred.

[mitchellsimoens]

There is a community SqlLite proxy that will read a sqlite database file. For databases like MySQL you will need a server side script to connect to the database, javascript cannot.

[alfred13]

Thanks for this indication.

Now, I want to prepopulate my database. My application must has data in offline mode for the first time launched. How can i do that?

I tried to give two proxies for one model (one in ajax with local json, an other one in localstore), but I think it can take only on proxy.

Is it possible de take data from local json or local database and add these datas in my database when the application is launched?

[Digitalis]

I have similar requirements for the app I'm working on now. I suggest ditching the built in stores. IMO they're just not flexible enough to support online/offline switching. I still use stores for UI databinding, but I don't use them for local persistence or syncing with a remote server.

Instead of using the built in stores I wrote a thin data layer using WebSQL, and hand rolled all of the ajax needed to sync back and forth. It's pretty simple and you'll know exactly what is happening when anything goes wrong, instead wasting time of trying to cajole the store classes into doing what you want.