Lokacin aiki tare da rumbun adana bayanai ko kowane irin software, akwai lokuta lokacin da aka inganta ƙwarewar ko kuma abubuwan da kake amfani dasu don mu'amala dasu su hanaka
PostgreSQL yana da kayan aikin layin umarni, psql, kuma yana da karfi sosai, amma wasu mutane sun fi son editan zane. Kodayake yawanci ana amfani da layin umarni, kuna so ku yi amfani da allon gani a wasu lokuta.
Shi ya sa Microsoft ya gabatar da Azure Data Studio, mai bude GUI edita wanda ke tallafawa Postgres.
Microsoft ya ɗauki damar don gabatar da samfoti na ƙarin PostgreSQL daidai a Kayayyakin aikin hurumin kallo (VS Code). Azure Data Studio da VS Code sune tushen buɗewa kuma ana iya fadada su, abubuwa biyu waɗanda PostgreSQL ke kan su.
Game da Azure Data Studio
Cibiyar Nazarin Azure, Editan bude shafin Microsoft don aiki tare da bayanan SQL, yanzu kuma yana tallafawa PostgreSQL.
An warware haɗin kai ta hanyar faɗaɗa wanda zaku iya haɗa edita kai tsaye zuwa sabarku ta Postgres. Babu matsala idan an ɗauki bakuncin kansa, yana gudana a cikin wani inji mai mahimmanci, ko azaman misali mai gudanarwa tare da mai samar da gajimare.
Idan ana amfani da sabobin Postgres da yawa, za ku iya haɗa su a cikin Azure Data Studio, wanda za a iya gano shi cikin sauƙi ta hanyar ba kowane "launi" daban.
Wannan don kauce wa rikice rikicewar sabar ci gaba tare da sabar samarwa. Hakanan ra'ayi na matsayi yana ba ku damar ganin duk ginshiƙai, fihirisa, abubuwan jawowa, da ayyuka don kowane ɗakunan bayanai da tebur.
Azure DataStudio ya gaji abubuwa da yawa daga VS Code. Hakanan ya dace tare da yawancin kari na VS, kamar Python, R, da Kubernetes.
Hakanan, editan ya kamata ya taimaka musu wajen rubuta tambayoyin. Don wannan, mawallafin yana da Intellisense, kammala lambar tushe ta atomatik na Microsoft.
A wani gefen kuma an haɗa fasalin ɗan ƙaramin abu daga Kayayyakin aikin hurumin kallo a cikin edita. A can zaku iya adana tambayoyin SQL da ake amfani dasu akai-akai kuma sake amfani dasu idan ya cancanta.
Azure DataStudio shine da farko akan masu binciken bayanai. Sabili da haka, Microsoft kuma ya haɓaka ƙaddamarwar PostgreSQL don Kayayyakin aikin hurumin kallo don waɗanda ke amfani da bayanan bayanan Postgres azaman masu haɓaka aikace-aikace.
Hakanan, a halin yanzu yana cikin sigar samfoti. Sabili da haka, duka haɓakar edita na iya ƙunsar ɗaya ko ɗaya kuskuren.
Idan babban abin da kuka yi amfani da shi shi ne gudanar da bayanai, Azure Data Studio na iya zama kyakkyawan zaɓi.
To wannan ba ka damar gudanar da haɗin yanar gizo da yawa, bincika matsayin abubuwa na bayanai, daidaita dashboards, da ƙari.
A gefe guda, idan kun kasance kusa da ci gaban aikace-aikace fiye da gudanarwar bayanai, Microsoft yana ba da ƙarin PostgreSQL a cikin VS Code.
Yadda ake girka Studio Studio na Azure akan Ubuntu da abubuwan banbanci?
Ga waɗanda suke da sha'awar shigar da wannan editan akan tsarin su, Kuna iya yin hakan ta bin umarnin da muka raba muku a ƙasa.
Abu na farko da zamuyi shine zazzage sabon kunshin kwanciyar hankali daga edita daga mahada mai zuwa.
Yanzu bari zazzage tsawo don tallafin PostgreSQL daga mahaɗin da ke ƙasa.
An riga an yi zazzagewa Dole ne mu girka edita tare da manajan kunshin da muka fi so ko daga tashar ta hanyar buga wannan umarnin a ciki:
sudo dpkg -i azuredatastudio*.deb
Kuma idan akwai matsaloli tare da dogaro, za mu warware su ta buga waɗannan masu zuwa:
sudo apt -f install
Girkawar PostgreSQL
Yanzu don ƙara haɓakar tallafi don PostgreSQL. Da farko za mu bude Azure Data Studio da ciki dole ne mu zabi gunkin kari daga labarun gefe a cikin Azure Data Studio.
A cikin sandar bincike, rubuta 'postgresql'. Zaɓi tsawo na PostgreSQL.
Zaɓi shigar. Da zarar an shigar, zaɓi sake kunnawa don kunna haɓaka a Azure Data Studio.