Esihlokweni esilandelayo sizobheka iDBeaver. Lokhu iklayenti le-SQL kanye nethuluzi lokuphatha i-database. Uhlelo lokusebenza lwedeskithophu olubhalwe ngeJava futhi lususelwa kungxenyekazi ye-Eclipse. Uma lokho esikufunayo kungukusebenza ngemininingwane yolwazi ephathelene nobudlelwano, ukusebenzisa i I-JDBC API ukuxhumana nemininingwane ngokusebenzisa umshayeli we-JDBC. Kweminye imininingwane yolwazi engeyona eye-SQL sebenzisa abashayeli be-database ephathelene.
Leli klayenti lizosinikeza ifayela le- editor esekela ukuqedwa kwamakhodi nokugqanyiswa kwe-syntax. Sizophinde sibe nokwakhiwa kwe-plug-in okususelwa ekwakhiweni kwe-plug-in ye-Eclipse, okuzovumela abasebenzisi ukuthi bashintshe ingxenye enkulu yokuziphatha kohlelo lokusebenza ukufeza imisebenzi ethile noma izici zedatha.
Le software yenzelwe onjiniyela futhi ayisekeli iMicrosoft SQL kuphela. Kuzosivumela futhi ukuthi sisebenzisane nezinye eziningi imininingwane yolwazi ethandwa njenge MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, njll. Ngasikhathi sinye iyavuma eminye Imininingwane ye-NoSQL njengoba I-MongoDB, Cassandra, Redis, Apache Hive, njll.
Kubalulekile ukusho lokho futhi kukhona inguqulo ekhokhelwayo, lokhu kuzosivumela ukuthi sisebenzise i-NoSQL noma uma sidinga ezinye izici ezifana nokuhlanganiswa kweHhovisi noma usizo.
I-Community Edition (CE) ye-DBeaver iyisoftware yamahhala futhi evulekile esatshalaliswa ngaphansi kwe-Apache License. Uhlobo lwebhizinisi lomthombo ovaliwe lwe-DBeaver lusatshalaliswa ngaphansi kwelayisense lokuhweba. Emigqeni elandelayo sizobona uhlelo lwamahhala (lomphakathi) lwaleli thuluzi. Ngeminye imininingwane ngalokhu, ungaxhumana ne- iwebhusayithi yale phrojekthi.
Izici ze-DBeaver
- Leli klayenti lisekela imininingwane ethandwa kakhulu njenge: I-MySQL, i-PostgreSQL, i-MariaDB, i-SQLite, i-Oracle, i-MS Access, i-DB2, i-SQL Server, iSybase, iTeradata, njll.. Isekela noma iyiphi i-database enomshayeli we-JDBC.
- Noma kunjalo ingalawula noma yimuphi umthombo wangaphandle wedatha ongasebenzisa noma ongasebenzisi umshayeli we-JDBC.
- Kukhona isethi ye-plug-in yolwazi oluthile (I-MySQL, i-Oracle, i-DB2, i-SQL Server, i-PostgreSQL, iVertica, i-Informix, i-MongoDB, iCassandra, iRedis) kanye nezinsiza ezahlukahlukene zokuphathwa kwedatha.
- Singathola imidwebo ebonakalayo yezinto ze-database izikimu ngazinye neziphelele.
- Izosivumela hlela noma ubuke amatafula. Singathumela futhi kumafomethi amaningi, njenge-CSV, HTML, XML, XLS, XLSX.
- Sizoba nayo ukubukwa kwedatha okuningi ukuzivumelanisa nezidingo ezahlukahlukene zomsebenzisi, njengokukhonjiswa kokuqukethwe kwesithombe (gif, png, jpeg, bmp).
- Ukuhlelwa kwedatha eku-inthanethi nasendaweni enikezelwe.
- Izosivumela Joyina imibuzo ye-SQL okuzokwenziwa kuseshini ye-DB ngemuva nje kokusungulwa kokuxhumeka.
- Sizothola i- umphathi wokuxhuma okuzosivumela ukuthi silungiselele ukuxhumana kwimininingwane ehlukene futhi sisebenzise ezinye izakhiwo ezithuthukile ezifana nomhubhe we-SSH, ummeleli we-SOCKS noma senze imiyalo yeShell ngaphambi noma ngemuva kokuxhumeka kwe-database.
Faka i-DBeaver ku-Ubuntu
Ngephakheji ye-.deb
Abasebenzisi be-Debian, i-Deepin OS, i-Ubuntu ne-Linux Mint phakathi kokunye ukwabiwa ngokusekelwa kwamaphakeji wedeb, sizokwazi landa iphakheji yohlelo lokusebenza .deb. Ukuze benze kanjalo, abasebenzisi abangama-64-bit kufanele bavule ukuphela (Ctrl + Alt + T) bese basebenzisa umyalo olandelayo:
wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb
Lapho ukulanda kwephakheji sekuqediwe, sizokwazi yifake ngomyalo olandelayo kusuka kufolda lapho sigcine khona iphakheji ye-.deb:
sudo dpkg -i dbeaver-ce*.deb
Usebenzisa i-Flatpak
Uma unentshisekelo yokufaka leli thuluzi, enye indlela okufanele sikwazi ukuyisebenzisa faka i-DBeaver Community ku-Ubuntu, kungokusebenzisa iphakethe layo elihambisanayo le-Flatpak. Ukuqhubeka nalokhu kufakwa, kuzodingeka sisebenzise kuphela iphakethe le-flatpak esingakwazi landa ekhasini le-flathub noma ukuvula ifayela le- Ubuntu inketho yesoftware bese uyifaka ngqo kusuka lapho.
Ngemuva kokuqeda ukufakwa, singaqala ukusebenzisa lolu hlelo lokusebenza ohlelweni lwethu lwe-Ubuntu. Kuzofanele sibheke imbiza kuphela eqenjini lethu.
I-DBeaver uhlelo oluwusizo abaphathi be-database nabasebenzi be-amateur. Lokhu kwenza ukusebenza kulwazi kunembile futhi kube lula.