Thanks Pascal / Ikai for reaching out! Unfortunately, I do not have any access to this Postgres DB, except a logon and the ability to perform select queries (i.e. data retrieval only, no create/update/delete). Basically, I would like to get the data out of this DB by executing [java.sql.]Statement's and using the returned ResultSets in the GAE environment to extract data and then further use this in a GWTP framework (which I really like btw). But then, it all comes down to a working connection between GAE and the DB...
Regards, Wouter On 2 aug, 20:58, "Ikai Lan (Google)" <[email protected]> wrote: > Yeah, you'll need a REST proxy. I wonder if someone has built a version of > DBSlayer for Postgres? > > http://code.nytimes.com/projects/dbslayer > > DBSlayer's biggest fault: no authentication. > > -- > Ikai Lan > Developer Programs Engineer, Google App Engine > plus.ikailan.com | twitter.com/ikai > > On Tue, Aug 2, 2011 at 7:56 AM, Pascal Voitot Dev < > > > > > > > > [email protected]> wrote: > > Not exactly the answer you expect certainly but wouldn't it better to > > implement a Web/REST service somewhere in the same network as the Postgres > > DB (if you can) which would just extract from Postgres and serve the data > > you need from your GAE app? > > Like that, you don't expose directly Postgres DB to your remote GAE app > > which is something more secure IMHO. > > > Pascal > > > On Tue, Aug 2, 2011 at 3:49 PM, wouterdeg <[email protected]> wrote: > > >> Hi All, > > >> For an app I need to obtain data from an external PostgreSQL database, > >> do some calculations on it and then show the results to the clients in > >> an MVP set-up. > > >> However, from some posts I gather that GAE cannot connect with a > >> PostgreSQL DB over the internet out of its servlet context. Others > >> suggest setting up an 'http proxy' for this. > > >> I'm quite a newbie on this, however, I would love to use GAE / GWT for > >> the most part (particularly GTWP). Anyone that has a suggestion how I > >> can get to the data on the Postrgres DB out of my GAE servlet > >> context?? > > >> Thanks a lot! > > >> -- > >> You received this message because you are subscribed to the Google Groups > >> "Google App Engine" group. > >> To post to this group, send email to [email protected]. > >> To unsubscribe from this group, send email to > >> [email protected]. > >> 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 [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
