Using Postgres with CGI's

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.

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

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 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. __