Thread: Example web access to Postgres DB

Mohamed Ali JBELI wrote:
> Hi members
>
> I am looking for an example of a web application (WAR) which executea a
> Postgres actions. This aims to test the performance of Postgres in Web
> mode.
> I shall be grateful if someone gives me a link where I can find a WAR file.

A WAR file? Postgres is peace, not war ;)
Seriously, for postgres to be used for web applications (as nowadays
RPC-Server with XML over HTTP are commonly named ;) you need to settle
for an application server (available for many technologies - choose
whatever you feel comfortable with) which then connects back to
postgres.

Regards
Tino

"Mohamed Ali JBELI" <medali.jbeli@gmail.com> wrote:
>
> Hi members
>
> I am looking for an example of a web application (WAR) which executea a
> Postgres actions. This aims to test the performance of Postgres in Web mode.
>
> I shall be grateful if someone gives me a link where I can find a WAR file.

I think you're going to have to be more specific.  I don't know what
technology uses WAR files, and based on the tepid response, it doesn't
seem like anyone else on the list does either.

What program are you using that uses the WAR files?

--
Bill Moran
Collaborative Fusion Inc.

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

On 17-Feb-08, at 10:18 AM, Bill Moran wrote:

> "Mohamed Ali JBELI" <medali.jbeli@gmail.com> wrote:
>>
>> Hi members
>>
>> I am looking for an example of a web application (WAR) which
>> executea a
>> Postgres actions. This aims to test the performance of Postgres in
>> Web mode.
>>
>> I shall be grateful if someone gives me a link where I can find a
>> WAR file.
>
> I think you're going to have to be more specific.  I don't know what
> technology uses WAR files, and based on the tepid response, it doesn't
> seem like anyone else on the list does either.
>
Java uses WAR files, it's a specific JAR file layout.

To answer your question.

http://blogs.sun.com/tomdaly/entry/sun_pushing_price_performance_curve

was done using a java web application.

Dave

> > I am looking for an example of a web application (WAR) which executea a
> > Postgres actions. This aims to test the performance of Postgres in Web mode.
> > I shall be grateful if someone gives me a link where I can find a WAR file.
> I think you're going to have to be more specific.  I don't know what
> technology uses WAR files, and based on the tepid response, it doesn't
> seem like anyone else on the list does either.
> What program are you using that uses the WAR files?

WAR is a way of packaging J2EE applications for Java app servers like
Tomcat, JBoss, etc...  I have no idea what the question is looking for;
there are hundreds, if not thousands, of J2EE applications that use
PostgreSQL (OpenNMS, OpenReports, OpenBravo, JOPE,....).  And likely
100% of those connect via JDBC with entirely standard and fairly
database-agnostic code.

And I think a "performance test" from a J2EE application is just as
likely to measure the performance of the particular J2EE platform [and
configuration] then it is to tell you much about PostgreSQL performance.
For performance testing (of the JDBC driver/connection) it would be
better to connect from a simple Java application (without any of the app
server overhead) otherwise you have no idea who/what you are measuring
[unless your a J2EE guru].

--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org