pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedTrying to find a PostgreSQL interface
7+ messages / 6 participants
[nested] [flat]
* Trying to find a PostgreSQL interface
@ 1999-08-24 11:02 Daniel Stolk <stolkd@email.com>
0 siblings, 1 reply; 7+ messages in thread
From: Daniel Stolk @ 1999-08-24 11:02 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
Hi,
I'm needing to access my PostgreSQL database from the web, or actually
the customers need to. I was originally using C with the libpq library,
but I was wondering if there are some programs out there that would make
it easier and faster for me to set things up? If there aren't, what
kind of interface would be best to use? I was looking at PHP, but I'm
not sure it will be as powerful as C, but maybe it is powerful enough.
Thanks for any help, Daniel Stolk
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Trying to find a PostgreSQL interface
@ 1999-08-25 04:08 Mark Linvill <mlinvill@cioe.com>
parent: Daniel Stolk <stolkd@email.com>
0 siblings, 2 replies; 7+ messages in thread
From: Mark Linvill @ 1999-08-25 04:08 UTC (permalink / raw)
To: Daniel Stolk <stolkd@email.com>; +Cc: pgsql-interfaces@hub.org
On Tue, 24 Aug 1999, Daniel Stolk wrote:
>Hi,
>
>I'm needing to access my PostgreSQL database from the web, or actually
>the customers need to. I was originally using C with the libpq library,
>but I was wondering if there are some programs out there that would make
>it easier and faster for me to set things up? If there aren't, what
>kind of interface would be best to use? I was looking at PHP, but I'm
>not sure it will be as powerful as C, but maybe it is powerful enough.
>
IMHO, PHP is plenty powerful enough. Development time is
fabulously quick. The only possible issue might be execution speed.
Not that PHP is slow, but it can't beat a C CGI.
You'll want to think long and hard about the security implications of
using PHP though. Well, actually this depends on who's doing the
development. If you're letting the customers do it, it's a bigger
issue.
There are plenty of links to code snippets, etc. on the PHP web site.
www.php.net
I've been developing C/C++/PHP/PostgreSQL/Apache web interfaces for
about 2 years now. I highly recommend PHP, as well as PostgreSQL.
:)
-Mark
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Trying to find a PostgreSQL interface
@ 1999-08-25 07:17 Hannu Krosing <hannu@trust.ee>
parent: Mark Linvill <mlinvill@cioe.com>
1 sibling, 1 reply; 7+ messages in thread
From: Hannu Krosing @ 1999-08-25 07:17 UTC (permalink / raw)
To: mlinvill@winstar.com; +Cc: Daniel Stolk <stolkd@email.com>; pgsql-interfaces@hub.org
Mark Linvill wrote:
>
> On Tue, 24 Aug 1999, Daniel Stolk wrote:
>
> >Hi,
> >
> >I'm needing to access my PostgreSQL database from the web, or actually
> >the customers need to. I was originally using C with the libpq library,
> >but I was wondering if there are some programs out there that would make
> >it easier and faster for me to set things up? If there aren't, what
> >kind of interface would be best to use? I was looking at PHP, but I'm
> >not sure it will be as powerful as C, but maybe it is powerful enough.
You may also try Zope (http://www.zope.org)
> IMHO, PHP is plenty powerful enough. Development time is
> fabulously quick. The only possible issue might be execution speed.
> Not that PHP is slow, but it can't beat a C CGI.
AFAIK you can save the CGI startup costs as PHP is loaded as a module in
Apache. If it has persistent database connections (like Zope) then you
also
save the DB connection setup and so it can easyly beat C CGI on anything
but most compute-intensive tasks.
-----
Hannu
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: [INTERFACES] Trying to find a PostgreSQL interface
@ 1999-08-25 07:54 Mengelbier, Magnus <Magnus.Mengelbier@clinicaldatacare.com>
0 siblings, 0 replies; 7+ messages in thread
From: Mengelbier, Magnus @ 1999-08-25 07:54 UTC (permalink / raw)
To: 'Daniel Stolk' <stolkd@email.com>; +Cc: pgsql-interfaces@hub.org
Hello Daniel
We are also developing a web-cgi-postgresql environment. We decided to go
with Perl since it is easy to change the scripting and also because Apache
supports it with the module mod_perl. We are currently developing using the
CGI principle but as the system moves to final development, we will modify
the Perl scripts to run with mod_perl. You might also care to take a look
at C-or-java-servlets if performance is an issue and complexity is not.
Magnus
________________________________________________________
Magnus Mengelbier
Technical Consultant
Clinical Data Care
S:t Lars v. 41
SE-222 70 LUND
SWEDEN
Phone +46 46 14 22 80
Fax +46 46 13 04 90
Email magnus.mengelbier@clinicaldatacare.com
Web http://www.clinicaldatacare.com
> -----Original Message-----
> From: Daniel Stolk [SMTP:stolkd@email.com]
> Sent: den 24 augusti 1999 13:03
> To: pgsql-interfaces@hub.org
> Subject: [INTERFACES] Trying to find a PostgreSQL interface
>
> Hi,
>
> I'm needing to access my PostgreSQL database from the web, or actually
> the customers need to. I was originally using C with the libpq library,
> but I was wondering if there are some programs out there that would make
> it easier and faster for me to set things up? If there aren't, what
> kind of interface would be best to use? I was looking at PHP, but I'm
> not sure it will be as powerful as C, but maybe it is powerful enough.
>
> Thanks for any help, Daniel Stolk
>
> ************
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Trying to find a PostgreSQL interface
@ 1999-08-25 11:57 The Hermit Hacker <scrappy@hub.org>
parent: Mark Linvill <mlinvill@cioe.com>
1 sibling, 0 replies; 7+ messages in thread
From: The Hermit Hacker @ 1999-08-25 11:57 UTC (permalink / raw)
To: mlinvill@winstar.com; +Cc: Daniel Stolk <stolkd@email.com>; pgsql-interfaces@hub.org
On Tue, 24 Aug 1999, Mark Linvill wrote:
> On Tue, 24 Aug 1999, Daniel Stolk wrote:
>
> >Hi,
> >
> >I'm needing to access my PostgreSQL database from the web, or actually
> >the customers need to. I was originally using C with the libpq library,
> >but I was wondering if there are some programs out there that would make
> >it easier and faster for me to set things up? If there aren't, what
> >kind of interface would be best to use? I was looking at PHP, but I'm
> >not sure it will be as powerful as C, but maybe it is powerful enough.
> >
>
> IMHO, PHP is plenty powerful enough. Development time is
> fabulously quick. The only possible issue might be execution speed.
> Not that PHP is slow, but it can't beat a C CGI.
Actually, if you load PHP "as recommended", which is as an Apache module
vs using it as a CGI, it is faster then a straight C CGI ... my
preference, personally, remains using Perl CGIs (more flexible then Perl,
faster development time then C, and, if you use mod_perl, about the same
speed of execution as PHP-module)...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Trying to find a PostgreSQL interface
@ 1999-08-25 17:05 Daren R. Sefcik <daren@partnersdata.com>
parent: Hannu Krosing <hannu@trust.ee>
0 siblings, 1 reply; 7+ messages in thread
From: Daren R. Sefcik @ 1999-08-25 17:05 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
> You may also try Zope (http://www.zope.org)
FYI..I have just recently gotten ColdFusion on Solaris
to work with the ODBC driver and PostgreSQL-6.5.1.
I am still playing with it a bit, but it seems to be
working well...if anybody else is interested in doing this
as well I would be happy to hear from you.
Daren
PS..Zope is cool..I was using it until we decided to go with
ColdFusion.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Trying to find a PostgreSQL interface
@ 1999-08-25 19:54 Hannu Krosing <hannu@trust.ee>
parent: Daren R. Sefcik <daren@partnersdata.com>
0 siblings, 0 replies; 7+ messages in thread
From: Hannu Krosing @ 1999-08-25 19:54 UTC (permalink / raw)
To: Daren R. Sefcik <daren@partnersdata.com>; +Cc: pgsql-interfaces@hub.org
"Daren R. Sefcik" wrote:
>
> PS..Zope is cool..I was using it until we decided to go with
> ColdFusion.
BTW, what made you to switch ?
----------
Hannu
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~1999-08-25 19:54 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-24 11:02 Trying to find a PostgreSQL interface Daniel Stolk <stolkd@email.com>
1999-08-25 04:08 ` Mark Linvill <mlinvill@cioe.com>
1999-08-25 07:17 ` Hannu Krosing <hannu@trust.ee>
1999-08-25 17:05 ` Daren R. Sefcik <daren@partnersdata.com>
1999-08-25 19:54 ` Hannu Krosing <hannu@trust.ee>
1999-08-25 11:57 ` The Hermit Hacker <scrappy@hub.org>
1999-08-25 07:54 RE: [INTERFACES] Trying to find a PostgreSQL interface Mengelbier, Magnus <Magnus.Mengelbier@clinicaldatacare.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