[Python-talk] Google app engine

[Kent Johnson]

Kent Johnson wrote:
> Yes, I'm not saying BigTable is bad, but I think it does have a 
> different sweet spot than, say, Postgres. I have an app that frequently 
> does three- and four-table joins, I'm not sure how I would write that in 
> GAE datastore. I imagine it would require some thought and re-architecting.

Here is a thread on the GAE group that addresses this pretty well:
http://groups.google.com/group/google-appengine/browse_thread/thread/caa713957b9d6058#

Essentially the advice is to drastically denormalize your DB. Notable 
quote: "A good way structure db's for big table is to pick the ugliest
solution and that's the one that will work the best."

where 'ugliest' is from the point of view of traditional relational DB 
design.

Kent