I am looking at developing a mobile app with Sencha Touch that would need to access a fair amount of data on a web server. I had previously been working in development with Titanium, and had built a development database in SQLite.
Is there a similar development style (something comparable to SQLite) when working with Sencha Touch, or does any one recommend (and what steps you'd take) building the database on a remote server and developing with that?
I am looking at pulling data from our employee directory and class schedule for students (in SQL Server). I am thinking the best option is to pull the data via ajax / json http call. Once called, maybe store some of the data locally if the user has frequent searches. Would like to hear what you come up with on your end.