Esihlokweni esilandelayo sizobheka i-Beekeeper Studio. Lokhu Umhleli we-SQL wamahhala nomthombo ovulekile nomphathi wedatha we-Gnu / Linux, MacOS neWindows. Ngaleli thuluzi, singaxhuma kalula, sithintane futhi siphathe imininingwane yethu. Ikhishwa ngaphansi kwelayisense ye-MIT.
Uhlelo okwamanje iyahambisana nemininingwane; I-SQLite, MySQL, UMariaDB, amaPostgres, iSQL Server, IphelaDB kanye ne-Amazon Redshift. Ibuye ibe nesikhombimsebenzisi esibonakalayo semisebenzi eminingi, esilula futhi esisebenziseka kalula. Ngayo singagcina imibuzo yethu ye-SQL. Ezinye izici ezitholakalayo yikhono lokuqedela ngokuzenzakalela imibuzo noma ukugqamisa kwe-syntax.
Izici Ezijwayelekile ze-Studio Yezinyosi
- Umhleli owakhelwe ngaphakathi unikeza abasebenzisi ukugqamisa kwe-syntax neziphakamiso zokuqedela ngokuzenzakalela ngokubonisana, futhi ngaleyo ndlela ukwazi ukusebenza ngokushesha futhi kalula.
- Ine- isikhombimsebenzisi esibonakalayo, ngakho-ke singakwazi ukwenza imisebenzi eminingi nabo.
- Singakwazi hlunga futhi uhlunge idatha yetafula, ukuthola lokho esikudingayo ngaso sonke isikhathi.
- Uhlelo libuye lunikeze ezinye izinqamuleli zekhibhodi.
- Sizokwazi londoloza kalula futhi uhlele imibuzo esetshenziswa kakhulu, ukuze sizisebenzise kaninginingi kukho konke ukuxhumana kwethu.
- Sizoba ne- umlando wokwenza umbuzo, lapho singathola khona lowo mbuzo ebesisebenza kuwo izinsuku.
- Sizoba nayo itimu emnyama ezenzakalelayo.
- Kanye nokuxhumana okujwayelekile, singabhala ngemfihlo ukuxhumana nge-SSL noma senze umhubhe ngeSSH. Lapho ugcina iphasiwedi yokuxhuma, lolu hlelo luzokwenza isiqiniseko sokuyibethela ukuze lugcinwe luphephile.
Faka i-Beekeeper Studio ku-Ubuntu
Ukufaka i-Beekeeper Studio ku-Ubuntu inqubo eqondile. Singayifaka ngefayela lendabuko le-DEB, i-AppImage nangephakheji ye-snap. Zonke zingatholakala kufayela le- ikhasi lokukhishwa kwephrojekthi.
Kusetshenziswa iphakheji .deb
Ukuze usebenzise iphakethe le-.deb, kuzofanele sililande futhi siligcine kwikhompyutha yethu. Leli fayela singakwazi ilande noma ngabe usebenzisa isiphequluli sewebhu bese uya ekhasini lokukhishwa kwephrojekthi noma ngokuvula i-terminal (Ctrl + Alt + T) bese usebenzisa umyalo:
wget https://github.com/beekeeper-studio/beekeeper-studio/releases/download/v1.4.0/beekeeper-studio_1.4.0_amd64.deb
Kulokhu, igama lefayela lithi 'umfuyi wezinyosi-studio_1.4.0_amd64.deb'. Lokhu kuzoshintsha ngokuya ngohlobo lohlelo. Ngakho-ke lo myalo kanye nalokhu okulandelayo kuzoshintsha ngokuya ngegama lefayela.
Lapho iphakethe selilandiwe, kusuka ku-terminal efanayo sizoba nayo kuphela sebenzisa umyalo olandelayo ukuqala ukufakwa:
sudo dpkg -i beekeeper-studio_1.4.0_amd64.deb
Lapho ukufakwa sekuqedile, singasesha isiqalisi kukhompyutha yethu ukuqala uhlelo:
Khipha
para susa uhlelo olufakiwe nephakheji ye-.deb, esigungwini (Ctrl + Alt + T) ngeke kusaba khona ukwenza:
sudo apt remove beekeeper-studio
Usebenzisa i-AppImage
Njengasesimweni esidlule, okokuqala kuzofanele sikwenze landa inguqulo yakamuva ye-Studio Yezinyosi ngefomethi ye -AppImage kusuka ekhasini lokwethulwa wephrojekthi. Sizophinda sibe nethuba lokuvula i-terminal (Ctrl + Alt + T) bese sisebenzisa umyalo olandelayo ukulanda ifayela:
wget https://github.com/beekeeper-studio/beekeeper-studio/releases/download/v1.4.0/Beekeeper-Studio-1.4.0.AppImage
Lapho ukulanda sekuqedile, sesinakho shintsha izimvume zefayela ukuze usebenze. Sizokwenza lokhu ngomyalo:
sudo chmod +x Beekeeper-Studio-1.4.0.AppImage
Manje singakwazi qalisa uhlelo kusebenze esigungwini esifanayo umyalo:
./Beekeeper-Studio-1.4.0.AppImage
Njengasendabeni yephakheji ye-.DEB, igama 'Umlimi Wenyosi-Studio-1.4.0.AppImage'ingashintsha ngokuya ngegama lefayela elilandiwe.
Usebenzisa iphakethe le-snap
Lolu hlelo futhi ifake usebenzisa i- snap pack. Ukwenza lokhu, sizovula i-terminal (Ctlr + Alt + T) bese sisebenzisa umyalo:
sudo snap install beekeeper-studio
Khipha
para susa uhlelo olufakiwe njengephakethe le-snap eqenjini lethu, kufanele uvule ukuphela (Ctrl + Alt + T) bese wenza umyalo:
sudo snap remove beekeeper-studio
Nganoma iyiphi yalezi zindlela singafaka i-Beekeeper Studio ku-Ubuntu. Lo mhleli ovulekile womthombo we-SQL nomphathi wedatha, ngu ibhentshi lokusebenzela elikhangayo, elinamandla, kodwa futhi elisebenziseka kalula. Imininingwane engaphezulu mayelana nephrojekthi ingatholakala ku- ikhasi lewebhuku imibhalo esemthethweni noma ku Ikhasi le-GitHub.
Ngabe kufanele uthumele ngaphandle izichazamazwi nemidwebo evela ku-BDD?