[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?

[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 document

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

2011-09-09 Thread Bruce Aloe
/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 sdeasey+gro...@gmail.com wrote: On Wed, Sep 7, 2011 at 3:32 PM, Bruce Aloe brucea...@gmail.com wrote

[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,

[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

[google-appengine] Re: GAE data store benchmark

2011-08-22 Thread Bruce Aloe
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 Aug 21, 2011 8:09 AM, Bruce Aloe brucea...@gmail.com wrote: Hey Robert, Thanks for your reply! My

[google-appengine] Re: GAE data store benchmark

2011-08-21 Thread Bruce Aloe
on GAE 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 brucea...@gmail.com wrote: Hello

[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

[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 da...@soundings.co.nz 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

[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?

[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 noah.mcilra...@gmail.com 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

[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

[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] 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

[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

[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 geoffsp...@gmail.com wrote: On Jun 30, 9:34 am,BruceAloebrucea...@gmail.com

[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] 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

[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

[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

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

2011-06-17 Thread Bruce Aloe
, 2011 at 3:30 PM, Bruce Aloe brucea...@gmail.com wrote: 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

[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

[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

[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