Next Previous Contents

4. Ti einai h PostgreSQL ;

H PostgreSQL ekdosh 6.4 einai mia dwrean bash, me thn opoia sas dinetai olos o phgaios kwdikas kai einai ena Susthma Antikeimenostrafhs-Sxesiakh Bashs Dedomenwn sxedon symbath me (plhsiazei olo kai perissotero) me to ANSI SQL1998,92,89 kai trexei se diaforetikes platformes hardware kai Leitoyrgika systhmata. 

        Merikes fores bgainoyn se kykloforia ektaktes dior8wseis, mpalwmata (patches) gia dior8wseis 
        la8wn meta thn ekdosh GA PostgreSQL. Mporeite na efarmosete ta proairetika patches
        analoga me tis anagkes ths efarmoghs sas. Akoloy8hste ta parakatw 
        bhmata gia na efarmosete ta patches -
        Phgainete ston katalogo poy brisketai o kwdikas ths postgresql
                cd /usr/src/postgresql6.3.1
                patch -p0 < patchfile
                make clean
                make
        Deite epishs th selida boh8eias grafontas 'man patch'
Ta arxeia gia patch briskontai sto

O apolytos skopos kai o telikos stoxos ths PostgreSQL einai ginei 100 % symbath me thn ANSI/ISO SQL kai na ginei epishs h noumero ENA Anoikth Genikh Bash ston kosmo. H PostgreSQL epishs 8a odhghsei, diey8unei, elegjei, parakoloy8hsei kai ypagoreusei to mellon ths ANSI/ISO SQL. Ayto giati, h ylopoihsh kai oi idees ginontai prwta sthn PostgreSQL kai epeita enswmatwnontai sthn ANSI/ISO SQL.

O Informix Universal server (ekdo8hke to 1997) basizetai se prohgoumenh ekdosh ths PostgreSQL epeidh h Informix agorase thn Illustra Inc. kai enopoih8hke me thn Informix. H bash Illustra htan plhrws basismenh sthn Postgres (prohgoumenh ekdosh ths PostgreSQL).

H PostgreSQL einai mia epektash toy systhmatos diaxeirishs ths bashs dedomenwn POSTGRES, ena epomenhs genias protypo ereynas DBMS. Enw h PostgreSQL diathrei to dynamiko montelo dedomenwn kai toys plousioys tupoys dedomenwn ths POSTGRES, antika8ista thn glwssa erwthsewn PostQuel me ena ektetameno yposunolo ths SQL.

H anaptyjh ths PostgreSQL ginetai apo mia omada programmatistwn sto Internet poy einai oloi grammenoi sth lista allhlografias anaptyjhs ths PostgreSQL. Syntonisths ths omadas einai o Marc G. Fournier

Ayth h omada einai ypeu8ynh gia olh thn trexoysa kai mellontikh anaptyjh ths PostgreSQL. Fysika, o idios o pelaths basewn dedomenwn einai aytos poy anaptussei thn PostgreSQL! To fortio ths anaptyjhs dianemetai se ena polu megalo ari8mo telikwn xrhstwn basewn sto internet.

Oi syggrafeis ths PostgreSQL 1.01 einai oi Andrew Yu kai Jolly Chen. Polloi alloi syneiseferan se ayth th metafora, to testarisma, thn aposfalmatwsh kai thn epektash toy kwdika. O arxikos kwdikas ths Postgres, ap' opoy proekyce h PostgreSQL, htan h prospa8eia pollwn apofoitwn spoydastwn, metaptyxiakwn, kai proswpikou programmatistwn poy doulecan katw apo thn epiblech toy Ka8hghth Michael Stonebraker sto Panepisthmio ths Kalifornia, sto Berkeley.

To arxiko onoma toy logismikou sto Berkeley htan Postgres. Otan proste8hke h leitoyrgikothta gia SQL to 1995, to onoma allaje se Postgres95. To onoma allaje pali sto telos toy 1996 se PostgreSQL.

Ekatommuria PostgreSQL exoyn egkatasta8ei ws diakomistes basewn dedomenwn, Web database serverskai Application data servers. Einai polu proxwrhmenh, kai einai antikeimenostrafhs sxesiakh bash dedomenwn (ORDBMS).

H PostgreSQL mporei na apo8hkeusei perissoteroys tupoys dedomenwn apo toys paradosiakous tupoys dedomenwn opws integer, characters, klp. - mporeite na dhmioyrghsete toys dikous sas orismenoys tupoys, synarthseis, klhronomikothta klp. H PostgreSQL trexei se Solaris, SunOS, HPUX, AIX, Linux, Irix, Digital Unix, BSDi,NetBSD, FreeBSD, SCO unix, NEXTSTEP, Unixware kai se opoiodhpote tupo Unix. H metafora ths se Windows 95/NT einai se ejelijh.

H PostgreSQL kai ta sxetika kommatia toy keimenoy ypokeintai sthn parakatw PNEYMATIKH IDIOKTHSIA. 
PostgreSQL Susthma Diaxeirishs Bashs Dedomenwn

Pneymatikh Idiokthsia (c) toy panepisthmioy ths California

Adeia gia xrhsh, antigrafh, metabolh, kai dianomh aytou toy logismiko kai ths 
tekmhriwshs toy gia opoiodhpote skopo, xwris telh, kai xwris grapth symfwnia
parexetai, me thn proupo8esh oti to shmeiwma pneymatikhs idiokthsias kai 
ayth kai oi parakatw duo paragrafoi 8a emfanizontai se oles tis kopies.

ME KANENAN TROPO, DEN 8A 8EWRH8EI TO PANEPISTHMIO THS KALIFORNIA NOMIKA YPEY8YNO
GIA AMESH, EMMESH, EIDIKH, TYXAIA, H PARAGWMENH ZHMIA, SYMPERILAMANOMENHS KAI THS
APWLEIAS KERDWN POY PROEKYYE APO THN XRHSH AYTOY TOY LOGISMIKOY KAI THS
TEKMHRIWSHS TOY, AKOMA KAI AN TO PANEPISTHMIO THS KALIFONIA EXEI EIDOPOIH8EI GIA
THN PI8ANOTHTA MIAS TETOIAS ZHMIAS.

TO PANEPISTHMIO THS KALIFORNIA EIDIKA APARNEITAI KA8E EGGYSHSH, SYMPERILAMBANOMENHS, 
ALLA OXI PERIORISMENHS MONO SE AYTHN, THS YPONOOYMENHS EGGYHSHS XRHSHS, KAI XRHSHS
GIA KAPOIO SYGKEKRIMENO SKOPO. TO LOGISMIKO POY PAREXETAI EDW EINAI SE BASH "WS EXEI"
KAI TO PANEPISTHMIO THS KALIFORNIAS DEN EXEI YPOXREWSH GIA PAROXH SYNTHRHSHS, ENHMERWSEWN,
EMPLOYTISMWN, H TROPOPOIHSEWN.
Next Previous Contents