12. Ergaleia Diaxeirishs ths PostgreSQL

12.1 PGACCESS - Ena grafiko ergaleio gia th diaxeirish ths PostgreSQL

To PgAccess einai ena Tcl/Tk interface gia thn PostgreSQL. Symperilambanetai hdh sth dianomh ths PostgreSQL. Rijte mia matia se ayto to web site gia neoterh ekdosh

• http://www.flex.ro/pgaccess
• An exete opoiodhpote sxolio, protash gia beltiwsh, mh distasete na steilete e-mail sto : teo@flex.ro

Xarakthristika toy PgAccess

Para8yra toy PgAccess : Kentriko para8yro , dhmioyrgia pinakwn (table builder) , Emfanish pinakwn (erwthsewn) (table(query) view), dhmioyrgia erwthsewn optika (visual query builder).

Pinakes

• - emfanish pinakwn, megisto 200 eggrafes (allazei apo to menou preferences)
• - allagh mege8oys sthlhs, sernontas thn ka8eth grammh (kalutera sto xwro toy pinaka apo oti sthn epikefalida toy pinaka)
• - text wrap sta kelia - apo8hkeysh ths emfanishs ka8e pinaka
• - import/export se ejwterika arxeia (SDF,CSV)
• - dynatothtes filtrarismatos (dwste ena filtro san price>3.14)
• - dynatothtes tajinomhshs (dwste xeirokinhta to(ta) pedia pros tajinomhsh)
• - editing in place
• - beltiwmeno boh8hma gia paragwgh pinakwn (table generator assistant)
• - beltiwmenes dynatothtes dior8wshs pediwn

• - dhmioyrgei, dior8wnei kai apo8hkeuei "erwthseis poy ka8orizei o xrhsths"
• - apo8hkeuei erwthseis san views
• - ektelei erwthseis
• - emfanish apotelesmatwn erwthsewn tupoy select
• - diagrafh kai allagh onomatos erwthshs
• - Grafiko xtisimo erwthshs me dynatothtes drag & drop. Gia osoys apo esas eixate sthsei to Tcl/Tk plugin gia to Netscape Navigator, mporeite na to deite na doyleuei patwntas edw

• - dhmioyrgia sequences, diagrafh kai elegxos toys Synarthseis
• - dhmioyrgia, elegxos kai diagrafh synarthsewn se glwssa SQL

Mellontikes ylopoihseis

• - sxediasmos pinakwn (pros8hkh newn pediwn, allagh onomatos, klp.)
• - ka8orismos synarthshs
• - dhmioyrgia report
• - basiko scripting

An exete opoiodhpote sxolio, protash gia beltiwsh, mh distasete na steilete e-mail sto :

• teo@flex.ro

Perissoteres plhrofories gia th biblio8hkh libgtcl

8a xreiasteite epishs na dhlwsete pros xrhsh th biblio8hkh diasundeshs PostgreSQL se Tcl san ena Tcl/Tk 'load'-able module. Onomazetai libpgtcl kai o phgaios kwdikas ths brisketai ston katalogo ths PostgreSQL /src/interfaces/libpgtcl. 8a xreiasteite idiaitera, mia biblio8hkh libpgtcl poy na mporei na fortw8ei apo Tcl/Tk. Ayto einai diaforetiko texnika apo ena typiko PostgreSQL loadable object arxeio, epeidh h libpgtcl einai mia syllogh apo object arxeia. Katw apo Linux, onomazetai libpgtcl.so. Mporeite na katebasete apo edw mia ekdosh hdh metaglwttismenh gia systhmata Linux i386. Apla antigracte to libpgtcl.so ston katalogo biblio8hkwn toy systhmatos (/usr/lib)kai jekinhste. Mia lush einai na afairesete apo ton phgaio kwdika th grammh poy periexei to fortwma ths libpgtcl.so kai na fortwsete th pgaccess.tcl oxi me wish, alla me pgwish (h wishpg) ayto to wish me to opoio eixe ginei link me th biblio8hkh libpgtcl.

12.2 Windows Interactive Query Tool gia PostgreSQL (WISQL h MPSQL)

H MPSQL parexei stoys xrhstes ena grafiko SQL interface gia thn PostgresSQL. H MPSQL einai paromoia me to SQL Worksheet ths Oracle kai to ergaleio erwthsewn toy Microsoft SQL Server WISQL. Exei wraio grafiko interface kai istoriko entolwn. Epishs mporeite na kanete cut kai paste kai exei kai alla wraia xarakthristika poy beltiwnoyn thn paragwgikothta.

• http://www.troubador.com/~keidav/index.html
• Email: keidav@whidbey.com
• http://www.ucolick.org/~de/ sto arxeio tcl_syb/wisql.html
• http://www.troubador.com/~keidav/index.html
• Email: de@ucolick.org

12.3 Interactive Query Tool(ISQL) gia thn PostgreSQL - Onomazetai PSQL

To ISQL einai gia termatika me Character command line. Perilambanetai sth dianomh, kai legetai PSQL. Moiazei polu me to ISQL ths Sybase, kai to SQLplus ths Oracle. Sto unix prompt dwste thn entolh 'psql' h opoia 8a sas bgalei se psql> prompt.

Pathste \h gia na deite th boh8eia twn entolwn.

12.4 MPMGR - Ergaleio Diaxeirishs Basewn gia PostgresSQL

To MPMGR parexei ena grafiko interface diaxeirishs ths PostgresSQL. 8a to breite sto

• www.mutinybaysoftware.com/
• Email: keidav@mutinybaysoftware.com
• http://www.troubador.com/~keidav/index.html
• Email: keidav@whidbey.com
• http://www.ucolick.org/~de in file tcl_syb/wisql.html
• WISQL gia thn PostgreSQL http://www.ucolick.org/~de/Tcl/pictures
• Email: de@ucolick.org