[google-appengine] Sending result tuples through many http responses

2011-06-10 Thread Bruce Aloe
Hello, I store quite a lot of data (e.g 10 million) tuples (rows) in my Person kind (table) at GAE datastore. Now i want to query the Person kind from my web application. For example my web application sends a query (e.g select * from Person where height < 2) through a http request to my server (

[google-appengine] Query a kind with a lot of entities

2011-06-10 Thread Bruce Aloe
Hello, I have a system with client-server architecture. The client is actually some java code and the server is some python code running in GAE. When i need to query the kind (table) i defined in GAE data store, i actually call a java function and it takes the query (e.g select * from Person where

[google-appengine] define inheritance relationship between kinds in GAE

2011-06-14 Thread Bruce Aloe
Hello, I want to define two kinds (tables): Person (PersonId, age, name) and Teacher (PersonId, age, name, teaching experience) in my GAE datastore and Person is the superclass of Teacher. I want to define inheritance relationship between Person and Teacher, so Teacher kind inherites PersonId, age

[google-appengine] Make join query among kinds in GAE

2011-06-16 Thread Bruce Aloe
Hello, In a simple case, suppose i have two kinds (tables) stored in GAE datastore: Employee (EmployeeId, Name, Salary, StartDate, DepartmentId) Department(DepartmentId, DepartmentName) For Employee kind, EmployeeId is the unique key and DepartmentId is the join attribute for Employee to make jo

[google-appengine] Re: uploading data to GAE datastore

2011-06-16 Thread Bruce Aloe
Hi, I use python runtime environment and met the same problem. I use this command to upload data to master slave datastore: appcfg.py upload_data --config_file=bulkloader.yaml -- filename=xxx.csv --kind=xxx C:\ According to GAE document i should use url instead of local directory C:\ that i

[google-appengine] Re: Make join query among kinds in GAE

2011-06-17 Thread Bruce Aloe
engine > Reddit:http://www.reddit.com/r/appengine > > > > On Thu, Jun 16, 2011 at 3:30 PM, Bruce Aloe wrote: > > Hello, > > > In a simple case, suppose i have two kinds (tables) stored in GAE > > datastore: > > > Employee (EmployeeId, Name, Salary, Start

[google-appengine] Passing parameters through http request

2011-06-22 Thread Bruce Aloe
Hello, I have put some python code in GAE and my client (some java code) each time sends a http request with a query to python code. The python code receives the query and run it, then generate the query result. The python code actually uses get_all function to get the query passing from client to

[google-appengine] get statistic data for each property of a kind in GAE

2011-06-22 Thread Bruce Aloe
Hello, Suppose i have a kind named Employee with millions of tuples stored in GAE. The Employee kind has properties/attributes like EmployeeId, EmployeeName, Salary, StartDate, DepartmentId. I would like to know the selectivity of each properties/attributes. In order to do that, i want an very ef

[google-appengine] Store data in GAE

2011-06-23 Thread Bruce Aloe
Hello, Suppose i have defined a database schema in GAE, it has Employee, Department, etc kinds as it could be defined in Relational database. One askes me why don't you just use relational database server like MSSQL, MYSQL, etc to store your data. I was trying to answer this kind of question by te

[google-appengine] GAE data store and Google BigTable

2011-06-30 Thread Bruce Aloe
Hello, Since there is not much information about GAE data store and Google BigTable, I am wondering the relationship between them? If one make query to GAE data store, can one say it is querying Google BigTable? Is there any paper or link describes it? Thanks! Bruce -- You received this mess

[google-appengine] GAE data store indexing

2011-06-30 Thread Bruce Aloe
Hello, I have read the online documentation about GAE data store index, but don't get it well. Suppose i have a kind (table) Employee, with columns (attributes) (EmployeeId, Age, Position, Salary, StartingDate), and 1 employees are stored in the data store. Does it mean all the attributes (E

[google-appengine] Re: GAE data store indexing

2011-06-30 Thread Bruce Aloe
Hello Geoffrey, you mentioned "2 indexes (one in each direction) will be created for each property for each entity. " What are the 2 indexes and why? what are the 2 indexes names? Bruce On Jun 30, 7:51 pm, Geoffrey Spear wrote: > On Jun 30, 9:34 am,BruceAloe wrote: > > > Hello, > > > I have rea

[google-appengine] Cloud computing forum

2011-06-30 Thread Bruce Aloe
Hello, I am looking for a popular cloud computing forum. Do you have any recommendation? Thanks! Bruce -- 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

[google-appengine] GAE cursor

2011-07-01 Thread Bruce Aloe
Hello, Google web app provides cursor facility and it enables the application to return pieces of the large query result. My question is: Does the cursor returns the piece result chunk by chunk or row by row? Thanks! Bruce -- You received this message because you are subscribed to the Google

[google-appengine] Maximum query result size by each Http response

2011-07-06 Thread Bruce Aloe
Hello, I have a client (some java code) and server (some python code defined in GAE) system architecture. Http protocol is the communication protocol between client and server. Once a client sends a query to server and the server takes it and run it with GAE query interface API. The query result i

[google-appengine] Re: Maximum query result size by each Http response

2011-07-07 Thread Bruce Aloe
Could anyone give an exact number? and its reference (the web link, etc)? On Jul 7, 12:10 pm, Noah McIlraith wrote: > I'm pretty sure there's a limit, but IIRC it's at least 10MB, most likely > more than enough for query results. > > Additionally, you may be interested in the Remote API. -- You

[google-appengine] Re: Maximum query result size by each Http response

2011-07-08 Thread Bruce Aloe
Thanks for all the answers! On Jul 7, 11:20 pm, David French wrote: > http://code.google.com/appengine/docs/java/runtime.html#Responseshttp://code.google.com/appengine/docs/python/runtime.html#Responses > LimitAmountrequest size32 megabytesresponse size10 megabytesrequest duration30 > seconds --

[google-appengine] The client and server communication protocol

2011-07-08 Thread Bruce Aloe
Hello, I have a client (some java code) and server (some python code defined in GAE) system architecture. I know Http protocol could be used as the communication protocol between client and server. Could other protocols such as SOAP be used as communication protocol between client and server? I

[google-appengine] GAE data store benchmark

2011-08-19 Thread Bruce Aloe
Hello, I have defined some models(tables) in GAE data store and upload little amount of data to each of them using GAE bulkloader. I have also written a system in Java to query the data stored in the models of GAE. Now i want to test the scalability of my system. Therefore i need a benchmark to ge

[google-appengine] Re: GAE data store benchmark

2011-08-21 Thread Bruce Aloe
E using task queues or > backends. You might find generating the data using GAE is more efficient > than doing it locally and uploading the data.  How you generate that data > will depend very much on your data. > > Robert > > On Aug 19, 2011 10:59 AM, "Bruce Aloe"

[google-appengine] Re: GAE data store benchmark

2011-08-22 Thread Bruce Aloe
distributions and insert matching > entities.  If you've got complex relationships between entities it will be > trickier, since you'll need to know about the patterns those follow, but the > same ideas apply. > >   Hope that helps a little bit. > > Robert > > On A

[google-appengine] GAE data store and Google Bigtable

2011-09-07 Thread Bruce Aloe
Hi, I store some data in GAE data store and can not find any documents regarding the relation between GAE data store and Google Bigtable. Can one say querying GAE data store is the same as querying Google Bigtable? GQL is the query language to query GAE data store, is it right to say using GQL t

[google-appengine] Re: GAE data store and Google Bigtable

2011-09-09 Thread Bruce Aloe
high > replication:http://www.slideshare.net/ikailan/2011-auggddmexicocityhighreplicatio... > > -- > Ikai Lan > Developer Programs Engineer, Google App Engine > plus.ikailan.com | twitter.com/ikai > > > > On Wed, Sep 7, 2011 at 9:36 AM, Stephen wrote: > > On Wed,

[google-appengine] Re: GAE data store and Google Bigtable

2011-09-09 Thread Bruce Aloe
Hi, I noticed the figure in slide 7 of that presentation and it presents the datastore layers. However, what i am out for is the figures that shows the visualized relation among GAE datastore, Megastore and Bigtable. For example, Megastore contains GAE datastore, Bigtable contains Megastore, may

[google-appengine] "like" operator in GQL

2011-09-25 Thread Bruce Aloe
Hello, SQL supports "like" operator. I am wondering whether GQL supports the "like" operator or not. I have been looking at the GQL reference: http://code.google.com/appengine/docs/python/datastore/gqlreference.html However, the document doesnot mention anything it. Is there any official docume

[google-appengine] Google Cloud SQL

2011-10-14 Thread Bruce Aloe
Hello, I am a user of GAE data store and use GQL to query my models. I just saw the article about Google Cloud SQL published on October 6, 2011. Since GQL has so many limitations, therefore Google Cloud SQL sounds quite interesting for me. Where can i use it and how to use it? Any tutorial?