Yadda Ake Shigar DBeaver Universal Database Tool a Linux


DBeaver babban tushe ne, mai cikakken fasali, da kayan aikin sarrafa bayanai na duniya da abokin ciniki SQL wanda ke gudana akan tsarin aiki na Linux, Windows, da macOS. Yana goyan bayan tsarin sarrafa bayanai fiye da 80 ciki har da PostgreSQL, MySQL, Oracle, SQL Server, SQLite, DB2, MS Access, da ƙari mai yawa.

DBeaver yana da maɓalli masu zuwa:

  • Yana goyan bayan kowane tsarin sarrafa bayanai da ke da direban JDBC, amma kuma yana iya sarrafa sauran hanyoyin bayanan waje tare da ko ba tare da direban JDBC ba.
  • Yana da ingantaccen tsari da aiwatar da tsarin mai amfani (UI) don amfani.
  • Yana ba da editan SQL mai ƙarfi tare da cikawa kai tsaye na keywords, schema names, table names, and column names.
  • Yana jigilar abubuwa tare da plugins da yawa don tsarin bayanai daban-daban da abubuwan gudanarwa don tsarar ERD, shigo da bayanai da fitarwa (a tsarin da ya dace), canja wurin bayanai, samar da bayanan izgili, da ƙari mai yawa.
  • Yana goyan bayan haɓakawa don haɗawa tare da Excel, Git, da sauran kayan aikin da yawa.
  • Hakanan yana tallafawa tushen bayanan gajimare.
  • Bugu da ƙari, yana goyan bayan sa ido kan zaman haɗin yanar gizo da sauran ci-gaban fasalolin sarrafa bayanai.

DBeaver yana samuwa a cikin nau'i biyu: DBeaver Community Edition wanda ke da kyauta don amfani da DBeaver Enterprise Edition wanda shine nau'i na biya (kuna buƙatar lasisi don amfani da shi); duk da haka ana samun sigar gwaji.

A cikin wannan labarin, za mu nuna hanyoyi daban-daban don shigar da DBeaver Community Edition akan tsarin Linux. Kafin mu ci gaba, lura cewa DBeaver yana buƙatar Java 11 ko mafi girma don gudana, mahimmanci, farawa sigar 7.3.1 duk rarraba DBeaver sun haɗa da BuɗeJDK 11.

Shigar da DBeaver Community Edition ta hanyar Snap

Snaps hanya ce mai kyau kuma mai sauƙi don shigarwa da gudanar da aikace-aikace akan tsarin aiki na Linux saboda suna jigilar duk abubuwan da suka dogara da aikace-aikacen. Don gudanar da snaps, dole ne a shigar da tsarin Linux ɗin ku.

DBeaver yana da karye wanda zaku iya girka kamar haka. Umurnin da ke ƙasa suna nuna yadda ake shigar da snapd da DBeaver snap (dbeaver-ce). Idan kun riga kun shigar da snapd, kawai kwafi kuma gudanar da umarnin don shigar da dbever-ce:

--------- On Ubuntu/Debian/Mint --------- 
$ sudo apt update && sudo apt install snapd
$ sudo snap install dbeaver-ce

--------- On n RHEL-based Systems ---------
$ sudo dnf install snapd
$ sudo ln -s /var/lib/snapd/snap /snap
$ sudo snap install dbeaver-ce

--------- On Arch Linux ---------
$ git clone https://aur.archlinux.org/snapd.git
$ cd snapd
$ makepkg -si
$ sudo systemctl enable --now snapd.socket
$ sudo ln -s /var/lib/snapd/snap /snap
$ sudo snap install dbeaver-ce

Shigar da Ɗabi'ar Al'umma ta DBeaver ta Manajan Kunshin

Hakanan ana samun DBeaver azaman fakitin DEB ko RPM 64-bit. A kan Debian da abubuwan da suka samo asali kamar Ubuntu da sauran su, zaku iya shigar da haɓaka DBeaver daga ma'ajin Debian na hukuma ta hanyar aiwatar da umarni masu zuwa:

$ wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -
$ echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list
$ sudo apt-get update && sudo apt-get install dbeaver-ce

Bayan haka, akan Ubuntu da abubuwan da suka samo asali ciki har da Linux Mint, Kubuntu, zaku iya amfani da ma'ajin PPA don shigarwa da haɓaka DBeaver kamar haka:

$ sudo add-apt-repository ppa:serge-rider/dbeaver-ce
$ sudo apt-get update
$ sudo apt-get install dbeaver-ce

Don shigar da DBeaver ta hanyar mai saka kunshin DEB ko RPM 64-bit, zazzage shi, kuma shigar da shi ta amfani da mai sarrafa fakitin da ya dace kamar haka.

--------- On Ubuntu/Debian/Mint --------- 
$ wget -c https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb 
$ sudo dpkg -i dbeaver-ce_latest_amd64.deb 

--------- On RHEL-based Systems --------- 
$ wget -c https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm
$ sudo rpm -ivh dbeaver-ce-latest-stable.x86_64.rpm 

Da zarar kun sami nasarar shigar DBeaver, bincika kuma buɗe shi daga menu na tsarin.

Yadda ake Amfani da DBeaver a cikin Linux

Don ƙirƙirar sabon haɗin bayanai danna maballin da aka haskaka a cikin hoton hoto mai zuwa ko danna Databases, sannan zaɓi Sabuwar Haɗin Database.

Nemo direban bayanan ku daga lissafin bayanan bayanai kamar yadda aka nuna a hoton da ke biyowa. Sannan danna Next. A wannan gaba, DBeaver zai yi ƙoƙarin saukewa da shigar da direban da aka zaɓa, yana tabbatar da cewa an haɗa kwamfutarka da Intanet.

Na gaba, shigar da saitunan haɗin bayanai (Mai watsa shiri na bayanai, Sunan Database ƙarƙashin saitunan uwar garken, Sunan mai amfani, da kalmar wucewar mai amfani a ƙarƙashin saitunan Tabbatarwa). Sa'an nan danna Test Connection.

Idan saitunan haɗin bayanai daidai ne, yakamata ku ga cikakkun bayanan uwar garken bayanai kamar haka. Danna Ok don ci gaba.

Yanzu kammala saitin haɗin bayanai ta hanyar danna Gama kamar yadda aka nuna a hoton da ke biyowa.

Sabuwar haɗin bayananku yakamata ya bayyana a ƙarƙashin Navigator na Database kamar yadda aka nuna a ƙasa. Don buɗe editan SQL, danna-dama akan sunan database, sannan zaɓi editan SQL, sannan Buɗe rubutun SQL.

Ƙarshe amma ba kalla ba, idan kuna son yanayin duhu ko jigo, za ku iya canzawa zuwa gare shi. Kawai danna kan Windows -> Preferences, sannan danna Bayyanar. Sannan a karkashin theme saitin, zaɓi Dark, sannan danna Aiwatar da Rufe.

Wannan shine abin da muka samu a gare ku a cikin wannan jagorar. Don neman ƙarin bayani game da DBeaver gami da takaddun, duba gidan yanar gizon DBeaver na hukuma. Kuna iya sauke kowane sharhi game da wannan jagorar a cikin sashin sharhin da ke ƙasa.