[google-appengine] Oracle Database in an App Engine Application

[Sonal Gupta]

Hi,

I have my data in a oracle database, i need to write cloud endpoints which 
get the  data from the oracle database and  return the result.

Please let me know how to do this.

Thanks

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/d5554065-45a1-4aed-8df6-98a5621f4a02%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-appengine] Oracle Database in an App Engine Application

[Rajesh Gupta]

You can use the Managed VM's.  Here you could install oracle.  Then you can
use the cloud end points api.  In the api, connect to the oracle database,
and return the data.
https://github.com/GoogleCloudPlatform/appengine-java-vm-guestbook-extras

Rajesh
www.AccountingGuru.net
www.VeersoftSolutions.com

On Fri, May 8, 2015 at 3:11 PM, Sonal Gupta 
wrote:

> Hi,
>
> I have my data in a oracle database, i need to write cloud endpoints which
> get the  data from the oracle database and  return the result.
>
> Please let me know how to do this.
>
> Thanks
>
>  --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to google-appengine+unsubscr...@googlegroups.com.
> To post to this group, send email to google-appengine@googlegroups.com.
> Visit this group at http://groups.google.com/group/google-appengine.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/google-appengine/d5554065-45a1-4aed-8df6-98a5621f4a02%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Rajesh
*www.VeersoftSolutions.com *
*www.AccountingGuru.net *
*Accounting/Inventory/Orders on Google Cloud Platform and Mobile*

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/CA%2BS7ijZJ_s2Rx2an-PwNT2e7%3D9mQVxw5R%3D9PcYKRp0iGXf98zA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Frontend is too expensive! urgent

[Patrice]

Instance type in fact does matter, as they are theoretically more 
expensive. 

It's explained in our Billing FAQ 
 actually. No 
matter your instance type, the actual bill is made on "F1 instance hours". 
So if you used F4_G1, which costs 30 cents an hour, you will in fact be 
billed 6 times your instance hours (since the "unit" for instance hours is 
in "F1 instance hours", which are worth only 5 cents, needing the 6X 
multiplier).

I don't know if I'm clear, feel free to ask for clarification :)

On Wednesday, May 6, 2015 at 6:09:22 PM UTC-4, רון טופול wrote:
>
> Thanks Patrice,
>
> my app is work on F4_G1 (now changed it to F1)
>
> what do you mean with : "type of instance are you spinning up can change 
> the way instance hours are calculated."  
>
> isn't it like comparing apples to oranges - "instant type" and "woking 
> hours" - and if instant type does matter is it documented somewhere?
>
> On Wednesday, May 6, 2015 at 10:15:10 PM UTC+3, Patrice wrote:
>>
>> Hi,
>>
>> You can read up here on that here : 
>> https://cloud.google.com/appengine/docs/quotas#Instances. 
>>
>> I don't have access to your application, but seeing how this goes up and 
>> down very frequently, you might be hit by the fact that everytime an 
>> instance goes up, you are charged for at least 15 minutes. So all those 
>> spikes in the graph going up and down might be causing a bit more costs to 
>> you.
>>
>> Also, what type of instance are you spinning up? F1, F2, etc? that can 
>> change the way instance hours are calculated.
>>
>> Thank you
>>
>> On Wednesday, May 6, 2015 at 5:02:46 AM UTC-4, רון טופול wrote:
>>>
>>> Hi,
>>>
>>> I dont understand frontend costs.
>>> currently (06/05) my estimated cost for this month are 24$  which are 
>>> calculated for 470.23 frontend hours.
>>> as its seemd from instances graph that the avr.instance/sec are liitle 
>>> more than 1.
>>> however calculating 470 hours divided by the 5 day from the start of 
>>> this month gives  240/24/5 = 3.9 instances/sec
>>> this cause very high cost for the frontend.
>>> please help me to understand this cost calculation.
>>>
>>>
>>> 
>>>
>>>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/ad341951-9426-4a2a-a7dc-4152b49a7a7f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Connecting from app engine instance to compute engine instance directly

[Ian Childress]

Thank you Hussein. We are going to move our app from appengine to a managed 
VM and place it in the same network (default) as our compute engines. Until 
appengine and compute engine instances can communicate on the same network 
we'll be forced to use this work around. Please let me know how your method 
works!

On Thursday, May 7, 2015 at 5:33:09 PM UTC-4, Hussein Vastani wrote:
>
> Hi,
> At my current gig we've been grappling with the same problem, and there 
> seems to be a solution in the 1.9.19 SDK release (finally!). 
>
> So my context is: my java frontend instances need to hit my elasticsearch 
> cluster hosted on GCE. The only way to reach the cluster was via a reverse 
> proxy exposed through a GCE public IP address. I was using basic auth to 
> authenticate my App Engine frontend instances. As you would expect the 
> latency has been hurting. Search queries that should take 10ms, instead 
> come back in 150ms (10x slow). After additional processing in my frontend 
> request, that adds up pretty quickly to noticeable latency user-side. 
>
> I posted about the problem some time ago in this group here 
>  
> and 
> the issue tracker here 
> . I got 
> an acknowledgement from Google and the fix appeared in the 1.9.19 release, 
> a bit quietly (the issue is still open).
>
> So the solution for me is to run a managed VM on the same network as my 
> elasticsearch cluster, and that way I should be able to access my cluster 
> "directly" using internal network addresses, without going out of the 
> Google network. The 1.9.19 SDK allows you to specify a network in the 
> configuration for your managed vm, that defaults to the default GCE network 
> of your project. Thus I either directly route my search requests to my 
> managed VM or have my front end instances talk to my managed VM over http. 
>
> (For my particular case, I expect additional latency savings because I can 
> run a full elasticsearch client on the managed VM that knows the cluster 
> state, instead of using the naked elasticsearch REST API, as I do now, from 
> my front end instances. That saves me an additional network hop that is 
> needed to figure out which nodes in my cluster to hit.)
>
> I guess, the same should work for you no?
>
> I'll post next week about the results of migrating to a managed VM setup.
>
> Good luck!
> H
>
>
> On Thursday, May 7, 2015 at 1:52:39 PM UTC-4, Ian Childress wrote:
>>
>> We (our Go dev team) want to connect our app engine apps to our compute 
>> engine apps directly using internal IP address. From my understanding 
>> through documentation and exhaustive searching, the solution is to use a 
>> public IP address. This solution requires whitelisting an entire ip block 
>> (Google's ip block for app engine). This both increases security risk as 
>> well as charges additional bandwidth. The other solution is to use a 
>> messaging service PubSub. This is fine for submitting tasks to be performed 
>> by the back end app, but it prevents the app engine from receiving the 
>> response from the compute engine. 
>>
>> Have I missed the solution somewhere that allows for internal 
>> communication between app engine and compute engine? Using a job queue or 
>> public IP is not a replacement for an internal socket connection.
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/3e56aad4-2ab9-438e-94e8-1761cde089a1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Appengine Logs and BigQuery

[Aswath Satrasala]

I want to analyze the logs over a period of time. How can I run queries, if
the logs are sent to a new bigquery table every day.



On Wed, May 6, 2015 at 4:35 PM, Aswath Satrasala  wrote:

> Hi,
> I am sending the Appengine Log to BigQuery using the LogViewer screen.
> In the BigQuery browser, I see that a table is created for every 1 day of
> log.
>
> Question:
> How can I send the logs to the same table instead of to different table
> every day.
>
> -Aswath
> www.AccountingGuru.net 
> www.VeersoftSolutions.com 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/CAKFF5G6DnF40ORj7ca4jWt%3DRtFVFnBCnf_-sE634xZ8v6BYjrQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-appengine] Re: Appengine Logs and BigQuery

[Nickolas Daskalou]

You can use table unions, as explained on this page under the FROM heading:

https://cloud.google.com/bigquery/query-reference#from

To quote that page:

===
Note: Unlike many other SQL-based systems, BigQuery uses the comma syntax
to indicate table unions, not joins. This means you can run a query over
several tables with compatible schemas as follows:

// Find suspicious activity over several days
SELECT FORMAT_UTC_USEC(event.timestamp_in_usec) AS time, request_url
  FROM [applogs.events_20120501], [applogs.events_20120502],
[applogs.events_20120503]
  WHERE event.username = 'root' AND NOT event.source_ip.is_internal;

Queries that perform a union over large number of tables can expect to run
more slowly than the same query over a single table with the same amount of
data. The difference in performance can be up to 50 ms per additional
table. The maximum number of tables you can perform a union on is 1,000.
===

Hope this helps.

Nick
 On 09/05/2015 12:05 PM, "Aswath Satrasala" 
wrote:

> I want to analyze the logs over a period of time. How can I run queries,
> if the logs are sent to a new bigquery table every day.
>
>
>
> On Wed, May 6, 2015 at 4:35 PM, Aswath Satrasala <
> aswath.satras...@gmail.com> wrote:
>
>> Hi,
>> I am sending the Appengine Log to BigQuery using the LogViewer screen.
>> In the BigQuery browser, I see that a table is created for every 1 day of
>> log.
>>
>> Question:
>> How can I send the logs to the same table instead of to different table
>> every day.
>>
>> -Aswath
>> www.AccountingGuru.net 
>> www.VeersoftSolutions.com 
>>
>
>  --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to google-appengine+unsubscr...@googlegroups.com.
> To post to this group, send email to google-appengine@googlegroups.com.
> Visit this group at http://groups.google.com/group/google-appengine.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/google-appengine/CAKFF5G6DnF40ORj7ca4jWt%3DRtFVFnBCnf_-sE634xZ8v6BYjrQ%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/CAOj3zuA-xKLyYeUYrXM5BStC0-MeRg%3DHg86djBZ0VJTDRA917Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.