Google App Engine:为具有 SQL 背景的人员介绍他们的数据存储 API?

发布于 2024-07-17 08:03:58 字数 323 浏览 5 评论 0原文

除了 Google 提供的 Google App Engine 文档之外,是否有人还有任何好的信息,该文档为具有 MS SQL 背景的人员提供了很好的概述,以移植他们的知识并有效地使用 Google App Engine 数据存储 API。

例如,如果您有一个自行创建的用户表和消息表

,其中用户和消息之间存在关系(通过 UserID 连接),那么该结构在 Google App Engine 中将如何表示?

SELECT * FROM Users INNER JOIN Message ON Users.ID = Message.UserID

Does anyone have any good information aside from the Google App Engine docs provided by Google that gives a good overview for people with MS SQL background to porting their knowledge and using Google App Engine Data Store API effectively.

For Example, if you have a self created Users Table and a Message Table

Where there is a relationship between Users and Message (connected by the UserID), how would this structure be represented in Google App Engine?

SELECT * FROM Users INNER JOIN Message ON Users.ID = Message.UserID

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(6

爱情眠于流年 2024-07-24 08:03:59

我认为这是基础知识:键和实体组
在 appengine 文档中查找它。 (我是新来的,所以无法发布链接)

I think this is the basics : Keys and Entity Groups
look for it in appengine docs. (I'm new here so can't post a link)

杀お生予夺 2024-07-24 08:03:59

我曾研究过它,但不是专家,尽管谷歌应用程序引擎是非常好的东西,它是未来,因为它实现了平台即服务和软件即服务。 Google应用程序引擎提供非关系数据库。 所以你真的不能在这里写关系。

问候,
高拉夫·J

I have worked on it but not a expert though Google app engine is very good thing and it is the future as it implements Platform as a Service and Software as a Service. Google app engine provides a non- relational database. So you cantreally write relationships here.

Regards,
Gaurav J

半夏半凉 2024-07-24 08:03:59

这些链接很棒,但主要偏向于 python,我使用的是 GWT,因此必须使用 GAE 的 java 风格,有没有人有任何示例说明如何在 java 版本的 GAE 中实现这些“连接”等效项?

干杯,
约翰

These links are great, but are predominantly python biased, I am using GWT, and therefore have to use the java flavour of GAE, does anyone have any examples of how to achieve these "join" equivalencies in the java version of GAE?

Cheers,
John

匿名。 2024-07-24 08:03:59

独立的 GAE SDK 很难用于将数据放入 Google App Engine 数据存储中以及从 Google App Engine 数据存储中检索数据。

“Objectify”是一个 GAE 扩展,它使这些操作变得更加容易。 可以在此处找到 Objectify wiki 和源代码。 我强烈建议在您的 GAE 项目中使用 Objectify。

http://code.google.com/p/objectify-appengine/

以下是有关将 Objectify 与应用程序引擎结合使用的一些教程。 按照这些教程,您将立即存储和检索数据。

http://www.fishbonecloud.com /2010/11/use-objectify-to-store-data-in-google.html

The standalone GAE SDK is pretty difficult to use for putting data into and retrieving data from the Google App Engine data store.

"Objectify" is a GAE extension that makes these operations much easier. The Objectify wiki and source code can be found here. I strongly recommend using Objectify in your GAE project.

http://code.google.com/p/objectify-appengine/

Here are a couple of tutorials on using Objectify with the app engine. Follow these tutorials and you will be storing and retrieving data in no time.

http://www.fishbonecloud.com/2010/11/use-objectify-to-store-data-in-google.html

与他有关 2024-07-24 08:03:58

这是一个很好的链接:使用 Google App Engine 进行一对多加入。

http://blog.arbingersys。 com/2008/04/google-app-engine-one-to-many-join.html

这是另一个很好的链接:使用 Google App Engine 进行多对多加入:

http://blog.arbingersys.com/2008/04/google-app- engine-many-to-many-join.html

以下是关于上述两个链接的精彩讨论:

http://groups.google.com/group/google-appengine/browse_thread/thread/e9464ceb131c726f/6aeae1e390038592?pli=1

我个人认为讨论中的此评论提供了有关 Google App Engine 数据存储的丰富信息:

http:// /groups.google.com/group/google-appengine/msg/ee3bd373bd31e2c7

规模化后,你最终会做很多事情
看似错误但实际上是错误的事情
我们所需要的数字
跑步。 去看 eBay 的演讲。 或者
阅读有关有多少数据库的帖子
实例 FaceBook 正在运行。

简单的事实是,我们学到了什么
关于在大学很棒
小型企业自动化应用程序
中型企业应用程序,其中
负载是可预测的,并且有
有足够的钱购买服务器
需要处理 50 的负载
人们进行数据输入
账目或业务规划以及
控制应用程序....

进行了更多搜索,发现了这篇 Google 文档文章:

http ://code.google.com/appengine/articles/modeling.html

App Engine 可以轻松创建
使用数据存储之间的关系
可以代表的实体
现实世界的事物和想法。 使用
需要时参考属性
关联任意数量的
重复类型的信息
单一实体。 当您
需要允许很多不同的
共享其他实例的对象
彼此之间。 你会发现
这两种方法将为您提供
包含您需要创建的大部分内容
优秀应用程序背后的模型。

Here is a good link: One to Many Join using Google App Engine.

http://blog.arbingersys.com/2008/04/google-app-engine-one-to-many-join.html

Here is another good link: Many to Many Join using Google App Engine:

http://blog.arbingersys.com/2008/04/google-app-engine-many-to-many-join.html

Here is a good discussion regarding the above two links:

http://groups.google.com/group/google-appengine/browse_thread/thread/e9464ceb131c726f/6aeae1e390038592?pli=1

Personally I find this comment in the discussion very informative about the Google App Engine Data Store:

http://groups.google.com/group/google-appengine/msg/ee3bd373bd31e2c7

At scale you wind up doing a bunch of
things that seem wrong, but that are
required by the numbers we are
running. Go watch the EBay talks. Or
read the posts about how many database
instances FaceBook is running.

The simple truth is, what we learned
about in uni was great for the
business automation apps of small to
medium enterprise applications, where
the load was predictable, and there
was money enough to buy the server
required to handle the load of 50
people doing data entry into an
accounts or business planning and
control app....

Searched around a bit more and came across this Google Doc Article:

http://code.google.com/appengine/articles/modeling.html

App Engine allows the creation of easy
to use relationships between datastore
entities which can represent
real-world things and ideas. Use
ReferenceProperty when you need to
associate an arbitrary number of
repeated types of information with a
single entity. Use key-lists when you
need to allow lots of different
objects to share other instances
between each other. You will find that
these two approaches will provide you
with most of what you need to create
the model behind great applications.

半窗疏影 2024-07-24 08:03:58

我可以通过视频链接来补充上面的优秀答案吗:

http://sites.google.com/site/io/building-scalable-web-applications-with-google-app-engine

这是 Google 的 Brett Slatkin 的精彩演讲用一个小时的时间来了解您需要考虑应用程序的特殊方式,然后才能期望它能够很好地扩展。 如果您来自关系背景,那么有些真正的 WTF(例如数据库查询中没有 count())会让您陷入困境。

Can I supplement the excellent answer further above with a link to a video:

http://sites.google.com/site/io/building-scalable-web-applications-with-google-app-engine

It's a great talk by Google's Brett Slatkin who talks for an hour about the special way you need to think about your application before you can expect it to scale well. There are some genuine WTFs (such as no count() in db queries) that will cause you to struggle if you are coming from a relational background.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文