For application developers who would prefer SQL over BigTable, and who do not insist on Google hosting the whole thing, there is at least one third party SQL database hosting service that makes databases accessible from GAE applications.
The database queries and responses are transferred over https, results formatted as JSON or XML. There is a python DB API 2 module to make database access as easy as with any DB API application. That service is Rdbhost, at http://www.rdbhost.com. David Keeney On Jun 25, 2:31 pm, rvjcallanan <vinc...@callanan.ie> wrote: > Hi all, > > I would like to encourage some discussion on the hosted SQL aspect of > GAE for Business. I am assuming that this variant of GAE is not just > for Intranet users but will also be able to host a public-facing web > application with no particular end user limits. > > It strikes me that all of the previous talk about abandoning RDBMS on > the altar of scalability fails to recognise the following realities: > > 1. RDBMS is still the best choice for many applications. > 2. Scalability requirements usually correlate with "potential" end- > user numbers. > 3. User data is usually independent. > 4. An individual user's data can have definable limits. > 5. These limits can be enforced using application-specific > functionality e.g. archiving > > With that in mind, is it possible for the boffins in the GAE for > Business team to come up with a hosted SQL service which achieves the > following: > > 1. Independent SQL service "containers" can be added through the > control panel. > 2. Within each container, database schemas can be defined in the usual > way. > 3. An "unlimited" number of database instances can be created from > each schema. > 4. Instances can be created on-the-fly (programmatically) e.g. as end > users sign up. > 5. Hosting cost is NOT a function of instances but overall storage and > CPU cycles. > 6. Replication and failover can work on a per instance basis > 7. Instances can revert to "sleep mode" after a defined period of > inactivity. > 8. During sleep mode, instances take up no server resources apart from > disk storage. > 9. Instance wake-up should be quick and barely noticeable. > 10. A common "admin" database can be used for storing global > information and logs > > I think an on-line accounting application best explains what I am > trying to achieve here. When a customer signs up for the service, a > database instance is created from a complex schema for the first > financial year. Whenever a financial year is closed off for a given > customer, its database instance is archived and a new instance created > for the next year. This prevents instance storage requirements from > growing indefinitely. > > I think a GAE SQL service that could manage this would be awesome. And > it would perfectly compliment what can be achieved with BIGTable -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@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.
