东京橱柜vs SQLite3在iPhone上 [英] Tokyo Cabinet vs SQLite3 on iPhone

问题描述

有谁在iPhone上使用Tokyo Cabinet？我有兴趣看看它和SQLite3之间是否有任何真实的性能差异。

Has anyone used Tokyo Cabinet on the iPhone? I'm interested to see if there are any real world performance differences between it and SQLite3.

此外，SQLite 3具有SQL的表现力，东京橱柜有任何种类的查询语言？

Also, SQLite 3 has the expressive power of SQL, does Tokyo Cabinet have any kind of query language?

任何输入都会非常感谢。

Any input would be greatly appreciated, thanks.

推荐答案

我没有在iPhone上使用，具体，但我已经使用了这两个为各种项目。正如你所指出的，SQLite提供SQL查询语言，这意味着你在如何搜索和查找数据方面有更多的灵活性。假设你对SQL很熟悉，你将能够轻松地过滤，关联和聚合结果。

I have not used either on the iPhone specifically, but I have used both for various projects. Like you pointed out, SQLite does provide SQL query language which means you have much more flexibility in how you can search for and find data. Assuming you are comfortable with SQL you will be able to easily filter, relate, and aggregate results.

Tokyo Cabinet提供了一种不同类型的数据存储系统，因为它是一个键值存储。顾名思义，这些系统用于存储（关键，值）对。存储到TC中的数据必须具有可以被引用的唯一键，并且它只能被该键引用。访问TC的接口基本上是value = get（key）和set（key，value）。

Tokyo Cabinet provides a different type of data storage system in that it is a key-value store. As the name implies, these systems are for storing (key,value) pairs. Data stored into TC must to have a unique key which it can be referenced, and it can only be referenced by that key. The interface for accessing TC is basically value=get(key) and set(key,value).

从查询角度来看，访问TC大致相当于使用SQLite，只允许主键字段和一个其他数据字段。

From a query perspective accessing TC is roughly equivalent to using SQLite and only allowing primary key fields and one other data field.

TC的主要优点是性能。如果和如何更好地取决于工作量。一般来说，如果你需要的是一个键值存储，那么你应该使用TC，但如果你需要一个SQL查询语言，那么SQLite就是。

The major benefit of TC is performance. If and how much better it would be depends heavily on the workload. In general, if all you need is a key-value store then you should go with TC, but if you need a SQL query language then SQLite it is.

这篇关于东京橱柜vs SQLite3在iPhone上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！