Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Unfortunately, you can't circumvent this restriction, but I can help you model the data in a slightly different way. </p> <p>First off, Bigtable is suited to very fast reads off large databases - the kind you do when have a million people hitting your app at the same time. What you're trying to do here is a report on historical data. While I would recommend moving the reporting to a RDBMS, there is a way you can do it on Bigtable. </p> <p>First, override the put() method on your item model to split the date before saving it. What you would do is something like</p> <pre><code>def put(self): self.manufacture_day = self.manufacture_date.day self.manufacture_month = self.manufacture_date.month self.manufacture_year = self.manufacture_date.year super(self.__class__, self).put() </code></pre> <p>You can do this to any level of granularity you want, even hours, minutes, seconds, whatever.</p> <p>You can apply this retroactively to your database by just loading and saving your item entities. The <a href="http://code.google.com/p/appengine-mapreduce/wiki/GettingStartedInPython" rel="nofollow">mapper</a> is very convenient for this.</p> <p>Then change your query to use the inequality only on the item count, and select the days / months / years you want using normal equalities. You can do ranges by either firing multiple queries or using the IN clause. (Which does the same thing anyway).</p> <p>This does seem contrived and tough to do, but keep in mind that your reports will run almost instantaneously if you do this, even when millions of people try to run them at the same time. You might not need this kind of scale, but well... that's what you get :D</p>
    singulars
    1. This table or related slice is empty.
    1. POInequality Filters on a date and a number
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSudhir Jonathan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThanks for the answer. The issue is I need to "get all the item_names which have been shipped more than x_items and manufactured _greater_ than some_date". Even if I split the date into day, month and year, I will not get all the records using normal equalities for day, month and year.
      singulars
      1. PO
      1. USPrashanth Babu
    2. COIf you want records after October 15, 2010, you'll search for year = 2011, year = 2010 & month = 12, year =2010 & month = 11, year = 2010 & month = 10 & date = 31... you get the idea. Told you it was contrived :D
      singulars
      1. PO
      1. USSudhir Jonathan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload