Otu esi etinye DBeaver Universal Database Tool na Linux

DBeaver bụ ihe mepere emepe, gosipụtara n'ụzọ zuru oke yana ngwaọrụ njikwa nchekwa data zuru ụwa ọnụ yana onye ahịa SQL na-arụ ọrụ na sistemụ arụmọrụ Linux, Windows na macOS. Ọ na-akwado usoro njikwa nchekwa data karịa 80 gụnyere PostgreSQL, MySQL, Oracle, SQL Server, SQLite, DB2, MS Access, na ọtụtụ ndị ọzọ.

DBeaver nwere atụmatụ isi ndị a:

Ọ na-akwado sistemu njikwa nchekwa data ọ bụla nwere ọkwọ ụgbọ ala JDBC, mana ọ nwekwara ike ijikwa ebe data mpụga ndị ọzọ yana ma ọ bụ na-enweghị onye ọkwọ ụgbọ ala JDBC.
O nwere interface njirimara arụpụtara nke ọma yana emejuputa atumatu (UI) maka ojiji.
Ọ na-enye editọ SQL dị ike na-emecha mkpụrụokwu, aha schema, aha tebụl na aha kọlụm.
Ọ na-ebugharị na ọtụtụ plugins maka sistemụ nchekwa data dị iche iche yana ihe njikwa maka ọgbọ ERD, mbubata na mbupụ data (n'ụdị dabara adaba), ịnyefe data, ọgbọ data mock, na ọtụtụ ndị ọzọ.
Ọ na-akwado ndọtị maka njikọta na Excel, Git, na ọtụtụ ngwaọrụ ndị ọzọ.
Ọ na-akwadokwa isi data data igwe ojii.
Ọzọkwa, ọ na-akwado nlekota oge njikọ nchekwa data yana ọtụtụ atụmatụ nlekọta nchekwa data ndị ọzọ dị elu.

DBeaver dị na ekpomeekpo abụọ: DBeaver Community Edition nke bụ n'efu maka ojiji yana DBeaver Enterprise Edition nke bụ ụdị akwụrụ ụgwọ (ịkwesịrị ikikere iji ya); Otú ọ dị a ikpe ụdị dị.

N'ime edemede a, anyị ga-egosi ụzọ dị iche iche iji wụnye DBeaver Community Edition na sistemụ Linux. Tupu anyị aga n'ihu, rịba ama na DBeaver chọrọ Java 11 ma ọ bụ karịa ka ọ na-agba ọsọ, dị mkpa, malite ụdị 7.3.1 niile nkesa DBeaver gụnyere OpenJDK 11 ngwugwu.

Ịwụnye DBeaver Community Edition site na Snap

Snaps bụ ụzọ dị mma ma dị mfe iji wụnye ma mee ngwa na sistemụ arụmọrụ Linux n'ihi na ha na-eji ndabere niile nke ngwa ebu ụgbọ mmiri. Iji mee snaps, sistemụ Linux gị ga-abụrịrị nke arụnyere snapd.

DBeaver nwere snap nke ị nwere ike iwunye dị ka ndị a. Iwu ndị dị n'okpuru na-egosi otu esi etinye snapd na DBeaver snap (dbeaver-ce). Ọ bụrụ na ị tinyelarị snapd, naanị detuo ma mee iwu ka ịwụnye dbeaver-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

Ịwụnye DBeaver Community Edition site na njikwa ngwugwu

DBeaver dịkwa ka ngwugwu 64-bit DEB ma ọ bụ RPM. Na Debian na usoro ya dị ka Ubuntu na ọtụtụ ndị ọzọ, ị nwere ike iwunye ma kwalite DBeaver site na ebe nchekwa Debian gọọmentị site na ịme iwu ndị a:

$ 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

E wezụga nke ahụ, na Ubuntu na usoro ya gụnyere Linux Mint, Kubuntu, ị nwere ike iji ebe nchekwa PPA iji wụnye ma kwalite DBeaver dị ka ndị a:

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

Iji tinye DBeaver site na nrụnye ngwugwu DEB ma ọ bụ RPM 64-bit, budata ya, wee wụnye ya site na iji njikwa ngwugwu kwesịrị ekwesị dị ka ndị a.

--------- 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

Ozugbo ị wụnye DBeaver nke ọma, chọọ ma mepee ya site na menu usoro.

Otu esi eji DBeaver na Linux

Iji mepụta njikọ nchekwa data ọhụrụ pịa bọtịnụ emepụtara na nseta ihuenyo na-esonụ ma ọ bụ pịa Databases, wee họrọ Njikọ Ọhụrụ Database.

Chọta onye ọkwọ ụgbọ ala nchekwa data gị site na ndepụta ọdụ data dị ka egosiri na nseta ihuenyo na-esonụ. Wee pịa Ọzọ. N'oge a, DBeaver ga-anwa ibudata na wụnye ọkwọ ụgbọala ahọpụtara, hụ na ejikọrọ kọmputa gị na ịntanetị.

Na-esote, tinye ntọala njikọ nchekwa data (ọbịa ọdụ data, Aha nchekwa data n'okpuru ntọala Server, Aha njirimara, na paswọọdụ onye ọrụ n'okpuru ntọala nyocha). Wee pịa Test Njikọ.

Ọ bụrụ na ntọala njikọ nchekwa data ziri ezi, ị ga-ahụ nkọwa nkesa nchekwa data dị ka ya. Pịa OK ka ịga n'ihu.

Ugbu a mezue ntọala njikọ nchekwa data site na ịpị Mechaa dị ka egosiri na nseta ihuenyo na-esonụ.

Njikọ nchekwa data ọhụrụ gị kwesịrị ịpụta ugbu a n'okpuru ihe nchọgharị data dị ka egosiri n'okpuru. Iji mepee editọ SQL, pịa aka nri na aha nchekwa data, wee họrọ SQL editọ, wee mepee edemede SQL.

N'ikpeazụ ma ọ dịghị ihe ọzọ, ọ bụrụ na ị hụrụ ọnọdụ gbara ọchịchịrị n'anya ma ọ bụ isiokwu, ị nwere ike ịgbanwe na ya. Naanị pịa Windows -> Mmasị, wee pịa Ọdịdị. Mgbe ahụ n'okpuru ntọala isiokwu, họrọ Ọchịchịrị, wee pịa Tinye na Mechie.

Nke ahụ bụ ihe anyị nwere maka gị na ntuziaka a. Iji chọta ozi ndị ọzọ gbasara DBeaver gụnyere akwụkwọ, lelee webụsaịtị DBeaver gọọmentị. Ị nwere ike ịhapụ okwu ọ bụla gbasara ntuziaka a na ngalaba nkọwa n'okpuru.