Xa usebenza nesiseko sedatha okanye naluphi na uhlobo lwesoftware, kukho amaxesha apho amava ayonyuswa okanye kuthintelwe zizixhobo ozisebenzisayo ukunxibelelana nayo.
I-PostgreSQL inesixhobo somgca wokuyalela, i-psql, kwaye inamandla kakhulu, kodwa abanye abantu bakhetha umhleli wemizobo. Nangona umgca wokuyalela uhlala usetyenziswa, unokufuna ukusebenzisa isikrini esibonakalayo ngamanye amaxesha.
Kunjalo ngoba IMicrosoft yazisa iAzure Data Studio, umhleli we-GUI ovulekileyo oxhasa iiPostgres.
IMicrosoft ithathe ithuba lokuveza kwakhona imbonakalo yePostgreSQL yolwandiso ehambelana neKhowudi yeVenkile yeVidiyo (iKhowudi yeVS). Idatha yeAzure yeStudiyo kunye neKhowudi yeVS yimithombo evulekileyo kwaye iyandiswa, izinto ezimbini ezisekwe kwiPostgreSQL.
Malunga neAzure Data Studio
Indawo yeDatha yeDatha, Umhleli weMicrosoft ovulekileyo wokusebenza kunye neenkcukacha ze-SQL, ngoku ikwaxhasa iPostgreSQL.
Umdibaniso usonjululwa ngokwandiswa onokuthi uqhagamshele umhleli ngqo kwiseva yakho yePostgres. Ayinamsebenzi ukuba ibanjelwe ngokwakho, ibaleka kumatshini obonakalayo, okanye njengomzekelo olawulwayo kunye nomboneleli welifu.
Ukuba kusetyenziswa iiseva ezininzi zePostgres, ungazidibanisa kwiAzure Data Studio, eya kuthi ichongwe ngokulula ngokunika nganye "umbala" owahlukileyo.
Oku ukunqanda ngengozi ukudideka iserver yophuhliso neseva yemveliso. Umbono we-hierarchical ukuvumela ukuba ubone ngokulula zonke iikholamu, izalathiso, izinto ezibangela, kunye nemisebenzi kwindawo nganye yedatha kunye netafile.
Studio Studio yeAzure ifa ilifa amanqaku amaninzi kwiKhowudi yeVS. Iyahambelana noninzi lwekhowudi ye-VS, enje ngePython, R, kunye neKubernetes.
Kwakhona, umhleli kufuneka abancede babhale imibuzo. Yale, Umshicileli une-Intellisense, ukugqitywa kwekhowudi yemithombo kaMicrosoft.
Kwelinye icala inqaku eliqhelekileyo le-snippet kwiKhowudi yeVenkile yeVidiyo idityanisiwe kumhleli. Apho unokugcina imibuzo esetyenziswa rhoqo ye-SQL kwaye uyisebenzise kwakhona xa kukho imfuneko.
Studio Studio yeAzure ijolise ikakhulu kwiingcali zedatha. Ke ngoko, iMicrosoft ikwaphucule iPostgreSQL yolwandiso lweKhowudi yeVenkile yeVidiyo kwabo basebenzisa iiPostgres zolwazi njengabaphuhlisi besicelo.
Kwakhona, okwangoku ikwinguqulelo yokubonisa kwangaphambili. Ke ngoko, zombini izandiso zomhleli zinokuqulatha enye okanye enye impazamo.
Ukuba elona tyala lakho lolawulo liphambili kulawulo lwedatha, iAzure Data Studio inokuba lukhetho olufanelekileyo.
Well lento ikuvumela ukuba ulawule unxibelelwano oluninzi lwedatha, uphonononge uluhlu lwezinto zedatha, uqwalasele iideshibhodi kunye nokunye.
Kwelinye icala, ukuba ukufuphi kuphuhliso lwesicelo kunolawulo lwedatha, iMicrosoft ibonelela ngolwandiso lwePostgreSQL kwiKhowudi yeVS.
Uyifaka njani iAzure Data Studio kwiBuntu nakwiziphumo?
Kulabo abanomdla wokufaka lo mhleli kwiinkqubo zabo, Unokwenza njalo ngokulandela imiyalelo esabelana nawe ngezantsi.
Into yokuqala esiza kuyenza kukuba khuphela iphakheji ezinzileyo yakutshanje kumhleli kusuka eli khonkco lilandelayo.
Ngoku masenze Khuphela ukongezwa kwenkxaso yePostgreSQL kwikhonkco elingezantsi.
Sele ndiyenzile into ekhutshelweyo Kuya kufuneka sifake umhleli kunye nomphathi wephakheji oyithandayo okanye kwisiphelo sendlela ngokuchwetheza lo myalelo ulandelayo:
sudo dpkg -i azuredatastudio*.deb
Kwaye xa unengxaki yokuxhomekeka, siyisombulula ngokuchwetheza oku kulandelayo:
sudo apt -f install
Ukufaka i-PostgreSQL yolwandiso
Ngoku ukongeza ulwandiso lwenkxaso yePostgreSQL. Kuqala siza kuvula iAzure Data Studio nangaphakathi Kuya kufuneka sikhethe i-icon yolwandiso ukusuka kwibar esecaleni kwiAzure Data Studio.
Kwibha yokukhangela, bhala 'postgresql'. Khetha ulwandiso lwePostgreSQL.
Khetha ukufaka. Nje ukuba ufake, khetha ulayishe kwakhona ukwenza ulwandiso kwiAzure Data Studio.