pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedExample web access to Postgres DB
5+ messages / 5 participants
[nested] [flat]
* Example web access to Postgres DB
@ 2008-02-17 11:21 Mohamed Ali JBELI <medali.jbeli@gmail.com>
2008-02-17 13:53 ` Re: Example web access to Postgres DB Tino Wildenhain <tino@wildenhain.de>
2008-02-17 15:18 ` Re: Example web access to Postgres DB Bill Moran <wmoran@collaborativefusion.com>
0 siblings, 2 replies; 5+ messages in thread
From: Mohamed Ali JBELI @ 2008-02-17 11:21 UTC (permalink / raw)
To: pgsql-performance
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.
Thank you
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Example web access to Postgres DB
2008-02-17 11:21 Example web access to Postgres DB Mohamed Ali JBELI <medali.jbeli@gmail.com>
@ 2008-02-17 13:53 ` Tino Wildenhain <tino@wildenhain.de>
1 sibling, 0 replies; 5+ messages in thread
From: Tino Wildenhain @ 2008-02-17 13:53 UTC (permalink / raw)
To: Mohamed Ali JBELI <medali.jbeli@gmail.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Example web access to Postgres DB
2008-02-17 11:21 Example web access to Postgres DB Mohamed Ali JBELI <medali.jbeli@gmail.com>
@ 2008-02-17 15:18 ` Bill Moran <wmoran@collaborativefusion.com>
2008-02-17 16:12 ` Re: Example web access to Postgres DB Dave Cramer <pg@fastcrypt.com>
2008-02-17 16:22 ` Re: Example web access to Postgres DB Adam Tauno Williams <adamtaunowilliams@gmail.com>
1 sibling, 2 replies; 5+ messages in thread
From: Bill Moran @ 2008-02-17 15:18 UTC (permalink / raw)
To: Mohamed Ali JBELI <medali.jbeli@gmail.com>; +Cc: pgsql-performance
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Example web access to Postgres DB
2008-02-17 11:21 Example web access to Postgres DB Mohamed Ali JBELI <medali.jbeli@gmail.com>
2008-02-17 15:18 ` Re: Example web access to Postgres DB Bill Moran <wmoran@collaborativefusion.com>
@ 2008-02-17 16:12 ` Dave Cramer <pg@fastcrypt.com>
1 sibling, 0 replies; 5+ messages in thread
From: Dave Cramer @ 2008-02-17 16:12 UTC (permalink / raw)
To: Bill Moran <wmoran@collaborativefusion.com>; +Cc: Mohamed Ali JBELI <medali.jbeli@gmail.com>; pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Example web access to Postgres DB
2008-02-17 11:21 Example web access to Postgres DB Mohamed Ali JBELI <medali.jbeli@gmail.com>
2008-02-17 15:18 ` Re: Example web access to Postgres DB Bill Moran <wmoran@collaborativefusion.com>
@ 2008-02-17 16:22 ` Adam Tauno Williams <adamtaunowilliams@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Adam Tauno Williams @ 2008-02-17 16:22 UTC (permalink / raw)
To: pgsql-performance
> > 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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-02-17 16:22 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-17 11:21 Example web access to Postgres DB Mohamed Ali JBELI <medali.jbeli@gmail.com>
2008-02-17 13:53 ` Tino Wildenhain <tino@wildenhain.de>
2008-02-17 15:18 ` Bill Moran <wmoran@collaborativefusion.com>
2008-02-17 16:12 ` Dave Cramer <pg@fastcrypt.com>
2008-02-17 16:22 ` Adam Tauno Williams <adamtaunowilliams@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox