[google-appengine] Re: randomly select entries from a table with very many entries

[Tim Hoffman]

Hi

Do you know your key structure and general distribution?

If for instance you keys are ints, you could randomly choose a key
do a > query and grab the first past that value or a random number
past the first one,
that way you only need to return a few keys/entities.

To make it more likely to get hits, your could have a task queue that
maps the
keys ranges, then your random choice can come from a set of values
more likely to give you an entity.

Just a thought ;-)

T

On Nov 26, 11:35 pm, lein  wrote:
> hello,
>
> i have a table of questions that has many rows. every now and then i
> would have to generate a quiz by randomly selecting questions from
> this table. making a key only query and randomly selecting the
> question keys from the resulting list of keys, takes a lot of CPU
> resources. any suggestions on how i could better do this?
>
> thanks

-- 
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-appeng...@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.

[google-appengine] Re: logging seems be disabled in my app

[pdknsk]

Likewise. I've suddenly also been getting 500 errors, which I can't
investigate since no error is in the logs. Quite frustrating.

-- 
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-appeng...@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.

[google-appengine] Re: logging seems be disabled in my app

[Cameron Henneke]

Actually, I mis-typed - my last logs were at 7:52am Pacific this
morning. So it seems the same time as you, Keakon.

However, just as they mysteriously disappeared, they have now
reappeared after being gone for about 10 hours.

Strange.
-Cameron

-- 
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-appeng...@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.

[google-appengine] Re: logging seems be disabled in my app

[keakon]

Unfortunately, logging in my app still not recovered.

The latest logged message is 9 hours and 40 minutes ago(07:50AM
displayed in the logs, I don't know what timezone).

On Nov 27, 5:48 am, Cameron Henneke  wrote:
> Yes, I am experiencing this as well.
>
> At 9:52am Pacific today my app (id: etsybs) in production just stopped
> logging - all severity levels. There was no change on my part, no
> deployments made or anything else. I waited for two hours and still
> nothing. At that point I tried deploying a new version and that didn't
> help. The logs have worked fine in production for the last two months.
> The logs work fine when running locally on the SDK. The code is fine
> for the app. Nothing has changed in it.http://www.etsyonsale.com
>
> I checked on another app I have and the logs are working fine there
> (gqueues). So I think this problem is only affecting certain appIds.
>
> PLEASE check into this issue. I feel very vulnerable running an app
> with no logs, and it is virtually impossible to release any new
> features if I can't view logs to track down any bugs that were missed.
>
> -Cameron Henneke

-- 
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-appeng...@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.

Re: [google-appengine] Dealing with namespaces and incoming e-mail

[Robert Kluin]

Sounds like you'll need some type of mapping.  Perhaps you could use
the namespace as the mail-handle to save the lookup?




Robert




On Friday, November 26, 2010, Krishna  wrote:
> Hello,
>
> I am building an an app that is multi-tenant and has to support input
> by e-mail for a particular use case.
>
> Do I need to maintain a mapping between all mail handles ( handle>@appid.appspotmail.com) and their corresponding namespace in
> the default namespace ("") or is there a better way to ensure that the
> incoming mail finds its way to the correct namespace?
>
> Thanks,
>
> Krishna
>
> --
> 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-appeng...@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.
>
>

-- 
--
Robert Kluin
Ezox Systems, LLC

-- 
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-appeng...@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.

Re: [google-appengine] Save Configuration Data in Data Store

[Robert Kluin]

Not saying it is the best way, but, out of curiosity, if you will
never need to change the values why not put them In a file that gets
uploaded with the code?  It would be quicker than reading them from
the datastore.



Robert



On Wednesday, November 24, 2010, Peppi  wrote:
> Hi,
>
> In our Java app we maintain configuration constants that we would like
> to have kept in the App Engine data store. These constants are not
> something that will ever be changed inside of the app, so I only need
> to get them into the store once somehow, and then read them as
> required by the app.
>
> My knowledge of the data stores and App Engine in general is quite
> limited, but it is my understanding that you need to provide setters
> and getters for the properties to be stored. However, I don't really
> require the setters. Once the values are initially set in the data
> store (how?), the app only needs to retrieve those values.
>
> Is this possible and if so, what is the best way to implement it?
>
> Thanks.
>
> --
> 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-appeng...@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.
>
>

-- 
--
Robert Kluin
Ezox Systems, LLC

-- 
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-appeng...@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.

[google-appengine] Re: Not authorized - can't log into appengine

[Thijs Brobbel]

Hey,

I'm also unable to get back in my admin panel. I'll email you (Ikai
Lan) my details in a moment.

btw The new style account are still having quite a number of glitches,
but I guess this is not the platform for that ;)

Thanks in Advance,
Thijs

On Nov 24, 10:56 pm, "Ikai Lan (Google)" 
wrote:
> Can you email me details of your domain and app IDs?
>
> --
> Ikai Lan
> Developer Programs Engineer, Google App Engine
> Blogger:http://googleappengine.blogspot.com
> Reddit:http://www.reddit.com/r/appengine
> Twitter:http://twitter.com/app_engine
>
>
>
>
>
>
>
> On Tue, Nov 23, 2010 at 4:36 PM, Jerome  wrote:
> > Unauthorized
> > You are not authorized to access this application.
>
> > I receive that message when trying to log into my google apps
> > appengine account.
>
> > I have tried both appengine.google.com/a/mydomain and
> > appengine.google.com.
>
> > I believe this happened after transitioning my account to the new
> > style google apps account.
> > It happens to some other accounts on my domain, and some it doesn't
> > happen to others that have never been transitioned.
>
> > I've tried talking to Enterprise Apps Support and they say that it is
> > not in their domain.
>
> > Any help?
>
> > --
> > 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-appeng...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > google-appengine+unsubscr...@googlegroups.com > e...@googlegroups.com>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/google-appengine?hl=en.

-- 
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-appeng...@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.

[google-appengine] randomly select entries from a table with very many entries

[lein]

hello,

i have a table of questions that has many rows. every now and then i
would have to generate a quiz by randomly selecting questions from
this table. making a key only query and randomly selecting the
question keys from the resulting list of keys, takes a lot of CPU
resources. any suggestions on how i could better do this?

thanks

-- 
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-appeng...@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.

[google-appengine] Getting my GAE site indexed on Google

[CedarLeaf]

Does any one have any pointers on getting my site indexed on Google?
My site (http://www.cedarleafmusic.com) is a GAE/GWT site for tracking
music artists and albums.

Since my site is a dynamic GAE web application, it only has one html
page, but I have added meta tags, submitted it to Google and submitted
a sitemap to Google Web Master tools.

On the anonymous page prior to login, the static paragraphs are an
HTML widget added to a vertical panel.  Does anyone know if text in
widgets can be read by Google's bot or if I would be better off adding
text directly to the site's HTML page?  Any help would be appreciated.

-- 
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-appeng...@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.

[google-appengine] about dataviewer crash

[Daniel Wang]

Hi:

when use mapreduce truncate a large table,data viewer often crashed for 500
error.
why ?

Daniel

-- 
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-appeng...@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.

[google-appengine] Save Configuration Data in Data Store

[Peppi]

Hi,

In our Java app we maintain configuration constants that we would like
to have kept in the App Engine data store. These constants are not
something that will ever be changed inside of the app, so I only need
to get them into the store once somehow, and then read them as
required by the app.

My knowledge of the data stores and App Engine in general is quite
limited, but it is my understanding that you need to provide setters
and getters for the properties to be stored. However, I don't really
require the setters. Once the values are initially set in the data
store (how?), the app only needs to retrieve those values.

Is this possible and if so, what is the best way to implement it?

Thanks.

-- 
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-appeng...@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.

[google-appengine] Re: logging seems be disabled in my app

[Cameron Henneke]

Yes, I am experiencing this as well.

At 9:52am Pacific today my app (id: etsybs) in production just stopped
logging - all severity levels. There was no change on my part, no
deployments made or anything else. I waited for two hours and still
nothing. At that point I tried deploying a new version and that didn't
help. The logs have worked fine in production for the last two months.
The logs work fine when running locally on the SDK. The code is fine
for the app. Nothing has changed in it. http://www.etsyonsale.com

I checked on another app I have and the logs are working fine there
(gqueues). So I think this problem is only affecting certain appIds.

PLEASE check into this issue. I feel very vulnerable running an app
with no logs, and it is virtually impossible to release any new
features if I can't view logs to track down any bugs that were missed.

-Cameron Henneke

-- 
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-appeng...@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.

[google-appengine] Re: logging seems be disabled in my app

[Oboero Admin]

On Nov 26, 1:01 pm, 风笑雪  wrote:
> I tried to locate a bug of my app using logging, but it seems nothing has
> been logged in the dashboard.
>
> I've set to the lowest log level, and directly put the logging code in
> main(), but still nothing logged:
>
> logging.getLogger().setLevel(logging.DEBUG)
> def main():
> logging.erro('test')

Try:

logging.error('test')


>
> My app id is py-gae, please help me.
>
> --
> keakon

-- 
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-appeng...@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.

[google-appengine] Dealing with namespaces and incoming e-mail

[Krishna]

Hello,

I am building an an app that is multi-tenant and has to support input
by e-mail for a particular use case.

Do I need to maintain a mapping between all mail handles (@appid.appspotmail.com) and their corresponding namespace in
the default namespace ("") or is there a better way to ensure that the
incoming mail finds its way to the correct namespace?

Thanks,

Krishna

-- 
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-appeng...@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.

[google-appengine] Re: logging seems be disabled in my app

[keakon]

I just deployed a version to stop all instances, and ran logging code
in the Interactive Console, still no effect.

I have to go bed now, hope it can be fixed before my getting up.

-- 
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-appeng...@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.

Re: [google-appengine] Re: Prerelease SDK 1.4.0 is out!

[风笑雪]

Don't worry about it, the developer can only download the source code
deployed by himself.

--
keakon


On Sat, Nov 27, 2010 at 1:53 AM, Sandeep Koduri wrote:

> Hello Ikai,
>
>   We are not using as a source code control system, we  have a core app on
> a version, its duty is to aggregate and store data.
> we have a team who are building modules which uses the data in the
> datastore.
>
> The core app contains some confidential info about the sources of the data,
> which we dont want to expose to the rest.
> but we want the other versions updated by the dev can be downloadable.
>
> What i meant to say is once i upload app with the configuration in app
> config as *not downloadable..*
> even if someone tries to download the app using the configuration in app
> config as *downloadable, h*e will not be able to download,
> As the configuration of the app in the particular version is set as *not
> downloadable* previously at the time of upload..
> so the source code is safe for the particular version.
>
> I feel this kind of option for source code download feature will be more
> useful.
>
> On Thu, Nov 25, 2010 at 2:21 AM, Ikai Lan (Google) <
> ikai.l+gro...@google.com > wrote:
>
>> Trust me, we thought out all the scenarios. Here are the scenarios:
>>
>> 1. Just enable it in app.yaml
>> - completely useless from a security perspective, an attacker would just
>> enable it, download code, upload malicious code and steal data/compromise
>> users' data over time
>>
>> 2. Make it opt-in, so you can't download the code unless there's a version
>> of app.yaml that has this enabled uploaded
>> So an attacker can't download previous versions, but the problem here is:
>> who would use this feature? The type of folks that want code download are
>> unlikely to have known about this feature prior to uploading an app version.
>>
>> 3. Just enable it, allow disabling in app.yaml and don't allow versions
>> uploaded before 1.4.0 going live to be downloaded
>> Same problems - users that ask for this feature won't benefit.
>>
>> 4. One way disable button
>> Seems to be the best compromise for all worlds. People that don't needs
>> this feature will just turn it off once and never, ever worry about it
>> again. Developers that need this feature (generally seem like neophyte
>> developers who are still learning about backups and source control) won't
>> know to turn it off, and when they lose their code, they'll be relieved they
>> can download their code.
>>
>> In general we do NOT recommend this feature as a replacement for:
>>
>> 1. Backups
>> 2. Source control
>>
>> A lot of folks come to App Engine because they're learning how to program,
>> and they're not aware of source control or have "always back up your stuff"
>> hammered in yet. See this blog post:
>>
>> http://www.7bks.com/blog/179001
>>
>> I'm going to be pretty adamant about not using this feature as a
>> replacement for source control or backups in the groups, but I'm open to
>> hearing about other reasons developers want this feature and why a permanent
>> opt-out button is a bad idea.
>>
>>
>> --
>> Ikai Lan
>> Developer Programs Engineer, Google App Engine
>> Blogger: http://googleappengine.blogspot.com
>> Reddit: http://www.reddit.com/r/appengine
>> Twitter: http://twitter.com/app_engine
>>
>>
>>
>> On Wed, Nov 24, 2010 at 12:26 PM, Thomas Johansson wrote:
>>
>>> If the guy uploading enables downloads to be malicious, he could
>>> equally just post up the code somewhere.
>>>
>>> That being said, I hadn't thought about the case of accidentally re-
>>> enabling and then having the account compromised. Even still, not
>>> being able to ever turn it back on seems short sighted. Perhaps a way
>>> to enable it similar to how disabling an app works, so it can't be
>>> done maliciously.
>>>
>>> On Nov 24, 6:07 pm, Barry Hunter  wrote:
>>> > Being a one time nuke, means its not possible to for a developer to
>>> > accidentally (or maliciously) re enable downloads :)
>>> >
>>> > One of the main objections to 'download' is it makes it easier for
>>> > someone who shouldnt get their hands on the source code. Yes the fact
>>> > only the uploading developer gets it, makes it more secure, but not
>>> > totally. Being able to turn off downloads, is another serious barrier
>>> > to the 'thief'. Someone who as invested IP in their code, wants to be
>>> > able to do everything possible to protect that.
>>> >
>>> > On 24 November 2010 16:25, Thomas Johansson 
>>> wrote:
>>> >
>>> > > Why was the decision made to make this an app-wide one time only nuke
>>> > > button?
>>> >
>>> > > I think enabling/disabling it in app.yaml per-upload would be much
>>> > > more useful.
>>> >
>>> > > On Nov 23, 8:30 pm, "Ikai Lan (Google)" 
>>> > > 
>>> >
>>> > > wrote:
>>> > >> You'll be able to download code, but anyone that wants to turn it
>>> off will
>>> > >> be able to go to their admin dashboard and push a one-way,
>>> irreversible
>>> > >> button to disallow this feature.
>>> >
>>

[google-appengine] logging seems be disabled in my app

[风笑雪]

I tried to locate a bug of my app using logging, but it seems nothing has
been logged in the dashboard.

I've set to the lowest log level, and directly put the logging code in
main(), but still nothing logged:

logging.getLogger().setLevel(logging.DEBUG)
def main():
logging.erro('test')

My app id is py-gae, please help me.

--
keakon

-- 
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-appeng...@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.

Re: [google-appengine] Re: Prerelease SDK 1.4.0 is out!

[Sandeep Koduri]

Hello Ikai,

  We are not using as a source code control system, we  have a core app on a
version, its duty is to aggregate and store data.
we have a team who are building modules which uses the data in the
datastore.

The core app contains some confidential info about the sources of the data,
which we dont want to expose to the rest.
but we want the other versions updated by the dev can be downloadable.

What i meant to say is once i upload app with the configuration in app
config as *not downloadable..*
even if someone tries to download the app using the configuration in app
config as *downloadable, h*e will not be able to download,
As the configuration of the app in the particular version is set as *not
downloadable* previously at the time of upload..
so the source code is safe for the particular version.

I feel this kind of option for source code download feature will be more
useful.

On Thu, Nov 25, 2010 at 2:21 AM, Ikai Lan (Google)

> wrote:

> Trust me, we thought out all the scenarios. Here are the scenarios:
>
> 1. Just enable it in app.yaml
> - completely useless from a security perspective, an attacker would just
> enable it, download code, upload malicious code and steal data/compromise
> users' data over time
>
> 2. Make it opt-in, so you can't download the code unless there's a version
> of app.yaml that has this enabled uploaded
> So an attacker can't download previous versions, but the problem here is:
> who would use this feature? The type of folks that want code download are
> unlikely to have known about this feature prior to uploading an app version.
>
> 3. Just enable it, allow disabling in app.yaml and don't allow versions
> uploaded before 1.4.0 going live to be downloaded
> Same problems - users that ask for this feature won't benefit.
>
> 4. One way disable button
> Seems to be the best compromise for all worlds. People that don't needs
> this feature will just turn it off once and never, ever worry about it
> again. Developers that need this feature (generally seem like neophyte
> developers who are still learning about backups and source control) won't
> know to turn it off, and when they lose their code, they'll be relieved they
> can download their code.
>
> In general we do NOT recommend this feature as a replacement for:
>
> 1. Backups
> 2. Source control
>
> A lot of folks come to App Engine because they're learning how to program,
> and they're not aware of source control or have "always back up your stuff"
> hammered in yet. See this blog post:
>
> http://www.7bks.com/blog/179001
>
> I'm going to be pretty adamant about not using this feature as a
> replacement for source control or backups in the groups, but I'm open to
> hearing about other reasons developers want this feature and why a permanent
> opt-out button is a bad idea.
>
>
> --
> Ikai Lan
> Developer Programs Engineer, Google App Engine
> Blogger: http://googleappengine.blogspot.com
> Reddit: http://www.reddit.com/r/appengine
> Twitter: http://twitter.com/app_engine
>
>
>
> On Wed, Nov 24, 2010 at 12:26 PM, Thomas Johansson wrote:
>
>> If the guy uploading enables downloads to be malicious, he could
>> equally just post up the code somewhere.
>>
>> That being said, I hadn't thought about the case of accidentally re-
>> enabling and then having the account compromised. Even still, not
>> being able to ever turn it back on seems short sighted. Perhaps a way
>> to enable it similar to how disabling an app works, so it can't be
>> done maliciously.
>>
>> On Nov 24, 6:07 pm, Barry Hunter  wrote:
>> > Being a one time nuke, means its not possible to for a developer to
>> > accidentally (or maliciously) re enable downloads :)
>> >
>> > One of the main objections to 'download' is it makes it easier for
>> > someone who shouldnt get their hands on the source code. Yes the fact
>> > only the uploading developer gets it, makes it more secure, but not
>> > totally. Being able to turn off downloads, is another serious barrier
>> > to the 'thief'. Someone who as invested IP in their code, wants to be
>> > able to do everything possible to protect that.
>> >
>> > On 24 November 2010 16:25, Thomas Johansson  wrote:
>> >
>> > > Why was the decision made to make this an app-wide one time only nuke
>> > > button?
>> >
>> > > I think enabling/disabling it in app.yaml per-upload would be much
>> > > more useful.
>> >
>> > > On Nov 23, 8:30 pm, "Ikai Lan (Google)" 
>> > > 
>> >
>> > > wrote:
>> > >> You'll be able to download code, but anyone that wants to turn it off
>> will
>> > >> be able to go to their admin dashboard and push a one-way,
>> irreversible
>> > >> button to disallow this feature.
>> >
>> > >> Please do not depend on this feature to do source control.
>> >
>> > >> --
>> > >> Ikai Lan
>> > >> Developer Programs Engineer, Google App Engine
>> > >> Blogger:http://googleappengine.blogspot.com
>> > >> Reddit:http://www.reddit.com/r/appengine
>> > >> Twitter:http://twitter.com/app_engine
>> >
>> > >> On Tue, Nov 23, 2010

Re: [google-appengine] Re: App is cut several times a day

[Sahid Orentino Ferdjaoui]

hum... http://i.imgur.com/RAJua.png


--
  .
 ..:



On Fri, Nov 26, 2010 at 11:49 AM, Sahid Orentino Ferdjaoui
 wrote:
> ohh no... i'm wrong,
>
> The model is a small models used to record my users presence.
>
> no parent, no index
>
> class Presence (MarkDeleted, CachingModel):
>    actor      = db.ReferenceProperty (Actor, required=True)
>    gender     = db.IntegerProperty (required=True)
>    extra      = db.StringProperty ()
>    history    = db.BooleanProperty (default=False)
>    ip_address = db.StringProperty (default=None)
>
>
> --
>   .
>  ..:
>
>
>
> On Fri, Nov 26, 2010 at 11:27 AM, Sahid Orentino Ferdjaoui
>  wrote:
>> Hello Stephen,
>>
>> This model has 27 indexes and 10 properties. it don't have parent.
>>
>>
>> --
>>   .
>>  ..:
>>
>>
>>
>> On Thu, Nov 25, 2010 at 5:57 PM, Stephen  wrote:
>>>
>>>
>>> On Nov 25, 3:44 pm, Sahid Orentino Ferdjaoui
>>>  wrote:
 My problem is during the Put with the datastore_v3.
>>>
>>> What does the model look like? Does it have any parent entities?
>>>
>>> --
>>> 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-appeng...@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.
>>>
>>>
>>
>

-- 
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-appeng...@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.

[google-appengine] Re: Deployments timing out again!

[pbadn]

Just did a deployment on Python.  It was very slow and took a long
time.

On Nov 26, 9:37 am, Francois Masurel  wrote:
> Yep, deployments seem to be quite slow today.
>
> Francois
>
> On Nov 25, 11:25 pm, herbie <4whi...@o2.co.uk> wrote:
>
> > I've been trying and failing to deploy for the last 20 mins!

-- 
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-appeng...@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.

[google-appengine] Re: Deployments timing out again!

[Francois Masurel]

Yep, deployments seem to be quite slow today.

Francois

On Nov 25, 11:25 pm, herbie <4whi...@o2.co.uk> wrote:
> I've been trying and failing to deploy for the last 20 mins!

-- 
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-appeng...@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.

Re: [google-appengine] Too many indexes for datastore_v3.Put?

[Wim den Ouden]

Did you read this,
http://code.google.com/intl/nl/appengine/docs/python/datastore/queriesandindexes.html#Big_Entities_and_Exploding_Indexes
gr
wim

On Fri, Nov 26, 2010 at 3:01 PM, sahid  wrote:
> Hello All
>
> I'm always investigate why my app has a lot of DeadLineException...
> And i have noticed a interesting stuff
>
> http://i.imgur.com/tngR6.png (an example)
>
> All of my put into a particular model take a big long of time.
>
> This model is my user model, it's very big and have many indexes
> (about 27) and about 35 properties.
> You thinks the problem comes from here?
>
> If it's the case... all of my put into this models is very expensive.
>
> Thank a lots
>
> --
> 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-appeng...@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.
>
>



-- 
gr
wdo

Demo free E-business: https://e-comm.appspot.com
Gae developer tips http://code.google.com/p/relat/wiki/gaetips
Wim den Ouden Google app engine based (web) apps

-- 
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-appeng...@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.

Re: [google-appengine] Re: SQL Injection?

[Barry Hunter]

Even read-only SQL injection has its 'uses'. Ie. it can be used to
exploit 'SELECT's.

For example, in some systems, depending on how login is implemented
its possible to use SQL injection to login as an admin user - to pick
one possible use.

On 26 November 2010 13:38, Tim Hoffman  wrote:
> GQL is read only , so you can't inject anything if your using GQL, or
> for that matter Query objects.
>
> T
>
> On Nov 26, 8:37 pm, pdknsk  wrote:
>> And by clarify I mean verify.
>
> --
> 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-appeng...@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.
>
>

-- 
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-appeng...@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.

Re: [google-appengine] Re: pubschools

[Rajkumar Radhakrishnan]

My app internally uses the same geomodel package.

The iFreeTools platform supports importing bigger CSV files (technically
upto 1 MB of CSV file size).. but for the free version though, I currently
cannot afford to support bigger files, due the CPU costs involved.

If it were for some business deployment, I could have recommended you to go
in for a single-tenant deployment ,
which starts at $99/year. You could pass on the costs to your client and
charge how-much-ever you want above that as your
customization/implementation charges (defining entities and attributes).

Regards,
R.Rajkumar


On Fri, Nov 26, 2010 at 7:11 PM, kualoa1  wrote:

> Thank you.  I will try this and provide feedback.  Is there a limit on
> the number of records in thge CSV file?  My immediate application has
> just over 100,000.
>
> I am interested in the PubSchools for other reasons that may be of
> interest.  1) the instrinsics of the school data 2) use of geomodel to
> handle a relatively huge set of points, 3) the structure of the app
> being able to accomodate queries and list vs map for this scale of
> data.
>
> Thank you again & I will get back to you.
>
> On Thu, Nov 25, 2010 at 8:06 PM, Rajkumar Radhakrishnan
>  wrote:
> > kualoa1 :
> > If you want harness the power of Google App Engine, with lesser learning
> > curve, you may want to try out the online application builder I am
> working
> > on..
> > Here is a related blog post to get you started with such an app, without
> any
> > coding..
> > Building a Store Locator type Google Maps app over GAE, using iFreeTools
> >
> > Regards,
> > R.Rajkumar
> > On Fri, Nov 26, 2010 at 1:23 AM, Malcolm MacKinnon 
> > wrote:
> >>
> >> I remember I had some difficulty getting this to work, and yes I did
> have
> >> to modify the downloadable code. In template.py try substituting your
> app's
> >> url + key in JSAPI_KEYS. As I said before, you may want to substitute
> your
> >> key in index.html like so:
> >>  >> src="http://www.google.com/jsapi?key=your_key";>
> >> then, work backwards to get your key in templatelib.py to work for you.
> >> I'm not certain how much a security issue this is. I think this should
> work
> >> for test purposes at least.
> >> With respect to the database call, it is made in front.js using ajax.
> See
> >> function doGeocodeAndSearch() & function doSearch(options). I then
> >> substituted the my app's url in function doSearch(options) as shown
> below:
> >> g_currentSearchXHR = $.ajax({
> >> url: 'http://your_app.appspot.com/s/search', //see your app.yaml
> file
> >> for the call to service.py
> >> type: 'get',
> >> data: searchParameters,
> >> dataType: 'json',
> >> error: function(xhr, textStatus) {
> >>   // TODO: parse JSON instead of eval'ing
> >>   var responseObj;
> >>   eval('responseObj=' + xhr.responseText);
> >>   $('#search-error, #list-view-status').text(
> >>   'Internal error: ' + responseObj.error.message);
> >>   $('#search-error').css('visibility', 'visible');
> >>   $('#loading').css('visibility', 'hidden');
> >> },
> >> success: function(obj) {
> >>   g_currentSearchXHR = null;
> >>   $('#loading').css({ visibility: 'hidden' });
> >>
> >>   if (!options.clearResultsImmediately)
> >> clearSearchResults();
> >>   if (obj.status && obj.status == 'success') {
> >>
> >> for (var i = 0; i < obj.results.length; i++) {
> >>   var result = obj.results[i];
> >>
> >>   result.icon =
> >> 'http://your_app.appspot.com/static/images/markers/simple.png';
> >>   if (options.type == 'proximity' && i <= 10) {
> >> result.icon =
> >> 'http://your_app.appspot.com/static/images/markers/' +
> >> String.fromCharCode(65 + i) + '.png';
> >>   }
> >>
> >> 
> >>
> >> What that ajax call does is call service.py as defined in your app.yaml
> >> file. Look at service.py to see how the actual call to the database is
> >> defined.
> >> This worked for me. I hope this helps. Good luck!
> >>
> >> On Thu, Nov 25, 2010 at 4:03 AM, kualoa1  wrote:
> >>>
> >>> Thank you.  I have entered the correct ket in the index.html ... I did
> >>> not modify templatelib.py.  I see it has three keys specified.  not
> >>> clear what is going on there.  still in the dark!  did you make any
> >>> mods to the "downloadable code" or did it start directly for you?
> >>>
> >>> on the database ... where is a call referenced to it?  do you have an
> >>> example, however small, that you can share with me so I can try it?  I
> >>> would like to eliminate that from getting the app going and then come
> >>> back to develop the full database.  are you using a full version?
> >>> (100K records?)
> >>>
> >>> Thank you.
> >>>
> >>> On Wed, Nov 24, 2010 at 8:28 PM, Malcolm MacKinnon <
> mmack3...@gmail.com>
> >>> wrote:
> >>> > No, I'm not with G

[google-appengine] Too many indexes for datastore_v3.Put?

[sahid]

Hello All

I'm always investigate why my app has a lot of DeadLineException...
And i have noticed a interesting stuff

http://i.imgur.com/tngR6.png (an example)

All of my put into a particular model take a big long of time.

This model is my user model, it's very big and have many indexes
(about 27) and about 35 properties.
You thinks the problem comes from here?

If it's the case... all of my put into this models is very expensive.

Thank a lots

-- 
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-appeng...@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.

Re: [google-appengine] Re: pubschools

[kualoa1]

Thank you.  I will try these suggestions.

On Thu, Nov 25, 2010 at 2:53 PM, Malcolm MacKinnon  wrote:
> I remember I had some difficulty getting this to work, and yes I did have to
> modify the downloadable code. In template.py try substituting your app's url
> + key in JSAPI_KEYS. As I said before, you may want to substitute your key
> in index.html like so:
>  src="http://www.google.com/jsapi?key=your_key";>
> then, work backwards to get your key in templatelib.py to work for you. I'm
> not certain how much a security issue this is. I think this should work for
> test purposes at least.
> With respect to the database call, it is made in front.js using ajax. See
> function doGeocodeAndSearch() & function doSearch(options). I then
> substituted the my app's url in function doSearch(options) as shown below:
> g_currentSearchXHR = $.ajax({
>     url: 'http://your_app.appspot.com/s/search', //see your app.yaml file
> for the call to service.py
>     type: 'get',
>     data: searchParameters,
>     dataType: 'json',
>     error: function(xhr, textStatus) {
>       // TODO: parse JSON instead of eval'ing
>       var responseObj;
>       eval('responseObj=' + xhr.responseText);
>       $('#search-error, #list-view-status').text(
>           'Internal error: ' + responseObj.error.message);
>       $('#search-error').css('visibility', 'visible');
>       $('#loading').css('visibility', 'hidden');
>     },
>     success: function(obj) {
>       g_currentSearchXHR = null;
>       $('#loading').css({ visibility: 'hidden' });
>
>       if (!options.clearResultsImmediately)
>         clearSearchResults();
>       if (obj.status && obj.status == 'success') {
>
>         for (var i = 0; i < obj.results.length; i++) {
>           var result = obj.results[i];
>
>           result.icon =
> 'http://your_app.appspot.com/static/images/markers/simple.png';
>           if (options.type == 'proximity' && i <= 10) {
>             result.icon =
> 'http://your_app.appspot.com/static/images/markers/' +
>                 String.fromCharCode(65 + i) + '.png';
>           }
>
> 
>
> What that ajax call does is call service.py as defined in your app.yaml
> file. Look at service.py to see how the actual call to the database is
> defined.
> This worked for me. I hope this helps. Good luck!
>
> On Thu, Nov 25, 2010 at 4:03 AM, kualoa1  wrote:
>>
>> Thank you.  I have entered the correct ket in the index.html ... I did
>> not modify templatelib.py.  I see it has three keys specified.  not
>> clear what is going on there.  still in the dark!  did you make any
>> mods to the "downloadable code" or did it start directly for you?
>>
>> on the database ... where is a call referenced to it?  do you have an
>> example, however small, that you can share with me so I can try it?  I
>> would like to eliminate that from getting the app going and then come
>> back to develop the full database.  are you using a full version?
>> (100K records?)
>>
>> Thank you.
>>
>> On Wed, Nov 24, 2010 at 8:28 PM, Malcolm MacKinnon 
>> wrote:
>> > No, I'm not with Google. Yes, I've deployed it to appengine
>> > successfully.
>> > Your problem may have to do with your JSAPI_KEYS you define in
>> > templatelib.py. Is schools.htm coded like index.html in the example
>> > code? Make sure you've put in your proper key. Failing that, assuming
>> > security issue isn't a concern for you, you could put your key directly
>> > in
>> > your index.html file template script. Note that Google does not
>> > recommend
>> > putting your jsapi key directly in you template, so it's better to use
>> > templatelib.py.
>> > In index.html, you could try this:
>> > > > src="http://www.google.com/jsapi?key=your_key";>
>> > Again, it's best for security reasons to use templatelib.py for your
>> > key.
>> > Good Luck!
>> >
>> > On Wed, Nov 24, 2010 at 11:02 AM, kualoa1  wrote:
>> >>
>> >> Thank you.
>> >>
>> >> 1) Since there was no mention of recreating the geocoded database, I
>> >> assumed that it was somehow linked; it clearly already exists.  Can
>> >> Google staff confirm ... the database has to be re-created?  (Malcolm,
>> >> maybe you are with Google; not clear. :) )   My brief look suggests
>> >> this might be a considerable task?  what are the possibilities of
>> >> moving the geocoded database to the source files download section?
>> >>
>> >> -- failing that, does anyone have a small ready to use sample?
>> >>
>> >> 2) But maybe the database availability is not the entire issue ... in
>> >> looking at the downloadable files, I note that many have relative file
>> >> coding to '/p/...' and '/hosting ...' folders.  Is there code that
>> >> directs this to the correct URL, already embedded in the downloadable
>> >> PubSchools files? ... or do all such references need to be re-built?
>> >>
>> >> Malcolm, have you gone thru the steps to migrate 

Re: [google-appengine] Re: pubschools

[kualoa1]

Thank you.  I will try this and provide feedback.  Is there a limit on
the number of records in thge CSV file?  My immediate application has
just over 100,000.

I am interested in the PubSchools for other reasons that may be of
interest.  1) the instrinsics of the school data 2) use of geomodel to
handle a relatively huge set of points, 3) the structure of the app
being able to accomodate queries and list vs map for this scale of
data.

Thank you again & I will get back to you.

On Thu, Nov 25, 2010 at 8:06 PM, Rajkumar Radhakrishnan
 wrote:
> kualoa1 :
> If you want harness the power of Google App Engine, with lesser learning
> curve, you may want to try out the online application builder I am working
> on..
> Here is a related blog post to get you started with such an app, without any
> coding..
> Building a Store Locator type Google Maps app over GAE, using iFreeTools
>
> Regards,
> R.Rajkumar
> On Fri, Nov 26, 2010 at 1:23 AM, Malcolm MacKinnon 
> wrote:
>>
>> I remember I had some difficulty getting this to work, and yes I did have
>> to modify the downloadable code. In template.py try substituting your app's
>> url + key in JSAPI_KEYS. As I said before, you may want to substitute your
>> key in index.html like so:
>> > src="http://www.google.com/jsapi?key=your_key";>
>> then, work backwards to get your key in templatelib.py to work for you.
>> I'm not certain how much a security issue this is. I think this should work
>> for test purposes at least.
>> With respect to the database call, it is made in front.js using ajax. See
>> function doGeocodeAndSearch() & function doSearch(options). I then
>> substituted the my app's url in function doSearch(options) as shown below:
>> g_currentSearchXHR = $.ajax({
>>     url: 'http://your_app.appspot.com/s/search', //see your app.yaml file
>> for the call to service.py
>>     type: 'get',
>>     data: searchParameters,
>>     dataType: 'json',
>>     error: function(xhr, textStatus) {
>>       // TODO: parse JSON instead of eval'ing
>>       var responseObj;
>>       eval('responseObj=' + xhr.responseText);
>>       $('#search-error, #list-view-status').text(
>>           'Internal error: ' + responseObj.error.message);
>>       $('#search-error').css('visibility', 'visible');
>>       $('#loading').css('visibility', 'hidden');
>>     },
>>     success: function(obj) {
>>       g_currentSearchXHR = null;
>>       $('#loading').css({ visibility: 'hidden' });
>>
>>       if (!options.clearResultsImmediately)
>>         clearSearchResults();
>>       if (obj.status && obj.status == 'success') {
>>
>>         for (var i = 0; i < obj.results.length; i++) {
>>           var result = obj.results[i];
>>
>>           result.icon =
>> 'http://your_app.appspot.com/static/images/markers/simple.png';
>>           if (options.type == 'proximity' && i <= 10) {
>>             result.icon =
>> 'http://your_app.appspot.com/static/images/markers/' +
>>                 String.fromCharCode(65 + i) + '.png';
>>           }
>>
>> 
>>
>> What that ajax call does is call service.py as defined in your app.yaml
>> file. Look at service.py to see how the actual call to the database is
>> defined.
>> This worked for me. I hope this helps. Good luck!
>>
>> On Thu, Nov 25, 2010 at 4:03 AM, kualoa1  wrote:
>>>
>>> Thank you.  I have entered the correct ket in the index.html ... I did
>>> not modify templatelib.py.  I see it has three keys specified.  not
>>> clear what is going on there.  still in the dark!  did you make any
>>> mods to the "downloadable code" or did it start directly for you?
>>>
>>> on the database ... where is a call referenced to it?  do you have an
>>> example, however small, that you can share with me so I can try it?  I
>>> would like to eliminate that from getting the app going and then come
>>> back to develop the full database.  are you using a full version?
>>> (100K records?)
>>>
>>> Thank you.
>>>
>>> On Wed, Nov 24, 2010 at 8:28 PM, Malcolm MacKinnon 
>>> wrote:
>>> > No, I'm not with Google. Yes, I've deployed it to appengine
>>> > successfully.
>>> > Your problem may have to do with your JSAPI_KEYS you define in
>>> > templatelib.py. Is schools.htm coded like index.html in the example
>>> > code? Make sure you've put in your proper key. Failing that, assuming
>>> > security issue isn't a concern for you, you could put your key directly
>>> > in
>>> > your index.html file template script. Note that Google does not
>>> > recommend
>>> > putting your jsapi key directly in you template, so it's better to use
>>> > templatelib.py.
>>> > In index.html, you could try this:
>>> > >> > src="http://www.google.com/jsapi?key=your_key";>
>>> > Again, it's best for security reasons to use templatelib.py for your
>>> > key.
>>> > Good Luck!
>>> >
>>> > On Wed, Nov 24, 2010 at 11:02 AM, kualoa1  wrote:
>>> >>
>>> >> Thank you.
>>> >

[google-appengine] Re: SQL Injection?

[Tim Hoffman]

GQL is read only , so you can't inject anything if your using GQL, or
for that matter Query objects.

T

On Nov 26, 8:37 pm, pdknsk  wrote:
> And by clarify I mean verify.

-- 
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-appeng...@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.

Re: [google-appengine] Log is missing in console ? when I changed from App engine 1.3.5 to 1.3.8

[suersh babu]

Hi,

The log display only warning and severe but not info,

My logging.properties file contains following

# Set the default logging level for all loggers to WARNING
*.level = INFO*

# Set the default logging level for ORM, specifically, to WARNING
DataNucleus.JDO.level=WARNING
DataNucleus.Persistence.level=WARNING
DataNucleus.Cache.level=WARNING
DataNucleus.MetaData.level=WARNING
DataNucleus.General.level=WARNING
DataNucleus.Utility.level=WARNING
DataNucleus.Transaction.level=WARNING
DataNucleus.Datastore.level=WARNING
DataNucleus.ClassLoading.level=WARNING
DataNucleus.Plugin.level=WARNING
DataNucleus.ValueGeneration.level=WARNING
DataNucleus.Enhancer.level=WARNING
DataNucleus.SchemaTool.level=WARNING

which is inside the WEB-INF folder.

And my appengine.web.xml file as this


http://appengine.google.com/ns/1.0";>
vs-stage
5


*

*

true
true
false

 
 
 
 
 
 



I have changed appengine 1.3.5 to appengine 1.3.8,  Also I  try to revert to
older version (i.e appengine 1.3.5 ) after new version but that is not
happening because it shows error in devmode.

Any idea why is this log info is missing ?

*Regards

Suresh Babu G*

-- 
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-appeng...@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.

Re: [google-appengine] SQL Injection?

[Barry Hunter]

Using the vaious documented methods of using "GqlQuery"

http://code.google.com/appengine/docs/python/datastore/creatinggettinganddeletingdata.html#Getting_Entities_Using_a_Query

ie using Parameters to build the query. Rather than string concatenation.

... should protect you.

The SQL like interface to the Datastore is invulnerable to most forms
anyway. Colon (:) Parameters will protect from the rest.



On 26 November 2010 12:34, pdknsk  wrote:
> I've only started using SQL language, or databases in general, with
> Google App Engine, and have been wondering if I need to be cautious
> about possible SQL Injection. I suppose this is already taken care of
> by design, but just wanted to clarify. Thanks.
>
> --
> 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-appeng...@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.
>
>

-- 
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-appeng...@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.

[google-appengine] Re: SQL Injection?

[pdknsk]

And by clarify I mean verify.

-- 
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-appeng...@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.

[google-appengine] SQL Injection?

[pdknsk]

I've only started using SQL language, or databases in general, with
Google App Engine, and have been wondering if I need to be cautious
about possible SQL Injection. I suppose this is already taken care of
by design, but just wanted to clarify. Thanks.

-- 
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-appeng...@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.

[google-appengine] Regarding 500 errors and high latencies

[Ice13ill]

I was wondering if anyone knows if this the problems related to the
frequency of the 500 errors and very high latencies queries are
somehow related to localization (geographical position) of the users,
servers etc for our applications.

-- 
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-appeng...@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.

Re: [google-appengine] Re: App is cut several times a day

[Sahid Orentino Ferdjaoui]

ohh no... i'm wrong,

The model is a small models used to record my users presence.

no parent, no index

class Presence (MarkDeleted, CachingModel):
actor  = db.ReferenceProperty (Actor, required=True)
gender = db.IntegerProperty (required=True)
extra  = db.StringProperty ()
history= db.BooleanProperty (default=False)
ip_address = db.StringProperty (default=None)


--
  .
 ..:



On Fri, Nov 26, 2010 at 11:27 AM, Sahid Orentino Ferdjaoui
 wrote:
> Hello Stephen,
>
> This model has 27 indexes and 10 properties. it don't have parent.
>
>
> --
>   .
>  ..:
>
>
>
> On Thu, Nov 25, 2010 at 5:57 PM, Stephen  wrote:
>>
>>
>> On Nov 25, 3:44 pm, Sahid Orentino Ferdjaoui
>>  wrote:
>>> My problem is during the Put with the datastore_v3.
>>
>> What does the model look like? Does it have any parent entities?
>>
>> --
>> 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-appeng...@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.
>>
>>
>

-- 
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-appeng...@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.

Re: [google-appengine] Re: App is cut several times a day

[Sahid Orentino Ferdjaoui]

Hello Stephen,

This model has 27 indexes and 10 properties. it don't have parent.


--
  .
 ..:



On Thu, Nov 25, 2010 at 5:57 PM, Stephen  wrote:
>
>
> On Nov 25, 3:44 pm, Sahid Orentino Ferdjaoui
>  wrote:
>> My problem is during the Put with the datastore_v3.
>
> What does the model look like? Does it have any parent entities?
>
> --
> 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-appeng...@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.
>
>

-- 
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-appeng...@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.

[google-appengine] Re: Policy for instance startup

[Tomas Alaeus]

This problem doesn't seem to happen on the staging server (doesn't
have billing enabled), but I maybe haven't stressed it enough. Another
application I have for testing purposes seem to be affected by it too,
and it doesn't have billing enabled either. That application seems to
want at least 4 instances before serving hot instances to incoming
requests.

This is actually quite bad for everyone. If the load is low the user
experience will be worse, we have to pay more and Googles servers will
have to boot up/down instances for no reason. Can any Googler confirm
this behavior?

On 24 Nov, 22:18, nickmilon  wrote:
> While waiting from a Googler to give us some light on this may be you
> do your stress tests in the staging server ? (just an other version
> will do as staging server)
> Also I remember people from App Engine team stating here that the best
> performance comes when load comes in a natural matter.
>
> Still IMHO that there must be some more transparency into those
> parameters within which our appls have to operate. - It helps both us
> and the platform.
>
> Regards
> Nick
>
> On Nov 24, 9:21 am, Tomas Alaeus  wrote:
>
>
>
> > Probably. With some more thinking I got to this conclusion:
>
> > At first, an application can utilize up to 30 instances. After having
> > used all those instances for a few minutes, and it still isn't enough,
> > GAE will increase the maximum number of available instances to 40, and
> > then to 50 etc. Every time it increases the number of instances it
> > will probably also adjust how and when it boots up new instances.
>
> > For my production app it probably tries to keep at least 10 instances
> > running since it thinks a huge amount of users can use the site at any
> > given time. The staging haven't had any rush of users, and therefore
> > thinks it is safe with just 1 instance running.
>
> > I would still like to hear something from a Googler. If this is how it
> > works then it means that stress testing the application (with a lot
> > more pressure than it will normally get) may lead to worse (!)
> > performance permanently.
>
> > On 24 Nov, 00:01, nickmilon  wrote:
>
> > > Not been a Googler can't help much with this.
> > > Having said that, I suspect there is a kind of build in algorithm that
> > > does some kind of application profiling taking into acount QPS,
> > > response times, and other parameters which adjusts instance life time,
> > > number of instances to start etc..
> > > This could possibly explain the difference in behaviour between your
> > > staging and production appls.
>
> > > happy coding;-)
>
> > > On Nov 23, 11:58 am, Tomas Alaeus  wrote:
>
> > > > I'm curious when exactly instances are started. I have two
> > > > applications running on GAE, one of them have billing enabled. The one
> > > > with billing enabled have been stress tested and have at most started
> > > > 100 simultaneous instances. The other is just for testing and staging
> > > > purposes and have never handeled much traffic.
>
> > > > What I experience is that the staging server never starts more
> > > > instances than needed. If a single person views pages it will never
> > > > load more than a single instance. The other one however seems to start
> > > > about 5 instances before anyone can get hot responses, and it will
> > > > continue to start up to about 10 before realizing that ~1 QPS isn't
> > > > that much traffic (the requests finish in about 100ms each).
>
> > > > So, why does GAE boot up lots of instances even though 1 instance can
> > > > serve the incoming traffic without a problem (the requests doesn't
> > > > even overlap, so no waiting is needed)?
>
> > > > I realize that this isn't a very big issue, since when it gets lots of
> > > > traffic it will indeed need all the instances. I'm just curious why it
> > > > happens.

-- 
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-appeng...@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.