30 Sep 2011 11:56 AM #11
Thanks for the response hyperionab. As much as I would love to use Sencha.io sync, it may not be a good option for us right now until we can sync to our own datastores.
1 Oct 2011 7:14 PM #12
Yea, it too bad. I was waiting to deploy my app until Sencha Sync arrived but if it will only sync to your servers, that is truly disappointing.
The fact is, most people don't trust other people with their data. Although I fully expect Sencha to be around for a while given the great work you guys are doing, I said the same about a lot of companies in the Bay Area in the past and have been proven wrong before.
2 Oct 2011 11:59 AM #13
I'm using WebSQL and I rolled my own sync logic to tie into a back-end running the Microsoft Sync Framework with SQL Server. It uses a fairly simple method of storing last edit / creation dates on each server record, then the client sends its last "anchor" date when requesting the latest changes. It works quite well, but is not without tradeoffs. This Sencha sync solution looks very interesting, but seems like quite a different approach.
So, two questions:
-Is WebSQL support in the roadmap?
-Any possibility of integrating wih the MS Sync Framework back-end I described, or is the anchor date approach too far off from how Sencha Sync works (which I obviously don't fully understand at the moment).
I also share bastard's sentiments about security and the desire for self-hosting.
4 Oct 2011 10:47 PM #14
Will it be possible (and documented) to read the data from your sencha-server and store new records?
We don´t need an external sync but have to connect from an external app, which is not browser based.
10 Oct 2011 4:26 AM #15
Just an example to be sure to understand what will happen.
A database with one product : id=1, name="Macbook"
user1 : at 5:00 is working on the app. 6:30 online, he renames the product in "Macbook pro".
user2 : at 5:00 is working on the app : < 6:00 no more network> 7:00 offline, he renames the product in "Macbook air" <8:00 network is back> SYNC ?
I guess what did user2 offline is dead but just wanna be sure.
Thank you in advance,
10 Oct 2011 8:09 AM #16
Right now, all access has to come from Sencha Touch. It's a limitation we're aware of and we'll be working to address it (so you can read/write out of the server, and do other 3rd party operations), but in the beta and likely the v1 it'll be as-is.
10 Oct 2011 8:10 AM #17
We don't have support for WebSQL. In fact, WebSQL looks like it'll disappear from the browsers and get replaced with IndexDB. In either case, we don't plan on using WebSQL or IndexDB yet, and we're using LocalStorage for the time being. Regarding MS Sync, it's not something we've looked in to. It's a very different approach, true, but it's an interesting idea.
10 Oct 2011 8:20 AM #18
This is an example of an attribute value conflict. The value of the attribute called 'name' is either Macbook' or 'Macbook pro'. We resolve this kind of conflict using a strategy called last-writer-wins. So, if user2 changed the attribute value before user1, then user1 'wins', otherwise user2 'wins'. The before here is based on the ordering of timestamps issued for each change.
10 Oct 2011 8:08 PM #19
How could I use Sencha.io sync in a case (say a note-taking app) where the data from each user needs to be separated and governed by some form of access control. Is it possible to do that with sync in its current state? Thanks, and sync looks really great so far!
10 Oct 2011 8:19 PM #20
Database access control
Database access control
The current release of sync does not provide any access control enforcement. So, with your note taking app, any user could edit any other user's database, assuming they knew the name of the database.
A future version of sync will include support for access control, so that a user can provide read-only access to a database.