Hi guys, Yaac (Yet Another Admin Console) 0.2 is just released, which helps you to do lots of things you can't do with existing admin console. Here is an incomplete list:
Extended GQL (EGQL) Aggregation functions, used together with group by clause and having clause (optional): MAX, MIN, SUM, COUNT, AVG Scalar functions: UCASE / LCASE / MID / LEN / ROUND / FORMAT / NOW / TYPE / DATETIME / KEY(* New*) / USER(*New*) / GEOPT(*New*) Inter properties comparison in where clause: eg, *where property1 = property2* Powerful Arithmetic Expressions: eg, *where property1 + 5 < property2 * (2 + property3)* Powerful boolean expressions: eg, *where condition1 and (condition2 or condition3) and not condition4* Like query: eg, *where ucase(property1) like "%abc%" (new)* More details about EGQL syntax please refer to this page: http://code.google.com/p/yaac/wiki/EGQLReference Datastore Browser: Download datastore blob / text and blobstore blob directly (*new*) Better display keys in list property (*new*) Datastore Statistics: More detailed breakdown on root / non root statistics Features comming soon: sql like Insert / update / delete statements Filter in datastore browser (triditional GQL) sub-query table join billing estimation before query execution (how expensive is the query, more specifically how many datastore operations?) Cross namespace query and more... Sandbox (http://sandbox.yetanotheradminconsole.appspot.com/) is updated with the latest version. 86K soccer matches are uploaded. Login with your google account and play with it! For example, for all *Arsenal*'s away draw matches against those end with *united *having average full time goals are more than 1, we can use following EGQL to query: * select HOME_TEAM, AWAY_TEAM, count(1), sum(FTHG + FTAG) from MATCH where FTHG = FTAG and AWAY_TEAM = "Arsenal" and lcase(HOME_TEAM) like "%united" group by HOME_TEAM, AWAY_TEAM having sum(FTHG + FTAG) / count(1) > 1 * You can also use this link to try new look of entity viewer (entity with grandparent with almost all datatypes) http://sandbox.yetanotheradminconsole.appspot.com/#editor:ahhzfnlldGFub3RoZXJhZG1pbmNvbnNvbGVydwsSFktJTkRfV0lUSF9BTExfUFJPUEVSVFkYZAwLEhZLSU5EX1dJVEhfQUxMX1BST1BFUlRZIhlzdHJpbmdfa2V5X3dpdGhvdXRfZW50aXR5DAsSFktJTkRfV0lUSF9BTExfUFJPUEVSVFkiCnN0cmluZ19rZXkM To deploy Yaac to your own domain refer to this page: http://code.google.com/p/yaac/wiki/DeployGuideline Any feedback is welcome! -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine/-/LM8kcMHIMhsJ. To post to this group, send email to google-appengine@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
