Using the Dropbox Datastore API in Python(dropbox.com) |
Using the Dropbox Datastore API in Python(dropbox.com) |
My thought would be to create a locked folder accessible only by APPX and then if the user decides they don't want to use the service any more and revokes permission to APPX the folder gets deleted.
What are the limit on number of records, number of field (column?) in a table? How many tables can one have?
How often is the commit? Is it commit to local/fs or to the cloud (under what condition)?
How does the datastore sync from different devices works?
As to the sync model, changes are always made locally and then queued for upload. You might want to read Guido's posts about conflict resolution to understand the model:
https://www.dropbox.com/developers/blog/48/how-the-datastore...
https://www.dropbox.com/developers/blog/56/how-the-dropbox-d...
Good info!
10MB database limit is too small - somehow I would image dropbox wants app to create hundreds of MB if not GB of data. :-)
Are there any test code available? Open Source / on github?
It is much easier to understand the flow from the test code than API doc. If test code is available, it is easily to morph that info benchmark type code.
Specifically, it does not spell out any of the imports, and uses very large except clauses.
In general, I based the tutorial on the sample app that ships with the SDK. That app uses Flask and presents some actual UI. If you want full working code, I would suggest taking a look at that sample.
The tutorial is basically fragments from that sample that show the basic concepts, but without some boilerplate, the fragments are not themselves runnable.
(BTW, where are the "very large except clauses?")
The except clause is in the "dropbox_auth_finish" view. That might be personal paranoia, but I'm sure that every single timeI think "It's OK to put a `except:` here", it eventually comes back to bite me (without exception ;) )!
I do understand the motivation to keep it minimal (and I think the Flask boilerplate is indeed well understood), but putting together the sample without the Dropbox SDK imports (specifically without an IDE) might end up being a bit more bothersome than optimal : )
Just personal opinion, of course!
Some apps won't enjoy being open simultaneously, but if you keep this in-mind, this is generally a great solution.
Therefore Dropbox, not a homegrown process, syncs your settings
Keep in mind that file data should go outside of datastores (in files), so the 10MB is for the per-user, per-app structured data. E.g. contacts, app settings, game state, etc. 10MB actually goes a pretty long way there.
Also keep in mind that, at present, all of the SDKs load the entire datastore into memory, so there's a pretty low limit to how big you want a datastore to get. 10MB is a comfortable limit for now.
I see why the 10MB limit.
What's the Pro/Con of this compare to just use sqlite on a dropbox volume?
From what I read, the API doesn't do any operational transformation such as merge, delta the changes' etc. The client app is expected to do it.
In contrast, if you make a change to a sqlite database on two different devices, you now have two different files and no way to merge them. (There are people who have used Dropbox to sync sqlite databases this way, and they've ended up writing diff/patch over sqlite to merge changes. Using datastores is a lot simpler and more likely to be correct.)
Only the server has understanding of the most current states of the dataset and can try to sync up with multiple client at the same time.
The way it works in the Datastore API is that the client sends its changes to the server with an attached "parent revision." If that parent revision is the revision that the server has, then the change goes through (no conflict). If the revision doesn't match, then the change is rejected by the server, and it's up to the client to pull down the latest changes from the server, merge things (via, in the case of lists, OT), and then try again.