Next Previous Contents

18. Epikoinwnia metaju PostgreSQL kai WWW - WDB-P95

18.1 Sxetika me to wdb-p95

WDB-P95 - Ena Web interface gia baseis PostgreSQL apo ton J. Douglas Dunlop Brisketai sto

Einai mia tropopoihmenh ekdosh toy wdb-1.3a2 poy parexei mia sundesh sto WWW gia thn PostgreSQL. Ayth h ekdosh apaitei epishs ena Browser ikano na xeirizetai pinakes HTML gia thn ejodo se pinakes (tabular output). Ayto den apaiteitai apo to arxiko wdb kai mporei na epanafer8ei sthn palia morfh toy sxetika eukola.

Mporeite na dokimasete ta CASI Tape kai Image Query. Mporeite na rijete mia grhgorh matia sto Form Definition File (FDF) poy xrhsimopoihsa gia na ftiajw ta CASI Tape kai Image Query epishs, poy perilambanei ena JOIN 2 pinakwn.

Ayth h ekdosh periexei ola ta aparaithta arxeia gia thn egkatastash kai ektelesh toy WDB-P95 san diasundesh me tis PostgreSQL baseis sas. H metafora toy systhmatos se allh bash 8a prepei na einai sxetika eukolh - ypo thn proupo8esh pws yposthrizei stantar SQL kai exei interface se Perl.

18.2 Einai aparaithto o diakomisths ths PostgreSQL, to pgperl, kai to httpd na einai ston idio host;

Oxi - o diakomisths ths PostgreSQL diakomisths de xreiazetai na einai sto idio host. To WDB-P95 epeidh kaleitai apo ton http daimona, prepei na einai sto idio host - kai ka8ws to WDB-P95 grafthke gia na xrhsimopoiei to Pg.pm - to pgperl prepei na einai sto idio host epishs. To Pgperl grafthke xrhsimopoiwntas th biblio8hkh libpq, etsi mporei na exei prosbash se opoiodhpote diakomisth PostgreSQL opoydhpote sto diktyo, opws opoiosdhpote allos pelaths PostgreSQL. Opws fainetai parakatw

(WWW Client (Netscape)) => (HTTP Server (NCSA's http) + WDB-P95 + pgperl + libpq)=> (PostgreSQL server)

Oi paren8eseis () anaparistoun mhxanhmata.

Ka8e mhxanhma mporei na einai diaforetikou tupoy : NT, SUN, HP, ... alla xreiazeste th biblio8hkh diasundeshs libpq gia ton tupo mhxanhmatos poy skopeuete na xrhsimopoihsete to WDB-P95, gia na metaglwttisete to pgperl. (To susthma sxediasthke gia na xrhsimopoiei HTML pinakes gi' ayto einai protimoteros enas prosfatos WWW client).


Next Previous Contents