Thoughts, ideas, tips, musings, and pontifications (not necessarily in that order) by Ben Forta ...
NOTE: This is my personal blog, and the opinions and statements voiced here are my own.
I've been waiting for this one to be announced, and Mike Chambers just blogged it - Apollo will include an embedded SQLite engine which can be used for local database storage, and which will be invaluable to apps that need to support offline processing.
Ben, will something be included within Apollo to allow for data sync between the embedded db and an online connection? For instance, if I write an Apollo application with an embedded db to handle inventory management, and have an e-commerce site that maintains a copy of the inventory db that automatically removes items from inventory as they are sold, do we have a way to sync the two datasources?
-- Ben, will something be included within Apollo to allow for data sync between the embedded db and an online connection? For instance, if I write an Apollo application with an embedded db to handle inventory management, and have an e-commerce site that maintains a copy of the inventory db that automatically removes items from inventory as they are sold, do we have a way to sync the two datasources? --
First, if you are using Flex Data Services, then you already get a lot of this.
We have also already included some low level APIs to make this type of development / data syncing either (some are in the alpha, more in the beta).
Finally, we are looking at also providing higher level APIs that to specifically what you are looking for. However, those will not be in the beta.
Why would Scorpio go with Derby and Flex go with SQLite? From an operations, support and experience point of view, why wouldn't Adobe pick one database?
Craig, I am sure that the fact that ColdFusion is written in Java (Derby is Java based, not C based) and Apollo is written in C (SQLite is written in C, not Java) has something to do with it.
Ben, will something be included within Apollo to allow for data sync between the embedded db and an online connection? For instance, if I write an Apollo application with an embedded db to handle inventory management, and have an e-commerce site that maintains a copy of the inventory db that automatically removes items from inventory as they are sold, do we have a way to sync the two datasources?
--
First, if you are using Flex Data Services, then you already get a lot of this.
We have also already included some low level APIs to make this type of development / data syncing either (some are in the alpha, more in the beta).
Finally, we are looking at also providing higher level APIs that to specifically what you are looking for. However, those will not be in the beta.
hope that helps...
mike chambers
mesh@adobe.com
Just curious.
--- Ben