I can jump in for #2. There is a lot of detailed info about the datastore in the wiki here if you like: http://wiki.openbluedragon.org/wiki/index.php/GoogleAppEngine:Datastore
OpenBD provides a series of functions to query the datastore like googleWrite(), googleRead() and googleQuery() (there are plans to rename/add functions to match adobe's hibernate implementation), as well as cfquery integration like this: <cfquery name="oldSmiths"> select from Employee where lastName == 'Smith' && age >= 25 order by age asc </cfquery> Something you should know relating to your phrase "If I would like to use the bigtable db from Google instead of a relational db" is that not only can you use it, but you actually have no choice but to use it. The GAE environment has some significant differences from a regular environment, one being that you can't hook into outside systems like you are used to. For example even to load an outside url, you have to use their url fetch api. There are of course projects being worked on to provide a relational db in the gae environment using H2 (actually that's Vince's project too!), but again that's a db hosted in the GAE environment itself. Hope that helps, Baz On Wed, Nov 4, 2009 at 12:55 PM, Rainer <[email protected]> wrote: > > Hi guys, > > It's really great to see what effort you are making at OpenBD's to get > it running in GAE. > > Vince, I have 3 questions: > 1) Do you know if the guys from ColdBox are open for porting their > fine framework to GAE? > 2) Maybe a new-bie question, but what if I would like to use the > bigtable db from Google instead of a relational db, would it be > possible to query against this bigtable db with cfquery? In other > words, will there be some kind of db-selector attribute for cfquery? > 3) Do you maybe post new features to a twitter account? > > Greetings from Utrecht, The Netherlands. > > Rainer (@rainerschreiber) > > > > On Sep 8, 10:30 pm, Vince Bonfanti <[email protected]> wrote: > > HiPaul, > > > > I'm glad to see you're interested in GAE--I saw the video on your blog > > and thought it was great. Some thoughts in response to your questions: > > > > 1) CFDIRECTORY and CFFILE work almost exactly the same on OpenBD-GAE > > as they do on "regular" OpenBD (and any CFML engine). The two > > exceptions are: (a) you can't access files/folders outside the webroot > > directory; and, (b) any files that are deployed as part of your "war" > > are treated as read-only. I thought I had documented this on the Wiki, > > but it looks like I haven't gotten to it yet (yes, there's some > > "magic" that makes this work--it's called GaeVFS > > -http://code.google.com/p/gaevfs/). > > > > 2) We're almost to the point that we were planning to solicit > > framework authors to start working with us to get their framework > > running on OpenBD-GAE. Obviously, we'll give priority to frameworks > > that have users and authors who are interested in putting some effort > > into working with us to make this happen. I know there are two > > prominent framework authors on this list--maybe one of them will step > > up (Peter? Adam?). > > > > 3) We've close to having full SQL relational database support on > > OpenBD-GAE (again, thanks to the magic of GaeVFS, and the H2 database > > -http://code.google.com/p/gaevfs/wiki/H2GAE). > > > > 4) Our plans are to implement full compatibility with the CF9 ORM > > feature in OpenBD-GAE, so if any framework author is planning to > > upgrade to ORM, then OpenBD-GAE will be syntax-compatible (though I > > expect the performance and scalability of "ORM" on OpenBD-GAE to be > > vastly superior to CF9). > > > > Vince > > > > On Tue, Sep 8, 2009 at 5:07 PM,PaulKukiel<[email protected]> wrote: > > > I have a new project in mind that I am about to start work on. I’d like > > > to > > > use a framework. Being that I am not too funny and willing to work with > > > “what works for me best” I’m open to investigating any of the cfml > > > frameworks. > > > > > This project will involve Google App engine and I know some things may not > > > work due to directory and file access so I was wondering what experience > > > people have had and if anyone has any of the cf frameworks running on > > > OpenBD > > > GAE. > > > > >Paul. > > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
