Ukukhutshwa kwe-temBoard 8.0, i-interface yolawulo olukude lwe-PostgreSQL DBMS

Iprojekthi ye-temBoard 8.0 ikhutshiwe, iphuhlisa ujongano lwewebhu lolawulo olukude, ukubeka iliso, ukucwangciswa kunye nokulungiswa kwe-PostgreSQL DBMS. Imveliso ibandakanya i-arhente ekhaphukhaphu efakwe kwi-server nganye eqhuba i-PostgreSQL, kunye necandelo leseva elilawula i-central agents kunye nokuqokelela izibalo zokuhlola. Ikhowudi ibhalwe kwiPython kwaye ihanjiswa phantsi kweLayisensi yePostgreSQL yamahhala.

Iimpawu eziphambili zetemBoard:

  • Ukukwazi ukulawula amakhulu eemeko ze-PostgreSQL DBMS ngokusebenzisa ujongano olulodwa lwewebhu.
  • Ukufumaneka kwezikrini zolwazi zokuvavanya zombini imeko ngokubanzi yazo zonke ii-DBMS kunye novavanyo oluthe kratya lwemeko nganye.
    Ukukhutshwa kwe-temBoard 8.0, i-interface yolawulo olukude lwe-PostgreSQL DBMS
  • Ukubeka iliso kwimeko ye-DBMS usebenzisa i-metrics ezahlukeneyo.
  • Inkxaso yokulawula iiseshoni ezisebenzayo ngoku kunye ne-DBMS.
  • Ukubekwa esweni kwemisebenzi yokucoca (VACUUM) yeetafile kunye nezalathisi.
  • Ukubeka iliso kwimibuzo yedatha ecothayo.
  • Ujongano lokusebenzela useto lwePostgreSQL.

Kwinguqulelo entsha:

  • Ukuqinisekiswa kunye nokulungelelaniswa kwejelo lonxibelelwano phakathi kwe-interface yolawulo kunye nee-arhente zenziwe ngokutsha. Utshintsho lukhokelele ekwenziweni lula kweearhente kunye nokwanda kokhuseleko lomjelo wonxibelelwano kunye nabo. Zonke izicelo eziya kwiiarhente ngoku zisayinwe ngokwedijithali kusetyenziswa i-asymmetric public key encryption, kwaye ujongano lusebenza njengomboneleli wesazisi kwiiarhente. Uqinisekiso kusetyenziswa amagama ayimfihlo abekwe ngokudibeneyo kwi-arhente kunye namacala ojongano ayisasetyenziswa. Amagama okugqithisa ngoku asetyenziswa kuphela ukucwangcisa imidibaniso yabasebenzisi kujongano.
  • Ujongano lomgca womyalelo omtsha lucetyiwe. I-temboard-migratedb eyahlukileyo kunye ne-temboard-agent-register eziluncedo zitshintshwe ngemiyalelo eyakhelweyo ebizwa nge-temboard kunye ne-temboard-executables. Imiyalelo eyongeziweyo eyakhelwe-ngaphakathi yokwenza ulawulo olusemgangathweni kunye nokubeka iliso kumgca womyalelo.
  • Inkxaso eyongeziweyo ye-PostgreSQL 15, i-RHEL 9 kunye ne-Debian 12. Inkxaso ye-PostgreSQL 9.4 kunye ne-9.5, kunye ne-Python 2.7 kunye ne-3.5 yayekwa.
  • Umyalelo "we-register-instance" wongezwe kwi-temboard yee-agent zokubhalisa, ezingafaniyo nomyalelo othi "irejista ye-temboard-agent", iqhutywe kwicala lomncedisi kwaye ayifuni ukufumaneka kwenethiwekhi ye-arhente, okt. ingasetyenziselwa ukongeza iimeko ezintsha ngaphandle kweintanethi.
  • Umthwalo wearhente kwisistim uncitshisiwe - inani lentengiselwano eyenziweyo liye lancitshiswa nge-25%, i-caching yamaxabiso aqhelekileyo kunye nomsebenzi wokuphindaphinda uphunyeziwe.
  • Ubungakanani bedatha egciniweyo yokubeka iliso buncitshiswe ngokungagqibekanga ukuya kwiminyaka emi-2.
  • Kongezwe ukukwazi ukukhuphela idatha ye-inventri kwifomathi ye-CSV.
  • Kubonelelwe ngokuqalisa ngokutsha okuzenzekelayo kweenkqubo ezingasemva zojongano kunye nearhente emva kokupheliswa okungaqhelekanga.

Ukongezelela, sinokuqaphela ukukhululwa kwe-Pyrseas 0.10.0 toolkit, eyenzelwe ukuxhasa i-PostgreSQL DBMS kunye nokusebenza ngokuzenzekelayo ukuhlaziya isakhiwo sedatha. I-Pyrseas iguqula i-schema yesiseko sedatha esemgangathweni kunye nemetadata ehambelana nayo ibe yifomathi ye-YAML okanye ye-JSON, efaneleke ngakumbi ukusetyenziswa kwiinkqubo zolawulo loguqulelo. Ukusebenzisa ukumelwa kwe-YAML, i-Pyrseas ibonelela ngesizukulwana se-SQL ukulungelelanisa isakhiwo sedatha enye kunye nenye (oko kukuthi, utshintsho kwisakhiwo lunokwenziwa lula kwaye lusasazwe kwezinye iindawo zolwazi). Ikhowudi yeprojekthi ibhalwe kwiPython kwaye isasazwe phantsi kwelayisensi ye-BSD.

Ukukhutshwa okutsha kwePyrseas kuyaphawuleka kwinguqu kwi-Psycopg 3, isebe elihlaziyiweyo ngokupheleleyo lemodyuli yokusebenza kunye ne-PostgreSQL kwiiprogram zePython, ezixhasa ukusebenzisana kwe-asynchronous kunye ne-DBMS kunye nokubonelela nge-interfaces esekelwe kwi-DBAPI kunye ne-asyncio. Inguqulelo entsha iphinda iwise inkxaso yePython 2.x kwaye isuse i-pgdbconn kwizinto ezixhomekeke kuyo. Inkxaso yamasebe e-PostgreSQL i-10 ukuya kwi-15 inikwe.

umthombo: opennet.ru

Yongeza izimvo