Beekeeper Studio, shigar da wannan editan SQL da manajan bayanai

A talifi na gaba zamu kalli Studio Studio na Beekeeper. Wannan editan SQL kyauta da buda ido da mai sarrafa bayanai na Gnu / Linux, MacOS da Windows. Ta wannan kayan aikin, zamu iya haɗa kai, tuntuɓi da kuma sarrafa bayanan mu. An sake shi a ƙarƙashin lasisin MIT.

Shirin a halin yanzu ya dace da bayanai; - SQLite, MySQL, MariaDB, PostgreSQL, SQL Server, KyankyasoDB da Amazon Redshift. Hakanan yana da tabbataccen mai amfani mai amfani, wanda yake mai sauki ne kuma mai sauƙin amfani. Ta hanyar sa zamu iya adana tambayoyin mu na SQL. Wasu sauran fasalulluran da ake dasu sune ikon cika tambayoyin kai tsaye ko haskaka aikin haɗin gwanon gini.

Janar fasali na Studio Beekeeper

• Editan ginanniyar yana ba masu amfani nuni kan yadda ake gabatar da kalma a daidaitacce da kuma shawarwari kai tsaye don shawarwari, kuma ta haka ne za ku iya yin aiki da sauri da sauƙi.
• Yana da a Tabbed interface, saboda haka zamu iya aiwatar da ayyuka da yawa tare dasu.
• Zamu iya warware da tace bayanan tebur, don neman kawai abin da muke buƙata a kowane lokaci.
• Shirin kuma yana ba da wasu Gajerun hanyoyin keyboard.
• Za mu iya sauƙi adanawa da tsara tambayoyin da aka saba amfani dasu, don mu iya amfani da su sau da yawa a cikin duk hanyoyin haɗin mu.
• Za mu sami tambayar aiwatarwa, wanda zamu iya samun wannan tambayar da muka yi aiki a kanta tsawon kwanaki.
• Za mu samu tsoho taken duhu.

• Tare da haɗin haɗin yau da kullun, zamu iya ɓoye haɗin tare da SSL ko yin rami ta hanyar SSH. Lokacin adana kalmar shiga ta haɗi, shirin zai tabbatar da ɓoye shi don kiyaye shi lafiya.

Sanya Studio Studio a kan Ubuntu

Sanya Studio Studio a Ubuntu hanya ce madaidaiciya. Zamu iya girka ta ta hanyar fayil ɗin kunshin DEB na asali, AppImage kuma ta hanyar ɗaukar hoto. Duk ana iya samun su a cikin shafin sakin aiki.

Yin amfani da .deb kunshin

Don amfani da kunshin .deb, za mu sauke shi kawai mu ajiye a kwamfutarmu. Wannan fayil ɗin zamu iya zazzage shi ta amfani da burauzar yanar gizo da zuwa shafin sakin aikin ko buɗe tashar (Ctrl + Alt + T) da gudana umarnin:

wget https://github.com/beekeeper-studio/beekeeper-studio/releases/download/v1.4.0/beekeeper-studio_1.4.0_amd64.deb

A wannan yanayin, sunan fayil din 'kudan zuma-studio_1.4.0_amd64.deb'. Wannan zai canza dangane da sigar shirin. Don haka wannan umarnin da masu zuwa zasu canza bisa ga sunan fayil.

Da zarar an sauke kunshin, daga wannan tashar za mu sami kawai gudu wannan umarni don fara shigarwa:

sudo dpkg -i beekeeper-studio_1.4.0_amd64.deb

Da zarar an gama shigarwa, zamu iya neman mai ƙaddamarwa akan kwamfutarmu don fara shirin:

Uninstall

para cire shirin da aka sanya tare da .deb kunshin, a cikin m (Ctrl + Alt + T) ba za a ƙara yin aiwatarwa ba:

sudo apt remove beekeeper-studio

Amfani da AppImage

Kamar yadda yake a cikin shari'ar da ta gabata, da farko zamuyi zazzage sabon sigar Studio Studio a cikin tsarin .AppImage daga shafin gabatarwa na aikin. Hakanan zamu sami damar buɗe tashar (Ctrl + Alt + T) da aiwatar da umarni mai zuwa don sauke fayil ɗin:

wget https://github.com/beekeeper-studio/beekeeper-studio/releases/download/v1.4.0/Beekeeper-Studio-1.4.0.AppImage

Da zarar an gama saukarwa, muna da canza izinin fayil don sanya shi zartarwa. Za mu yi haka tare da umarnin:

sudo chmod +x Beekeeper-Studio-1.4.0.AppImage

Yanzu za mu iya kaddamar da shirin aiwatar da umarni a cikin wannan tashar:

./Beekeeper-Studio-1.4.0.AppImage

Kamar yadda yake a cikin batun .DEB kunshin, sunan 'Mai kula da kudan zuma-Studio-1.4.0.AppImage'na iya canzawa dangane da sunan fayil ɗin da aka zazzage.

Yin amfani da kunshin snap

Wannan shirin yana iya girka shi ta amfani da snap fakitin. Don yin wannan, zamu buɗe tashar (Ctlr + Alt + T) kuma aiwatar da umarnin:

sudo snap install beekeeper-studio

Uninstall

para cire shirin da aka sanya azaman kunshin kamawa daga ƙungiyarmu, kawai kuna buɗe tashar (Ctrl + Alt + T) kuma ku zartar da umarnin:

sudo snap remove beekeeper-studio

A kowane ɗayan waɗannan hanyoyin zamu iya shigar da Studio na Beekeeper a cikin Ubuntu. Wannan editan SQL bude da manajan bayanai, shine mai ban sha'awa, mai iko, amma kuma mai sauƙin amfani da aikin SQL. Ana iya samun ƙarin bayani game da aikin a cikin shafin yanar gizo, a cikin takaddun hukuma ko a cikin Shafin GitHub.