[google-appengine] Re: [objectify-appengine] Doing Totals/aggregates

2017-01-26 Thread Jeff Schnitzer
I use Postgres. Replicate a subset of your entity data to a datastore that supports aggregations. Assuming your dataset fits in a traditional RDBMS, they’re awesome for aggregations and ad-hoc queries. The datastore makes an awesome primary datastore because it is zero maintenance and never

[google-appengine] Re: [objectify-appengine] Doing Totals/aggregates

2017-01-26 Thread Rajesh Gupta
Hello, No, we cannot do bigquery replication, as invoices may get deleted and updated. We do these reports in a task, and tasks write to memcache the report data. Any json technologies here?. Can the invoice list be written using jackson as json, and use any json query technologies. On Thu,

[google-appengine] Re: [objectify-appengine] Doing Totals/aggregates

2017-01-26 Thread Nicholas Okunew
1. You need to remove all doubles and use bigdecimal or joda money. If you don't know why, google it. 2. If you want to do adhoc reporting, consider replicating to bigquery and running from there. If you don't want to do that, queries in batches on backends is the way to go, but this kind of