You aren't constrained, you just have to write code for the way the platform works.
With GQL you write queries to get what you need in the most optimized way for your data, and do so in each pass of the data set you want. Say you want to get all the people named John Smith without the middle initial E. You can do that as Get all people whose Middle Initial != E Then all that have First name John Then all that have Last name Smith That's horribly inefficient if you have a list of everyone in the US, But if you had a data set that was the People Named John Smith and their wives Club, it might be the most efficient method for getting the result. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of David Stone Sent: Friday, June 03, 2011 1:56 AM To: Google App Engine Subject: [google-appengine] why GQL from GAE has so many limitations? Hello, I have read http://code.google.com/appengine/docs/python/datastore/gqlreference.html and try to query a kind (table) i defined. I have a "bad" feeling about this GQL since it has so many limitations compared with SQL. For example, A GQL query with more than one inequality (<, >, <=, >=, !=) on different attributes is not supported and can't select specific column value, etc. For a developer point of view, it really constrains my system development. My question is that why GQL has so many limitations? and what is the point of using GAE and why not using Amazon cloud, or Microsoft Azure, etc? Hope to hear your valuable views. David -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en. -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
