Lapho usebenza ne-database noma olunye uhlobo lwesoftware, kunezikhathi lapho ulwazi luthuthukiswa khona noma uvinjelwe amathuluzi owasebenzisayo ukuxhumana nawo.
IPostgreSQL inethuluzi lomugqa womyalo, i-psql, futhi inamandla impela, kepha abanye abantu bakhetha kakhulu isihleli sokuqhafaza. Yize umugqa womyalo uvame ukusetshenziswa, ungahle uthande ukusebenzisa isikrini esibukwayo kwesinye isikhathi.
Yingakho ke IMicrosoft yethule i-Azure Data Studio, isihleli somthombo ovulekile se-GUI esisekela iPostgres.
IMicrosoft ithathe leli thuba ukwethula nokubukwa kuqala kwesandiso sePostgreSQL ehambelana ne-Visual Studio Code (VS Code). I-Azure Data Studio ne-VS Code zingumthombo ovulekile futhi ziyanda, izinto ezimbili okusekwe kuzo iPostgreSQL.
Mayelana ne-Azure Data Studio
I-Azure Data Studio, Isihleli somthombo ovulekile seMicrosoft sokusebenza ngemininingwane yolwazi ye-SQL, manje futhi isekela iPostgreSQL.
Ukuhlanganiswa kuxazululwa ngesandiso ongaxhuma ngaso isihleli ngqo kuseva yakho yePostgres. Akukhathalekile ukuthi ngabe kusingethwe wena uqobo, kusebenza umshini obonakalayo, noma njengesibonelo esiphethwe nomhlinzeki wefu.
Uma kusetshenziswa amaseva amaningi we-Postgres, ungawahlanganisa ndawonye ku-Azure Data Studio, ezokhonjwa kalula ngokunikeza ngamunye "umbala" ohlukile.
Lokhu ukuvikela ukudida ngengozi iseva yokuthuthuka neseva yokukhiqiza. Ukubuka okulandelanayo futhi kukuvumela ukuthi ubone kalula wonke amakholomu, izinkomba, okubangela, nemisebenzi yedatha ngayinye netafula ngalinye.
I-Azure Data Studio izuza njengefa izici eziningi kusuka ku-VS Code. Futhi iyahambisana nezandiso eziningi zekhodi ye-VS, njengePython, R, neKubernetes.
Futhi, umhleli kufanele abasize babhale imibuzo. Kwalokhu, umshicileli une-Intellisense, ukuqedwa kwekhodi yomthombo okuzenzakalelayo kweMicrosoft.
Ngakolunye uhlangothi isici samazwibela ajwayelekile esivela ku-Visual Studio Code sihlanganisiwe kusihleli. Lapho ungagcina imibuzo esetshenziswa njalo ye-SQL bese uyisebenzisa futhi uma kunesidingo.
I-Azure Data Studio ihloselwe ikakhulukazi ochwepheshe bemininingwane. Ngakho-ke, iMicrosoft iphinde yathuthukisa isandiso sePostgreSQL seVisual Studio Code yalabo abasebenzisa imininingwane yePostgres njengabathuthukisi bohlelo lokusebenza.
Futhi, okwamanje isenguqulweni yokubuka kuqala. Ngakho-ke, zombili izandiso zomhleli zingaqukatha iphutha elilodwa noma elinye.
Uma ikesi lakho lokusebenzisa eliyinhloko ukuphathwa kwedatha, i-Azure Data Studio ingaba yindlela enhle.
Well lokhu ikuvumela ukuthi uphathe ukuxhumeka okuningi kwe-database, uhlole ubukhosi bezinto ezigciniwe, ulungiselele amadeshibhodi, nokuningi.
Ngakolunye uhlangothi, uma useduze nokuthuthukiswa kohlelo lokusebenza kunokuphathwa kwedatha, iMicrosoft inikeza isandiso sePostgreSQL kuVS Code.
Ungayifaka kanjani i-Azure Data Studio ku-Ubuntu nakwezinye izinto?
Okwalabo abanentshisekelo yokufaka lo mhleli kuzinhlelo zabo, Ungenza kanjalo ngokulandela imiyalo esabelana nawe ngezansi.
Into yokuqala esizoyenza landa iphakethe elizinzile lakamuva kusuka kusihleli funa isixhumanisi esilandelayo.
Manje ake landa isandiso sokuxhaswa kwePostgreSQL kusuka kusixhumanisi esingezansi.
Usuqedile ukulanda Kufanele sifake isihleli nomphathi wethu wephakheji esiwuthandayo noma ovela esigungwini ngokuthayipha umyalo olandelayo kuso:
sudo dpkg -i azuredatastudio*.deb
Futhi uma uba nezinkinga ngokuncika, sizixazulula ngokuthayipha okulandelayo:
sudo apt -f install
Ukufaka isandiso se-PostgreSQL
Manje ukufaka isandiso sokusekela sePostgreSQL. Okokuqala sizovula i-Azure Data Studio nangaphakathi kufanele sikhethe isithonjana sezandiso kusuka kubha eseceleni ku-Azure Data Studio.
Kubha yokusesha, bhala 'postgresql'. Khetha isandiso se-PostgreSQL.
Khetha ukufaka. Uma usufakiwe, khetha ulayishe kabusha ukuze unike amandla isandiso ku-Azure Data Studio.