GQL Reference - Google App Engine - Google Code - The Diigo Meta page

• 18 Oct 08
  

  Gautham

  gql google-appengine gdd delicious-import

• 21 Jun 08
  

  Vincent Tsao

  GQL Google Reference

• 11 Jun 08
  

  Ken Wei

  GQL google AppEngine

  • A GQL query cannot perform a SQL-like "join" query.
  • GQL does not have an OR operator
  • The left-hand side of a comparison is always a property name.
  • The datastore returns a maximum of 1000 results in response to a query, regardless of the LIMIT and OFFSET used to fetch the results.

  2 more annotations...

• 05 Jun 08
  

  feng bo
  • As with SQL, GQL keywords are case insensitive. Kind and property names are case sensitive.
  • A GQL query cannot perform a SQL-like "join" query.
  • GQL does not have an OR operator, however, the IN operator is supported which provides a limited form of OR.
  • The LIMIT can also include an offset to skip that many results to find the first result to return. An optional OFFSET clause can specify an offset if no LIMIT clause is present.
  • The 1000 results includes any that are skipped using an OFFSET, so a query with more than 1000 results using an OFFSET of 100 will return 900 results.

  3 more annotations...

• 08 Apr 08
  

  Mike Koss

  GQL, Google's AppEngine query language is a very limited subset of SQL. - No "not equal" (!= or <>) - No "OR" clauses This presumably optimizes returning the results from a distributed table in storage.

  sql google query language app engine

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.