Iphrojekthi ye-temBoard 8.0 isikhishiwe, ithuthukisa isixhumi esibonakalayo sewebhu sokuphatha kude, ukuqapha, ukumisa kanye nokwenza kahle kwe-PostgreSQL DBMS. Umkhiqizo uhlanganisa i-ejenti engasindi efakwe kuseva ngayinye esebenzisa i-PostgreSQL, kanye nengxenye yeseva ephatha ama-ejenti emaphakathi futhi iqoqe izibalo zokuqapha. Ikhodi ibhalwe ngePython futhi isatshalaliswa ngaphansi kweLayisense ye-PostgreSQL yamahhala.
Izici eziyinhloko ze-teBoard:
- Amandla okuphatha amakhulukhulu ezenzakalo ze-PostgreSQL DBMS ngokusebenzisa isixhumi esibonakalayo sewebhu esimaphakathi.
- Ukutholakala kwezikrini zolwazi zokuhlola kokubili isimo esijwayelekile sawo wonke ama-DBMS kanye nokuhlola okunemininingwane eminingi yesenzakalo ngasinye.
- Ukuqapha isimo se-DBMS kusetshenziswa amamethrikhi ahlukahlukene.
- Usekelo lokuphatha amaseshini asebenzayo njengamanje nge-DBMS.
- Ukuqapha imisebenzi yokuhlanza (VACUUM) yamathebula nezinkomba.
- Ukuqapha imibuzo yesizindalwazi esinensayo.
- Isixhumi esibonakalayo sokuthuthukisa izilungiselelo ze-PostgreSQL.
Enguqulweni entsha:
- Ukuqinisekiswa nokuhleleka kwesiteshi sokuxhumana phakathi kwesixhumi esibonakalayo sokuphatha nama-ejenti kuklanywe kabusha. Izinguquko ziholele ekwenziweni lula kwama-ejenti kanye nokuvikeleka okwandisiwe kwesiteshi sokuxhumana nabo. Zonke izicelo eziya kubasebenzeli manje sezisayinwa ngokwedijithali kusetshenziswa ukubethela kokhiye womphakathi ongalingani, futhi isixhumi esibonakalayo sisebenza njengomhlinzeki wobunikazi kubasebenzeli. Ukuqinisekisa kusetshenziswa amagama ayimfihlo asethwe ngokuhlanganyela kumenzeli nasemaceleni okusebenza akusasetshenziswa. Amaphasiwedi manje asesetshenziswa kuphela ukuhlela ukuxhumana komsebenzisi kusixhumi esibonakalayo.
- Kuphakanyiswe ukusebenzelana komugqa womyalo omusha. Izinsiza ezihlukene ze-temboard-migratedb kanye ne-temboard-agent-register zithathelwe indawo imiyalo eyakhelwe ngaphakathi ebizwa nge-temboard ne-temboard-ejenti esebenzisekayo. Kungezwe imiyalo eyakhelwe ngaphakathi yokwenza ukuphatha okujwayelekile nokuqapha imisebenzi evela emugqeni womyalo.
- Usekelo olungeziwe lwe-PostgreSQL 15, RHEL 9 ne-Debian 12. Ukusekelwa kwe-PostgreSQL 9.4 no-9.5, kanye ne-Python 2.7 kanye ne-3.5 kuyekwa.
- Umyalo othi "register-istance" ungeziwe ku-temboard yama-ejenti okubhalisa, okuthi, ngokungafani nomyalo "werejista ye-ejenti ye-temboard", yenziwa ohlangothini lweseva futhi ayidingi ukutholakala kwenethiwekhi ye-ejenti, i.e. ingasetshenziswa ukwengeza izimo ezintsha ungaxhunyiwe ku-inthanethi.
- Umthwalo we-ejenti ohlelweni uncishisiwe - inani lemisebenzi eyenziwayo lehliswe ngo-25%, ukugcinwa kunqolobane kwamanani ajwayelekile kanye nokuphindaphindwa komsebenzi sekusetshenzisiwe.
- Usayizi wedatha yokuqapha egciniwe yehlisiwe ngokuzenzakalelayo yaba iminyaka emi-2.
- Kwengezwe amandla okulanda idatha yokusungula ngefomethi ye-CSV.
- Kunikezwe ukuqalisa kabusha okuzenzakalelayo kwezinqubo zangemuva zesixhumi esibonakalayo kanye ne-ejenti ngemva kokunqanyulwa okungavamile.
Ukwengeza, singaqaphela ukukhishwa kwekhithi yamathuluzi ye-Pyrseas 0.10.0, eklanyelwe ukusekela i-PostgreSQL DBMS kanye nokusebenza okuzenzakalelayo ukuze kuthuthukiswe ukwakheka kwedatha. I-Pyrseas iguqula i-schema sesizindalwazi esijwayelekile kanye nemethadatha ehlotshaniswayo ibe ifomethi ye-YAML noma ye-JSON, efaneleke kakhulu ukusetshenziswa kumasistimu okulawula inguqulo. Isebenzisa isethulo se-YAML, i-Pyrseas inikeza isizukulwane se-SQL ukuvumelanisa ukwakheka kwesizindalwazi esisodwa nesinye (okungukuthi, izinguquko esakhiweni zingenziwa kalula futhi zisakazwe kwezinye izingosi zolwazi). Ikhodi yephrojekthi ibhalwe ngePython futhi isatshalaliswa ngaphansi kwelayisensi ye-BSD.
Ukukhishwa okusha kwe-Pyrseas kuyaphawuleka ngokushintshela ku-Psycopg 3, igatsha eliklanywe kabusha ngokuphelele lemojula yokusebenza ne-PostgreSQL kusuka ezinhlelweni ze-Python, ukusekela ukusebenzisana okungahambisani ne-DBMS nokuhlinzeka ngokuxhumana okusekelwe ku-DBAPI ne-asyncio. Inguqulo entsha iphinde yehlise ukusekelwa kwePython 2.x futhi isuse i-pgdbconn kokuncikile. Ukusekelwa kwamagatsha e-PostgreSQL 10 kuya ku-15 kunikezwa.
Source: opennet.ru