如何通过 Flex/Air App 进行本地数据库管理
我计划使用 Flash Builder 4/Flex 编写一个 AIR 应用程序，该应用程序主要基于记录、存储和分析数据。我将创建需要几乎实时更新的图表等。
对我来说，应用程序能够在没有互联网连接的情况下运行至关重要，因此我需要某种类型的本地数据库，但我最终也希望构建数据的在线同步，其中任一数据库都可以基于较新的数据相互更新信息。此外，某种类型的加密肯定会受到欢迎，并且速度是一个大问题
同步：主要更新/添加/删除将在离线数据库上完成，但理想情况下我希望有一个允许相同更新/添加的Web界面/deletions 并将被同步（除此之外，我不确定具体如何做到这一点，因为我可以根据最可实现的目标进行建模）。我想知道是否有任何预构建的引擎可以处理两个数据库的同步。我最终可能会拥有仅用于添加的网络界面，这将更容易同步..并且我可能会以这种方式开始，但我想使用最能让我在某个时候实现完整在线增删改查的技术进行构建。
考虑到所有这些，我尝试避免日后头痛的最佳方法是什么？
I am planning on using Flash Builder 4/Flex to write an AIR application which is primarily based around recording, storing and analyzing data. I'll be creating charts etc that need to update in almost real time.
It's essential to me that the application be able to function without an internet connection so I need a local database of some variety, but I would also eventually like to build in online synchronization of the data where either database can be update each other based on newer information. Moreover, some type of encryption would definitely be welcome, and speed is a large concern
Synchronization: Primarily updates/additions/deletions will be done on the offline database, but ideally I want to have a web interface that will allow the same updates/additions/deletions and will be synced (beyond that I'm not sure exactly how to do it as I can model that based on what is most achievable). I'm wondering if there's any prebuilt engine that could handle the synchronization of 2 databases. I may end up having the web interface only be for additions, which would be significantly easier to sync.. and I may start that way, but i want to build with technologies that will best allow me to implement full online crud at some point.
With all that in mind, what is my best approach to try and avoid headaches down the road?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以按照此处<的描述使用SQLite< /a>.
还有一种方法可以在 Air App 中集成外部应用程序，例如数据库服务器或 Web 服务器。
您能解释一下有关您正在寻找的同步的更多细节吗？
You may use SQLite as described here.
Also there is a method to integrate external applications in your Air App, such as a database server or a web server.
Would you explain more details about the synchronization you're looking for?
当您这样做时，帮自己一个忙，使用像 FlexORM 这样的 ORM 框架。
它使坚持变得非常容易。
While you're at it, do yourself a favor and use an ORM framework like FlexORM.
It makes persistence very easy.