I-TemBoard, i-interface yolawulo olukude lwe-PostgreSQL

Mva nje ukumiliselwa kwe Inguqulelo entsha yeprojekthi tempBoard 8.0, ephuhlisayo ujongano lwewebhu lolawulo olukude, Ukujongwa kweDBMS, uqwalaselo kunye nokwenza ngcono Iposi ye-PostgreSQL.

Imveliso ibandakanya i-arhente ekhaphukhaphu efakiweyo kwiseva nganye ye-PostgreSQL kunye necandelo leseva elilawula ngokuyintloko ii-arhente kwaye iqokelele izibalo zokubeka iliso.

TemBoard Ibonakaliswe ngokuvumela ukulawula amakhulu eemeko ze-PostgreSQL DBMS ngokusebenzisa ujongano lwewebhu oluphakathi, ukongeza kubukho bezikrini zolwazi ukuvavanya zombini imeko ngokubanzi yazo zonke i-DBMS, kunye novavanyo oluthe kratya lwemeko nganye.

Olunye uphawu lwetemBoard yi DBMS esweni ubume usebenzisa iimetrikhi ezininzi, ukongeza ekuvumeleni ukwenza i-sesweni imisebenzi yokucoca (VACUUM) yeetheyibhile kunye nezalathisi, ngokunjalo nokubekwa esweni kwemibuzo ecothayo kuvimba weenkcukacha.

Ezinye izinto ezibalaseleyo kwi-temBoard zezi:

• Inkxaso yokulawula iiseshoni ezisebenzayo ngoku kunye ne-DBMS.
• Ujongano lokuphucula ubumbeko bePostgreSQL.

Iimpawu eziphambili ezintsha zetemBoard 8.0

Kolu guqulelo lutsha lwe-temBoard oluvezwayo, kugxininiswe ukuba yahlengahlengisa ukuqinisekiswa kunye nokulungelelaniswa kwejelo lonxibelelwano phakathi kojongano lolawulo kunye neearhente. Utshintsho luthetha ukulula ukuthunyelwa kwee-agent kunye nokwanda kokhuseleko lomjelo wonxibelelwano kunye nabo.

Kukhankanyiwe ukuba zonke izicelo eziya kwiiarhente ngoku zisayinwe ngokwedijithali kusetyenziswa i-asymmetric public key encryption, kwaye ujongano lusebenza njengomboneleli wesazisi kwiiarhente.

Ukongeza, kukwakhankanywa ukuba ukuqinisekiswa kwegama eliyimfihlo akusasetyenziswa phakathi kwearhente kunye nojongano. Amagama okugqithisa ngoku asetyenziswa kuphela ukulungelelanisa uqhagamshelwano lwabasebenzisi kujongano.

Olunye lotshintsho olubonakalayo kule nguqulo intsha kukuba ujongano lwelayini yomyalelo omtsha lucetyiwe, kunye ne-temboard-migratedb eyahlukileyo kunye nezinto eziluncedo ze-temboard-agent-register ziye zathatyathelwa indawo ngemiyalelo eyakhelweyo ebizwa nge-temboard kunye ne-tembhodi-arhente ephunyeziweyo.

El "register-instance" umyalelo wongeziwe ebhodini ukubhalisa iiarhente, leyo, ngokungafaniyo nomyalelo we "temboard-agent register", isetyenziswe kwicala lomncedisi kwaye ayifuni ukuba i-arhente ifikeleleke kwinethiwekhi, okt ingasetyenziselwa ukongeza iimeko ezintsha ngaphandle kweintanethi.

Umthwalo we-arhente kwinkqubo uncitshisiwe: inani lentengiselwano eyenziweyo liye lancitshiswa nge-25%, i-caching yamaxabiso aqhelekileyo kunye nokuphindaphinda komsebenzi kuye kwaphunyezwa.

Ye- Olunye utshintsho evelele kule nguqulo intsha:

• Imiyalelo eyongeziweyo eyakhelwe-ngaphakathi ukwenza ulawulo oluqhelekileyo kunye nemisebenzi yokubeka iliso kumgca womyalelo.
• Inkxaso eyongeziweyo ye-PostgreSQL 15, i-RHEL 9, kunye ne-Debian 12. Ukususwa kwenkxaso ye-PostgreSQL 9.4 kunye ne-9.5 kunye ne-Python 2.7 kunye ne-3.5.
• Ubungakanani bedatha yokulandelela egciniweyo iyancitshiswa ngokungagqibekanga ukuya kwiminyaka emi-2.
• Kongezwe ukukwazi ukukhuphela idatha ye-inventri kwifomathi ye-CSV.
• I-arhente kunye neenkqubo zojongano lwangasemva ziqalwa ngokutsha ngokuzenzekelayo emva kokupheliswa okungaqhelekanga.

Gqibela kwabo banomdla wokwazi okungakumbi ngayo, kufuneka bazi ukuba ikhowudi ibhaliwe kwiPython kwaye ihanjiswa phantsi kwelayisensi yePostgreSQL yamahhala kwaye banokujonga iinkcukacha malunga noguqulelo olutsha. Kule khonkco ilandelayo.

Uyifaka njani iTemBoard kwi-Ubuntu kunye ne-derivatives?

Kwabo banomdla wokukwazi ukufaka olu ncedo, bangayenza ngendlela elula, vula nje i-terminal kwaye kuyo baya kuchwetheza le miyalelo ilandelayo:

sudo echo deb http://apt.dalibo.org/labs $(lsb_release -cs)-dalibo main > /etc/apt/sources.list.d/dalibo-labs.list
sudo curl https://apt.dalibo.org/labs/debian-dalibo.asc | apt-key add -
sudo apt update -y

<span class="gp">sudo </span>apt install temboard <a id="__codelineno-6-2" href="https://temboard.readthedocs.io/en/latest/server_install/#__codelineno-6-2" name="__codelineno-6-2"></a>

sudo temboard --version

Yiyo loo nto, ungaqala ukusebenzisa esi sixhobo sibalaseleyo. Okokugqibela kodwa kuncinci, ndincoma ukuba undwendwele isikhokelo sofakelo ukuze ukwazi ukwenza ulungelelwaniso oluchanekileyo. Ikhonkco yile.