Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using Postgres with CGI's

Using Postgres with CGI's

From
fabian baena
Date:
Hi,

I'm trying to biuld a database that I can use with a browser like netscape
or something like that.
I want to know if I can do this, and if I can, where can I get information
on how to do this.
Thank you.


Fabian.


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Re: [GENERAL] Using Postgres with CGI's

From
Oleg Broytmann
Date:
On Fri, 4 Jun 1999, fabian baena wrote:
> I'm trying to biuld a database that I can use with a browser like netscape
> or something like that.
> I want to know if I can do this, and if I can, where can I get information
> on how to do this.

   Of course, you cannot use Postgres with browser. You need WWW server and
CGI programs, that draw data from a database, prepare HTML and pass it to
browser.
   First, you need to learn what is CGI in general. Choose a language for
writing CGI. These days perl used widely, but it is hard to learn. I
recommend to learn Python. I can give you some advices/demos on how to
write CGI scripts using Python and Postgres.

> Thank you.

> Fabian.

Oleg.
----
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.

Re: [GENERAL] Using Postgres with CGI's

From
John Browning
Date:
> On Fri, 04 Jun 1999 23:24:12 COT, fabian baena <fabbaena@hotmail.com> said:

  > Hi,
  > I'm trying to biuld a database that I can use with a browser like netscape
  > or something like that.
  > I want to know if I can do this, and if I can, where can I get information
  > on how to do this.
  > Thank you.

In theory, AOLServer has quite good integration with database
programs, including postgres. It offers ready-made options to do the
following things from any browser

Table Maintenance

      Create at new table

      Customize Table
      Extend Table
      Drop Table
      Search a Table
      Enter Data into a Table
      Set permissions for a database table
      Get Table Schema
      Get Data
      Execute Arbitrary SQL

(In practice, I must admit that I'm having problems getting it to
work, but hopefully that's another story...)

AOLServer runs on various Unixes and is free from
http://www.aolserver.com. Next version is allegedly open source as
well.

Check out also http://6916.lcs.mit.edu/ which is MIT's course on
data-base driven Web sites and lists a lot of fun stuff you can do
with databases on the Web.

bests

Re: [GENERAL] Using Postgres with CGI's

From
"Rudy Gireyev"
Date:
What about running JAVA applets that will run in a browser and
connect to PostgreSQL using JDBC?

Rudy

On 5 Jun 99, at 18:29, John Browning wrote:

> > On Fri, 04 Jun 1999 23:24:12 COT, fabian baena <fabbaena@hotmail.com>
> > said:
>
>   > Hi,
>   > I'm trying to biuld a database that I can use with a browser like
>   netscape > or something like that. > I want to know if I can do this,
>   and if I can, where can I get information > on how to do this. > Thank
>   you.
>
> In theory, AOLServer has quite good integration with database
> programs, including postgres. It offers ready-made options to do the
> following things from any browser
>
> Table Maintenance
>
>       Create at new table
>
>       Customize Table
>       Extend Table
>       Drop Table
>       Search a Table
>       Enter Data into a Table
>       Set permissions for a database table
>       Get Table Schema
>       Get Data
>       Execute Arbitrary SQL
>
> (In practice, I must admit that I'm having problems getting it to
> work, but hopefully that's another story...)
>
> AOLServer runs on various Unixes and is free from
> http://www.aolserver.com. Next version is allegedly open source as
> well.
>
> Check out also http://6916.lcs.mit.edu/ which is MIT's course on
> data-base driven Web sites and lists a lot of fun stuff you can do
> with databases on the Web.
>
> bests
>
>
>

Re: [GENERAL] Using Postgres with CGI's

From
dustin sallings
Date:
On Sat, 5 Jun 1999, Rudy Gireyev wrote:

// What about running JAVA applets that will run in a browser and
// connect to PostgreSQL using JDBC?

    There are lots of security and performance problems here.  That
makes sense on a very small intranet installation that you don't expect to
grow.

// Rudy
//
// On 5 Jun 99, at 18:29, John Browning wrote:
//
// > > On Fri, 04 Jun 1999 23:24:12 COT, fabian baena <fabbaena@hotmail.com>
// > > said:
// >
// >   > Hi,
// >   > I'm trying to biuld a database that I can use with a browser like
// >   netscape > or something like that. > I want to know if I can do this,
// >   and if I can, where can I get information > on how to do this. > Thank
// >   you.
// >
// > In theory, AOLServer has quite good integration with database
// > programs, including postgres. It offers ready-made options to do the
// > following things from any browser
// >
// > Table Maintenance
// >
// >       Create at new table
// >
// >       Customize Table
// >       Extend Table
// >       Drop Table
// >       Search a Table
// >       Enter Data into a Table
// >       Set permissions for a database table
// >       Get Table Schema
// >       Get Data
// >       Execute Arbitrary SQL
// >
// > (In practice, I must admit that I'm having problems getting it to
// > work, but hopefully that's another story...)
// >
// > AOLServer runs on various Unixes and is free from
// > http://www.aolserver.com. Next version is allegedly open source as
// > well.
// >
// > Check out also http://6916.lcs.mit.edu/ which is MIT's course on
// > data-base driven Web sites and lists a lot of fun stuff you can do
// > with databases on the Web.
// >
// > bests
// >
// >
// >
//
//
//
//

--
Principal Member Technical Staff, beyond.com    The world is watching America,
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L______________________________________________ and America is watching TV. __