From: | Álvaro Hernández Tortosa <aht(at)nosys(dot)es> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Tips/advice for implementing integrated RESTful HTTP API |
Date: | 2014-09-02 23:19:57 |
Message-ID: | 5406509D.6090902@nosys.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 02/09/14 04:47, Dobes Vandermeer wrote:
>
> Same idea as PgBouncer or PgPool. The advantage over hacking
> PgBouncer/PgPool for the job is that Tomcat can already do a lot
> of what
> you want using built-in, pre-existing functionality. Connection pool
> management, low level REST-style HTTP processing, JSON handling
> etc are
> all done for you.
>
>
> Yeah, those are nice conveniences but I still think installing Java
> and getting something to run on startup is a bit more of a hurdle.
> Better maek life easier up front by having a simple standalone proxy
> you can compile and run with just whatever is already available on a
> typical AWS ubuntu environment.
If instead of Tomcat you use Jetty, you can embed the whole
app+Jetty+dependencies in a single executable JAR, which easies
deployment a lot. Installing a JVM in a Ubuntu environment is just one
apt-get and even easier if you use CloudFormation for automation. I
don't think is a bad choice at all... you get most of the functionality
you want already there, as Craig said, and it's lightweight.
Hope it helps,
Álvaro
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2014-09-02 23:51:23 | Re: B-Tree support function number 3 (strxfrm() optimization) |
Previous Message | Jan Wieck | 2014-09-02 23:08:08 | Re: PL/pgSQL 2 |