TurboManage

David Chandler's Journal of Java Web and Mobile Development

  • David M. Chandler


    Web app developer since 1994 and former Developer Advocate with Google now residing in Colorado. Besides tech, I enjoy landscape photography and share my work at ColoradoPhoto.gallery.

  • Subscribe

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 241 other followers

  • Sleepless Nights…

    January 2010
    S M T W T F S
    « Dec   Feb »
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
    31  
  • Blog Stats

    • 876,388 hits

How to do joins in AppEngine

Posted by David Chandler on January 25, 2010

So the AppEngine DataStore DOES do joins, after all… using the mysterious list properties. This is highly recommended viewing for anyone building a large social application or otherwise looking for a simple alternative to a SQL inner join. You cannot organize your data model quite the same as you would in a relational database, but you can easily simulate querying an intersection table.

Building Scalable, Complex Apps on AppEngine

Advertisements

3 Responses to “How to do joins in AppEngine”

  1. Rusty Wright said

    I think that, for me at least, part of the problem with understanding the GAE Big Table data store is that Google pushes using JDO or JPA on the java side for interfacing with the data store. Both of those are heavily oriented to SQL databases, even though JDO can work with lots of non SQL things. I’m thinking that what’s needed is some new ORM that’s designed from the start for non SQL databases, or designed just Big Table. For GAE, at the moment, there are Twig, SimpleDS, and Objectify, and probably others.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: