Isitudiyo somgcini nyosi, faka lo mhleli weSQL kunye nomphathi wedatha

Kwinqaku elilandelayo siza kujonga kwi Studio Studio. Yi le Umhleli wasimahla kunye novulekileyo womhleli weSQL kunye nomphathi wedatha yeGnu / Linux, MacOS kunye neWindows. Ngesi sixhobo, sinokuqhagamshela ngokulula, sidibane kwaye silawule iziseko sedatha. Ikhutshwa phantsi kwelayisensi ye-MIT.

Inkqubo okwangoku iyahambelana noovimba beenkcukacha; I-SQLite, MySQL, UMariaDB, iiPostgres, iSQL Server, IphenyaneDB kunye neAmazon Redshift. Ikwanayo ujongano lomsebenzisi olunemisebenzi emininzi, olulula kwaye kulula ukuyisebenzisa. Ngayo sinokugcina imibuzo yethu ye-SQL. Ezinye izinto ezikhoyo kukukwazi ukugqibezela imibuzo okanye ukuqaqanjiswa kwes syntax.

Iimpawu eziBanzi ze Studio Studio

• Umhleli owakhelweyo unika abasebenzisi Ukuqaqanjiswa kwe-syntax kunye neengcebiso ezigqityiweyo Ukudibana, kwaye ke ukwazi ukusebenza ngokukhawuleza nangokulula.
• Ine- ujongano lwethebhu, sinokwenza izinto ezininzi kunye nabo.
• Sinako ukuhlela kunye nokuhluza idatha yetafile, ukufumana kanye le nto siyifunayo ngamaxesha onke.
• Le nkqubo ikwabonelela ngezinye iindlela ezimfutshane zokucofa.
• Siza kukwazi gcina ngokulula kwaye uququzelele imibuzo esetyenziswa rhoqo, ukuze sikwazi ukuzisebenzisa kaninzi kunxibelelwano lwethu lonke.
• Siza kuba nefayile ye- Imbali yokuphunyezwa kombuzo, apho sinokufumana khona lo mbuzo kudala sisebenza kuwo.
• Siya kuba nayo umxholo omnyama ongagqibekanga.

• Kunye nonxibelelwano oluqhelekileyo, Singabhala ngokudibanisa ne-SSL okanye senze itonela ngeSSH. Xa ugcina ipassword yoqhagamshelo, inkqubo iya kuqinisekisa ukuyifihla ukuyigcina ikhuselekile.

Faka i-Studio ye-Beekeeper kwi-Ubuntu

Ukufaka i-Beekeeper Studio kwi-Ubuntu yinkqubo ethe ngqo. Singayifaka kwifayile yemveli yephakheji ye-DEB, AppImage nangephakheji yesnap. Zonke ziyafumaneka kwifayile ye- iphepha lokukhupha iprojekthi.

Sebenzisa iphakheji .deb

Ukusebenzisa iphakheji ye-.deb, kuya kufuneka siyikhuphele kwaye siyigcine kwikhompyuter yethu. Le fayile sinako khuphela nokuba usebenzisa isikhangeli sewebhu kwaye uye kwiphepha lokukhululwa kweprojekthi okanye ngokuvula i-terminal (Ctrl + Alt + T) kunye nokwenza umyalelo:

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

Kule meko, igama lefayile ngu 'umgcini nyosi-studio_1.4.0_amd64.deb'. Oku kuyakutshintsha kuxhomekeke kuhlobo lwenkqubo. Ke lo myalelo kunye noku kulandelayo kuya kutshintsha ngokwegama lefayile.

Nje ukuba iphakheji ikhutshelwe, kwisiphelo esinye siya kuba nayo kuphela sebenzisa lo myalelo ulandelayo ukuqala ufakelo:

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

Nje ukuba ukufakwa kugqityiwe, sinokukhangela isiqalisi kwikhompyuter yethu ukuqala inkqubo:

Khupha ngaphandle

ukuba susa inkqubo efakiweyo kunye .deb packageKwisiphelo sendlela (Ctrl + Alt + T) akusayi kuphinda kwenziwe:

sudo apt remove beekeeper-studio

Sebenzisa AppImage

Njengakwimeko engaphambili, kuya kufuneka kuqala Khuphela uguqulelo lwamva nje lwe Studio Studio ukusuka kwiphepha lokuqalisa yeprojekthi. Siya kuba nethuba lokuvula i-terminal (Ctrl + Alt + T) kwaye senze lo myalelo ulandelayo wokukhuphela ifayile:

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

Nje ukuba ukhuphelo lugqityiwe, sinalo tshintsha iimvume zefayile ukuze usebenze. Siza kwenza oku ngomyalelo:

sudo chmod +x Beekeeper-Studio-1.4.0.AppImage

Ngoku sinako yazisa inkqubo ukwenza kwisiphelo esinye kumyalelo:

./Beekeeper-Studio-1.4.0.AppImage

Njengakwimeko yephakheji ye-DEB, igama 'Umgcini nyosi-Studio-1.4.0'inokutshintsha ngokusekwe kwigama lefayile ekhutshelweyo.

Sebenzisa iphakheji ye-snap

Le nkqubo nayo yifake usebenzisa snap pack. Ukwenza oku, siza kuvula i-terminal (Ctlr + Alt + T) kwaye senze lo myalelo:

sudo snap install beekeeper-studio

Khupha ngaphandle

ukuba susa inkqubo efakiweyo njengepakethe ye-snap kwiqela lethu, kuya kufuneka uvule i-terminal (Ctrl + Alt + T) kwaye wenze lo myalelo:

sudo snap remove beekeeper-studio

Ngayiphi na kwezi ndlela singafaka i-Studio ye-Beekeeper kwi-Ubuntu. Lo mhleli uvulekileyo womhleli weSQL kunye nomphathi wedatha, ngu Inomtsalane, inamandla, kodwa kulula nokusebenzisa indawo yokusebenza ye-SQL. Olunye ulwazi malunga neprojekthi lunokufumaneka kwi iphepha lewebhukwi amaxwebhu asemthethweni okanye kwi Iphepha leGitHub.