Google App Engine上的只读关系数据库？ [英] A Read-Only Relational Database on Google App Engine?

问题描述

我有一个中等大小（〜100mb）的只读数据库，我想把它放在谷歌应用程序引擎上。我可以把它放到数据存储中，但是数据存储有点慢，没有关系特性，还有其他许多令人沮丧的限制（这里不会介绍）。另一种选择是将所有数据加载到内存中，但我很快就达到了谷歌的配额。最后的选择是使用django-nonrel + djangoappengine，但是恐怕这个软件包还处于初期阶段。

理想情况下，我想创建一个读取 - 仅限使用blobstore作为其数据源的sqlite数据库。这可能吗？

解决方案

我不认为你可能会找到类似的东西......当然不会超过blobstore 。因为如果所有数据都存储在一个blob中，则必须将整个数据库读入内存以进行任何操作，并且您说过不能这样做。

<使用数据存储作为后端更合理，但数量并不多。在那里提供SQLite驱动程序的一个大问题就是实现事务语义，因为这是GAE为了高可用性而从你身上拿走的关键东西，所以很难想象有人会写很多麻烦来写这样的东西。 p>

I have a medium size (~100mb) read-only database that I want to put on google app engine. I could put it into the datastore, but the datastore is kind of slow, has no relational features, and has many other frustrating limitations (not going into them here). Another option is loading all the data into memory, but I quickly hit the quota imposed by google. A final option is to use django-nonrel + djangoappengine, but I'm afraid that package is still in its infancy.

Ideally, I'd like to create a read-only sqlite database that uses a blobstore as its data source. Is this possible?

解决方案

I don't think you're likely to find anything like that...surely not over blobstore. Because if all your data is stored in a single blob, you'd have to read the entire database into memory for any operation, and you said you can't do that.

Using the datastore as your backend is more plausible, but not much. The big issue with providing a SQLite driver there would be implementing transaction semantics, and since that's the key thing GAE takes away from you for the sake of high availability, it's hard to imagine somebody going to much trouble to write such a thing.

这篇关于Google App Engine上的只读关系数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！