PDA

View Full Version : Timeline for SQL proxy?



stefankendall
22 Jan 2012, 12:27 PM
Is there any word when an SQL proxy will be available for ST2? I just found out that localStorage is getting wiped between my app updates (phonegap), so I'm really stuck right now.

I'm on my way to syncing to the web via manual backup, but this is a huge pain that I was hoping to avoid for a while.

abe.elias
22 Jan 2012, 2:40 PM
Have you looked at Sencha.io?

stefankendall
22 Jan 2012, 2:42 PM
When I log in, I get a white page that says this:
There are no organizations.

abe.elias
22 Jan 2012, 2:54 PM
http://www.sencha.com/blog/using-sencha-io-sync/

That's the gist of what sync does. Is that an error "There are no organizations" that you are getting? Or is it just informational? Have you tried creating an organization?

stefankendall
22 Jan 2012, 2:56 PM
It looks like an error.




"There are no organizations." is the entirety of the source code for the page that gets rendered after I login.

stefankendall
22 Jan 2012, 3:00 PM
Oh my gosh, this is exactly what I need, and what I've started to build. If only the login page worked!

Do you know when the sync happens? A good bit of my users are offline, or in spotty areas, when using the app, since there is no dynamic internet content.

If the proxy doesn't work like a write-through cache that can batch what hasn't been saved, I don't know that this will work for me.

-Stefan

merrells
22 Jan 2012, 6:17 PM
Stefan,

I'm sorry you were unable to login successfully.
I have fixed the problem, and you should be ok now.

In happier news, our Sencha.io data service sounds perfectly suited to your use case.
Whenever your app calls sync() we exchange updates with the server.
Your users can make local updates whenever they want... online or offline!

John

stefankendall
22 Jan 2012, 6:37 PM
Awesome. I can log in now.

This absolutely looks like exactly what I'm looking for, and I only wish I had found this *before* I'd setup the heroku instance and started building the backend to handle a sync. Eh. :P

I'm using Sencha Touch 1.1.1, so can I just drop in Sencha I/O SDK Beta 3? How does the library uniquely identify users? I'd like to bind to UUID at first, but I've had a couple requests for iCloud storage to sync between devices. If I could fake it with Sencha IO, that sounds like a win to me.

Also, is there any form of security on user data, and do I have access to it? I'm thinking this could be a *really* easy way to do analytics if all I need to do is create a model and call sync. I've been needing analytics for a while, and I've been dreading writing the "if network not available, buffer in localstorage, then push up eventually" crap that Sencha IO sounds like it takes care of.

merrells
22 Jan 2012, 7:01 PM
> I'm using Sencha Touch 1.1.1, so can I just drop in Sencha I/O SDK Beta 3?
No. SIO SDK B3 only works with ST2 PR2 and PR3.


> How does the library uniquely identify users?
As a developer you can create a group of users. Each user who registers for
your app becomes a member of that group and is assigned a unique id, and
a unique username.


> Also, is there any form of security on user data, and do I have access to it?
By default a user's data is only available for access by that user.
(Or by the developer of the app that created the data.)


> I'm thinking this could be a *really* easy way to do analytics
I don't really know what you mean, but...


> if all I need to do is create a model and call sync.
Yes, that's all you need to do.


John