DBeaver, yana sarrafa nau'ikan bayanai daban-daban ta hanya mai sauƙi

A cikin labarin na gaba zamu kalli DBeaver. Wannan abokin ciniki na SQL da kayan aikin gudanar da bayanai. Aikace-aikacen tebur ne da aka rubuta a cikin Java kuma ya dogara da dandamalin Eclipse. Idan abin da muke so shine muyi aiki tare da bayanan bayanan dangi, zuwa amfani yana amfani da JDBC API don hulɗa tare da bayanan bayanai ta hanyar direban JDBC. Ga sauran wadanda ba SQL bayanai amfani da mallakar tajirai database direbobi.

Wannan abokin harka zai samar mana da editan da ke goyan bayan kammala lambar da kuma nuni kan yadda ake aiki da rubutu. Hakanan zamu sami tsarin toshe-gini wanda ya danganci gine-ginen Eclipse, wanda zai ba masu amfani damar gyara babban ɓangare na halayen aikace-aikacen don cimma takamaiman ayyuka ko halaye na bayanan.

An tsara wannan software don masu haɓakawa kuma tana tallafawa ba Microsoft SQL kawai ba. Hakanan zai ba mu damar aiki tare da wasu da yawa bayanai masu dangantaka mashahuri kamar MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, da dai sauransu. A lokaci guda ya yarda da wasu NoSQL bayanai kamar yadda MongoDB, Cassandra, Redis, Apache Hive, da dai sauransu.

Yana da mahimmanci a faɗi hakan ma akwai sigar da aka biya, wannan zai bamu damar amfani da NoSQL ko kuma idan muna buƙatar wasu ƙarin abubuwa kamar haɗin Office ko taimako.

Editionab'in Al'umma (CE) na DBeaver kyauta ne kuma tushen buɗe software wanda aka rarraba a ƙarƙashin Lasisin Apache. Distributedab'in tushen kamfani na DBeaver an rarraba shi ƙarƙashin lasisin kasuwanci. A cikin layuka masu zuwa zamu ga kyautar (al'umma) ta wannan kayan aikin kyauta. Don ƙarin bayani game da wannan, zaku iya tuntuɓar shafin yanar gizon wannan aikin.

Siffofin DBeaver

Wannan abokin ciniki yana goyan bayan shahararrun ɗakunan bayanai kamar: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, MS Access, DB2, SQL Server, Sybase, Teradata, da sauransu. Yana tallafawa kowane ɗakunan ajiya tare da direban JDBC.
Ko da yake iya sarrafa duk wani tushen bayanan waje wanda ƙila ko ba zai iya amfani da direba na JDBC ba.
Akwai saiti ga wasu bayanai (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis) da kuma kayan sarrafa bayanai daban-daban.
Zamu iya samun zane-zane na gani na abubuwan bayanai mutum da cikakken makirci.
Zai yardar mana gyara ko duba tebur. Hakanan zamu iya fitarwa zuwa fasali da yawa, kamar CSV, HTML, XML, XLS, XLSX.
Za mu samu ra'ayoyin bayanai masu yawa don daidaitawa da nau'ikan bukatun mai amfani, kamar nunin abun cikin hoto (gif, png, jpeg, bidiyo).
Gyara bayanan kan layi kuma a cikin keɓaɓɓun sarari
Zai yardar mana shiga tambayoyin SQL wanda za'a aiwatar dashi a cikin zaman DB kai tsaye bayan haɗin ya tabbata.
Za mu sami wani manajan haɗi wanda zai ba mu damar daidaita haɗin zuwa ɗakunan bayanai daban-daban sannan kuma muyi amfani da wasu kaddarorin da suka ci gaba kamar su ramin SSH, wakili na SOCKS ko aiwatar da umarnin harsashi kafin ko bayan haɗin bayanan bayanan.

Shigar da DBeaver akan Ubuntu

Ta hanyar .deb kunshin

Debian, Deepin OS, Ubuntu da Linux Mint masu amfani tare da sauran rarraba tare da tallafi don fakitin bashi, za mu iya zazzage kayan aikin .deb na aikace-aikacen. Don yin haka, masu amfani da 64-bit kawai zasu buɗe tashar (Ctrl + Alt T) kuma suyi amfani da wannan umarnin:

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

Da zarar an gama saukar da kunshin, zamu iya girka shi tare da umarni mai zuwa daga babban fayil ɗin da muka ajiye kunshin .deb:

sudo dpkg -i dbeaver-ce*.deb

Amfani da Flatpak

Idan kuna sha'awar shigar da wannan kayan aikin, wata hanyar kuma dole ne mu iya shigar DBeaver Community a Ubuntu, ta hanyar kwatankwacin Flatpak ɗin ta ne. Don ci gaba da wannan shigarwar, kawai zamuyi amfani da kunshin flatpak da zamu iya zazzage daga shafin flathub ko budewa Zaɓin software na Ubuntu da girka shi kai tsaye daga can.