OpenBD cfcs the Datastore and an Enterprise Manager on Google App Engine

The dataStore is nice it works well for storing cfc's but what do you do if you need to visually inspect the data without writing code. Ie Whats the "Enterprise manager" for the datastore?

Well it's actually built into the admin console in you google app engine account. Before I took some time to explore my admin console I was saving data and it was effectively lost to me ( test data ) but now I am able to review/edit/delete the data.

You can also run GQL:

GQL is a SQL-like query language suitable for querying the App Engine datastore. For a complete discussion of the GQL syntax and features, see the GQL Reference.

Here is the OpenBD DataStore documentation.

Interestingly the SQL is slightly different between the admin console and the cfml code:

<br /> -- OpenDB code ---<br /> select from Visitor<br /> where city == 'Melbourne'<br /> <br /> --- app engine console ---<br /> SELECT * FROM visitor <br /> where city = 'Melbourne'<br /> <br />

Here is how to Setup Open BD on GAE and here is the sample app on GAE

Admin Console:



Select the "Collection/Table"



GQL:



Edit: