Beekeeper Studio, ikani SQL editor ndi woyang'anira nkhokwe

Munkhani yotsatira tiwona malo owetera njuchi. Izi ndizo mkonzi waulere, wotseguka wa SQL mkonzi ndi woyang'anira nkhokwe ya Gnu / Linux, MacOS ndi Windows. Ndi chida ichi, titha kulumikiza, kufunsa ndikuwongolera nkhokwe zathu. Imatulutsidwa pansi pa chiphaso cha MIT.

Pulogalamuyi pano imagwirizana ndi nkhokwe; SQLite, MySQL, MariaDB, PostgreSQL, SQL Server, ChiphuphuDB ndi Amazon Redshift. Ilinso ndi mawonekedwe omwe amagwiritsidwa ntchito mozungulira, omwe ndiosavuta kugwiritsa ntchito. Kudzera momwemo titha kusunga mafunso athu a SQL. Zina mwazomwe zilipo ndizokhoza kumaliza mafunso anu kapena kuwunikira kwama syntax.

Zida Zonse Za Studio ya mlimi

• Mkonzi womangidwayo amapereka ogwiritsa ntchito kuwonetsa ma syntax ndi malingaliro omaliza zokambirana, motero zitha kugwira ntchito mwachangu komanso mosavuta.
• Ili ndi a mawonekedwe owonekera, kotero titha kuchita nawo zambiri.
• Titha Sanjani ndi kusefa data patebulo, kuti tipeze zomwe timafunikira nthawi zonse.
• Pulogalamuyi imaperekanso zina njira zazifupi.
• Tidzatha sungani mosavuta ndikukonzekera mafunso omwe amagwiritsidwa ntchito kwambiri, kuti tithe kuzigwiritsa ntchito mobwerezabwereza m'malumikizidwe athu onse.
• Tikhala ndi mbiri yakufunsidwa, momwe tingapezere funso lomwe takhala tikugwira ntchito kwamasiku angapo.
• Tidzakhala nazo mutu wakuda wosasintha.

• Pamodzi ndi kulumikizana kwanthawi zonse, titha kubisa kulumikizana ndi SSL kapena kupanga tunnel kudzera pa SSH. Mukasunga chinsinsi cholumikizira, pulogalamuyi idzaonetsetsa kuti siyiyimitsa kuti isungike bwino.

Ikani Studio ya mlimi pa Ubuntu

Kuyika Studio ya mlimi pa Ubuntu ndichinthu chosavuta. Titha kuyiyika kudzera pa fayilo yapakompyuta ya DEB, AppImage komanso kudzera phukusi lachidule. Titha kuzipeza zonse mu tsamba lotulutsa ntchito.

Pogwiritsa ntchito phukusi la .deb

Kuti tigwiritse ntchito phukusi la .deb, tidzangofunika kutsitsa ndikusunga pakompyuta yathu. Fayiloyi tingathe tsitsani mwina pogwiritsa ntchito msakatuli ndikupita patsamba lomasulidwa polojekitiyo kapena potsegula terminal (Ctrl + Alt + T) ndikuchita lamulo:

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

Poterepa, dzina la fayilo ndi 'mlimi-studio_1.4.0_amd64.deb'. Izi zisintha kutengera mtundu wa pulogalamuyi. Chifukwa chake lamuloli ndi otsatirawa asintha malinga ndi dzina la fayilo.

Phukusili likangotsitsidwa, kuchokera kudera lomwelo tidzangokhala lembani lamulo lotsatirali kuti muyambe kukhazikitsa:

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

Mukangomaliza kukonza, titha kufunafuna choyambitsa pamakompyuta athu kuti tiyambe pulogalamuyi:

Sulani

Para chotsani pulogalamu yoyikidwayo ndi phukusi la .deb, mu terminal (Ctrl + Alt + T) sipadzakhalanso zoyikika:

sudo apt remove beekeeper-studio

Pogwiritsa ntchito AppImage

Monga momwe zinalili m'mbuyomu, choyamba tidzayenera tsitsani Studio Studio yatsopano mu mtundu wa .AppImage kuchokera patsamba lotsegulira za ntchitoyi. Tidzakhalanso ndi mwayi wotsegula terminal (Ctrl + Alt + T) ndikupanga lamulo lotsatila kuti mutsitse fayilo:

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

Mukamaliza kutsitsa, tili nawo sinthani zilolezo za fayilo kuti ichitike. Tichita izi ndi lamulo:

sudo chmod +x Beekeeper-Studio-1.4.0.AppImage

Tsopano ife tikhoza yambitsani pulogalamuyi kugwiritsa ntchito pamalo omwewo lamulo:

./Beekeeper-Studio-1.4.0.AppImage

Monga momwe zinalili ndi phukusi la .DEB, dzina 'Mlimi-Studio-1.4.0.AppImage'Zingasinthe kutengera dzina la fayilo yomwe mwatsitsa.

Pogwiritsa ntchito phukusi lachidule

Pulogalamuyi itha kukhazikitsa pogwiritsa ntchito chithunzithunzi paketi. Kuti tichite izi, tikuti titsegule terminal (Ctlr + Alt + T) ndikukhazikitsa lamulo:

sudo snap install beekeeper-studio

Sulani

Para chotsani pulogalamu yoyikiratu ngati phukusi lachidule Kuchokera ku gulu lathu, muyenera kutsegula terminal (Ctrl + Alt + T) ndikuchita lamuloli:

sudo snap remove beekeeper-studio

Mwa njira zonsezi titha kukhazikitsa Beekeeper Studio ku Ubuntu. SQL yotsegulira iyi komanso woyang'anira nkhokwe, ndi yokongola, yamphamvu, komanso yosavuta kugwiritsa ntchito SQL workbench. Zambiri zokhudzana ndi ntchitoyi zitha kupezeka mu tsamba la webu, mu zolemba kapena mu Tsamba la GitHub.