Hi Ryan, Thanks for the quick reply, and for clarifying this to me, even if those are not good news to me.
If complex reporting system is required, I think it is reasonable enough to count on third-part solutions (even you own) to do that, and do not get away from the purpose of GAE. I will think of something on how to manage that on my end. Just a thought though, as this service spreads, more and more people will require this kind of things, because it would just be so cool to leave the reporting integrated in a single solution. Thinking about a third-party solution, we could also do something stupid as downloading the datastore data (let's say, on a daily basis, and only incremental to avoid spending all available quota on this), processing all data mining required and uploading back to datastore. Dirty, but sounds like a solution. Thanks anyway for your help! On May 6, 3:12 am, ryan <ryanb+appeng...@google.com> wrote: > hi bruno! thanks for the post, this is a great question. > > the short answer is that the datastore simply doesn't support data > warehouse or data mining well. it's doable, but far from ideal, for > the reasons you've mentioned. it's aimed at serving webapps, which > it's good at, but not at ad hoc reports or queries. > > for use cases like counters, if they're needed for end user requests, > we usually recommend updating them on writes, as you mentioned, but > you're right that that doesn't work for the arbitrary number of > reports or queries that data warehouses traditionally support, nor > does it work for the ad hoc queries often needed for data mining and > business intelligence. > > right now, if you need an industrial strength data warehouse, i'd > recommend bulk downloading your data and using a third party solution. --~--~---------~--~----~------------~-------~--~----~ 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-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 -~----------~----~----~----~------~----~------~--~---