DBeaver: kyakkyawan kayan aiki don sarrafa DBs daban-daban

DBeaver shine software wanda ke aiki azaman kayan haɗin kayan duniya An yi niyya don masu haɓaka bayanai da masu gudanarwa.

DBeaver yana da tsari mai amfani wanda aka tsara shi sosai, dandamali bisa tsarin tushe na budewa kuma yana ba da damar rubuta abubuwa da yawa, gami da dacewa da kowane rumbun adana bayanai.

Har ila yau ya haɗa da tallafi ga abokan cinikin MySQL da Oracle abokan ciniki, gudanar da direba, editan SQL, da tsarawa. DBeaver aikace-aikacen giciye ne kamar yadda yake da tallafi ga dandamali na MacOS, Windows da Linux.

Game da DBeaver

Amfani shine babban makasudin wannan aikin, don haka keɓaɓɓen shirin an tsara shi sosai kuma an aiwatar dashi.

DBeaver yana goyan bayan duk shahararrun rumbunan adana bayanai kamar su: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, da sauransu.

Yana tallafawa kowane ɗakunan ajiya tare da direban JDBC. Kodayake a zahiri, zaku iya yin amfani da duk wani tushen bayanan waje wanda watakila ko bashi da direban JDBC.

Bugu da ƙari, yana dogara ne akan tushen tushen buɗewa kuma yana ba da izinin rubuce-rubuce na ƙarin kari (kari).

Akwai saitin abubuwan toshe-wasu bayanai na musamman (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis a sigar 3.x) da kuma masu amfani da kayan gudanar bayanai daban-daban ( misali misali ERD).

Wasu daga fa'idodi da kayan aikin wannan app da aka jera anan sun haɗa da:

• Bayanin SQL / rubutun kisa
• Comarshen bayanan haɗin kai da metadata a cikin editan SQL.
• Saitin sakamakon sakamako
• Fitar da bayanai (tebur, sakamakon bincike)
• Bincika abubuwan bayanan bayanai (tebur, ginshiƙai, ƙuntatawa, hanyoyin)
• DBeaver yana cinye ƙwaƙwalwar ajiya sosai fiye da sauran shahararrun shirye-shirye (SQuirreL, DBVisualizer)
• Duk ayyukan ayyukan bayanan nesa suna aiki a cikin yanayin da aka buɗe, don haka DBeaver ba ya faɗuwa idan uwar garken bayanan ba ya amsawa ko kuma idan akwai matsalar hanyar sadarwa

Yadda ake girka DBeaver Community akan Linux?

para Mutanen da suke da sha'awar girka wannan aikace-aikacen a kan tsarin su ya kamata su bi umarnin da muka raba a ƙasa.

Daya daga cikin hanyars wanda dole ne mu iya girka DBeaver Community a cikin Linux zuwa dashi ta hanyar Flatpak don haka ya zama dole su sami tallafi ga wannan fasahar da aka girka akan tsarin su.

Idan baku da wannan fasahar da aka ƙara a cikin tsarinku, Kuna iya tuntuɓar labarin mai zuwa.

Yanzu don girkawa ta wannan hanyar, dole ne mu buɗe tashar kuma a ciki aiwatar da umarnin mai zuwa:

flatpak install --user https://flathub.org/repo/appstream/io.dbeaver.DBeaverCommunity.flatpakref

Kuma idan sun riga sun shigar da wannan aikace-aikacen daga wannan hanyar, za su iya shigar da sigar ta yanzu tare da umarnin mai zuwa:

flatpak --user update io.dbeaver.DBeaverCommunity

Tare da wannan, za su iya fara amfani da wannan aikace-aikacen a kan tsarin su. Kawai bincika mai ƙaddamar a cikin tsarin aikinku.

Idan baku iya samun sa ba, kuna iya gudanar da aikace-aikacen tare da umarnin mai zuwa:

flatpak run io.dbeaver.DBeaverCommunit

Yadda ake girka DBeaver Community akan Debian, Ubuntu da abubuwan banbanci?

Idan masu amfani ne da Debian, Deepin OS, Ubuntu, Linux Mint a tsakanin sauran rarrabawa tare da tallafi don fakitin bashi, za su iya zazzage fakitin bashin aikace-aikacen.

An rarraba DBeaver Community don gine-gine 64-bit da 32-bit, don haka dole ne ku zazzage kunshin da ya dace don tsarin tsarin ku.

Ga waɗanda suke amfani da tsarin 64-bit, kunshin da zazzagewa shine mai zuwa:

wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb

Yayinda ga waɗanda suke amfani da tsarin 32-bit, kunshin tsarin gine-ginensu shine:

wget https://dbeaver.io/files/dbeaver-ce_latest_i386.deb

Bayan sauke kunshin, zamu iya girka shi tare da umarnin mai zuwa:

sudo dpkg -i dbeaver-ce*.deb

Kuma abubuwan dogaro da zamu warware tare da:

sudo apt -f install

Yadda ake girka DBeaver Community ta kunshin RPM?

Wannan hanyar tayi kama da wacce ta gabata, kawai ana amfani da ita ne wajen rarrabawa tare da tallafi ga fakitin RPM, kamar Fedora, CentOS, RHEL, OpenSUSE da sauransu.

A wannan yanayin, fakitin da dole ne mu sauke su ne masu zuwa, rago 64:

wget https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm

Ko don tsarin 32-bit:

wget https://dbeaver.io/files/dbeaver-ce-latest-stable.i386.rpm

A ƙarshe mun shigar tare da:

sudo rpm -i  dbeaver-ce-latest*.rpm