Paul Kukiel -
and what i'm interested in.

In my previous OpenBD on Google App Engine post I mention there is no relational database ( yet ) for OpenBD on GAE. There is however the ability to write and save objects directly to Googles Data Store. This sort of feels like working with an ORM but it's even more abstracted as there is not actual database that we can see but we can put objects in this place and run simple queries against the data sets.

Here is a code snippet:

Persisting Data:
<br /> <!--- Create a visitor object ---><br /> <cfset v = createObject("component","Visitor").init() /><br /> <!--- Set some properties on the object ---><br /> <cfset v.setFirstName("Paul") /><br /> <!--- Persist the object in googles datastore in a collection called Visitors ---> <br /> <cfset googleWrite(v,"Visitors") /><br /> <br /> <!--- Retrieve all Visitor objects from the data store This will return an array of Obhjects ( cfc's ) that are in the datastore in the Visitor collection ---><br /> <cfquery name="dataStoreQuery"><br /> select<br /> from Visitors<br /> </cfquery><br />

Notice I must use variable.VariableName rather then cfproperty name="variableName this is explained here.

Here is a small application to demonstrate this in action:

Click Here for a live demo.
( Yes it looks like UniCode just works :) )

Being that it lives on Googles servers the application should be very fast and I expect Googles connections to be very fast you'll notice I do a cfhttp call in every page request you almost don't even notice it's happening.

I really have no metrics to judge/comment on the performance of the datastore but I am working on a project with Rob Parkhill which will make use of the datastore or the SQL engine that's being built so I may have something to report in a few weeks/months.

Here is the official OpenBD wiki entries on the datastore.

Here is the sample app code:




Visitor.cfc