English 中文(简体)
从服务器边数据库到综管系统进行单向扫描的最佳方式是什么?
原标题:What s the best way to do one-way synching from a server-side database to iPhone?

我在我的服务器上建立了大约3米布的大台数据库。 我愿随我讲一句话提出。

The most important thing is that I d like to promote changes to the database (insert, updates, deletes) to the iphone. What s the best way of doing that? I mean - what is necessary on - the server - the client (= iphone) - between; how to transfer this data?

在使用技术服务器方面,我完全免费;现在,我先在服务器上打上一个精益板的数据库,填满了我喜欢一对一字。

最佳回答

Try using web hooks.

The concept of a WebHook is simple. A WebHook is an HTTP callback: an HTTP POST that occurs when something happens; a simple event-notification via HTTP POST.

A web application implementing WebHooks will POST a message to a URL when certain things happen. When a web application enables users to register their own URLs, the users can then extend, customize, and integrate that application with their own custom extensions or even with other applications around the web. For the user, WebHooks are a way to receive valuable information when it happens, rather than continually polling for that data and receiving nothing valuable most of the time. WebHooks have enormous potential and are limited only by your imagination! (No, it can t wash the dishes. Yet.)

You can find out more on Webhooks here: http://www.webhooks.org/ and http://webhooks.pbworks.com/

问题回答

你们经常需要更新数据库,变化的紧迫性如何?

如果数据库更新内容不及时,而且不必要,我可以查阅新版本的启动数据库,如果已经改变,则下载整个新档案。

这笔钱总是从已知的URL公司下载一个小的元数据。 元数据文档载有最新版本的识别资料,以及可以下载数据库版本的地点。 如果该版本的识别特征从已经使用的版本中发生变化,则将下载新版本。 如果该版本的识别特征没有改变,或者如果能够进行核对,则该识别器可使用其版本。

Pro tip:如果你想要显示下载的进展节点,将数据库的规模列入元数据文档。 单元网络往往具有透明度,使内容-Length的头盔脱离了吉大港山区的对策。

如果你考虑利用“协同框架”来管理同步。 如果你能够考虑开放源项目,即开放式综合服务。 您可以做以下辛勤工作:

  • two-way
  • one-way client
  • one-way device
  • bootup

此外,所有修改都自动跟踪,与云层混为一谈。 当网络连接缩小时,你可以直线。 它将跟踪任何变化,并在连接返回时自动与云层同步。 该系统还提供多个装置之间的同步。

此外,对云层的改动是用普什通知进行的,因此,即使数据是在当地储存的,数据也始终存在。

这里与开放源项目链接:

http://code.google.com





相关问题
sqlite3 is chopping/cutting/truncating my text columns

I have values being cut off and would like to display the full values. Sqlite3 -column -header locations.dbs " select n.namelist, f.state, t.state from names n left join locations l on l.id = n.id ...

Entity Framework with File-Based Database

I am in the process of developing a desktop application that needs a database. The application is currently targeted to SQL Express 2005 and works wonderfully. However, I m not crazy about having ...

Improve INSERT-per-second performance of SQLite

Optimizing SQLite is tricky. Bulk-insert performance of a C application can vary from 85 inserts per second to over 96,000 inserts per second! Background: We are using SQLite as part of a desktop ...

Metadata for columns in SQLite v2.8 (PHP5)

How can I get metadata / constraints (primary key and "null allowed" in particular) for each column in a SQLite v2.8 table using PHP5 (like mysql_fetch_field for MySql)? sqlite_fetch_column_types (OO:...

SQLite , Derby vs file system

I m working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate ...

热门标签