Kungekudala, Iqela lokuphuhliswa kweQela loPhuhliso lePostgreSQL libhengeze ubukho benguqulelo yokuqala ye-beta yePostgreSQL 12. Le nguqulo iqulethe ukujonga kwangaphambili kwayo yonke imisebenzi eya kubakho kuhlobo lokugqibela lwePostgreSQL 12, nangona ezinye iinkcukacha zinokutshintsha ngaphambi koko.
Iqela likhuthaza abasebenzisi ukuba bazame amanqaku amatsha kwiPostgreSQL 12 ukunceda ukuphelisa iibugs okanye eminye imiba enokubakho kolu khululo.
"Uvavanyo kunye nengxelo yakho kuya kunceda uluntu ukuba luqinisekise ukuba ukukhutshwa kwe-PostgreSQL 12 kuyahlangabezana nemigangatho yethu yokubonelela ngohlobo oluzinzileyo noluthembekileyo lwedatha evulekileyo yolwazi oluvulekileyo kwihlabathi." Iqela le-Global PostgreSQL loPhuhliso.
Kulabo kuni abangaqhelekanga ngePostgreSQL, kuya kufuneka niyazie ikwabizwa ngokuba yiPostgres kunye Le yinkqubo yolawulo lwesiseko sedatha (I-RDBMS) simahla, vula umthombo, ejolise ekunikezeleni ngesiseko sedatha ngokubhekisele kukolula nokuthobela imigangatho yobugcisa.
Yenzelwe ukuphatha imisebenzi eyahlukeneyo, ukusuka koomatshini abalula ukuya kwindawo yokugcina idatha okanye iinkonzo zewebhu ezinabasebenzisi abaninzi ngaxeshanye.
Iimpawu zenguqulelo entsha yePostgreSQL 12 iBeta 1
Ngokukhutshwa kwale nguqulo intsha ye-beta, Siza kufumanisa ukuba isalathiso sentsebenzo kunye neempawu zolawulo zibalasele.
Ukususela I-PostgreSQL 12 ibonelela ngesakhono sokwakha ii-indexes ngaxeshanye, ukuvumela ukuba wenze imisebenzi emininzi.
Ngelixa usebenza ngaphandle kokubhloka ubhalela isalathiso. NgokukaPostgres, eli nqaku kufuneka lincedise ekwakhiweni kwakhona kwezalathiso ezinde ezinokubangela ixesha lokuphumla xa ulawula isiseko sedatha sePostgreSQL kwindawo yemveliso. Ukongeza, yandisa amandla eendlela ezizodwa zesalathiso esikhethekileyo, ukukwazi ukwenza ii-indexes zokugubungela.
Ngokubonisana kwi-Intanethi
Amagqabantshintshi etafile aqhelekileyo ngoku anokufakwa ngokuzenzekelayo kumbuzo ukuba awaphindeki, azinazo iziphumo ebezingalindelekanga kwaye zikhankanywa kube kanye kwinxalenye yombuzo. Oku kususa "isithintelo sokwenza ngcono" esele ikho ukusungulwa kwegatya le-NA kwiPostgreSQL 8.4.
Ukwahlula
Le nguqulo yePostgreSQL iphucula ukusebenza xa kusetyenzwa kwiitafile ezinamawaka okwahlulahlula Ukusebenza okufuna kuphela ukusetyenziswa kwenani elincinci lezahlulelo.
Kwakhona izisa i-INSERT kunye ne-COPY yokuphucula ukusebenza kwitafile eyahlulelweyo. ISIQINISEKISO SEXESHA ngoku singenziwa ngaphandle kokuthintela imibuzo efanayo kwitafile eyahluliweyo. Ukongeza, amandla okusebenzisa amaqhosha angaphandle ekubhekiseni kwitafile ezahlulwe ngoku iyavunyelwa.
Iikholamu ezivelisiweyo
Inkqubo yolawulo lwedatha ehambelana nayo ivumela ukwenziwa kweekholamu ezivelisiweyo ezibala amaxabiso abo ngentetho usebenzisa umxholo wezinye iikholamu.
Eli nqaku libonelela ngokugcina iikholamu, ezibalwa kufakwa kunye nohlaziyo kwaye zigcinwe kwidiski.
Iikholamu ezibonakalayo ezivelisiweyo, zibalwa kuphela xa ikholamu ifundwa njengenxalenye yombuzo, ayikenziwa.
I-SQL / JSON
Le nguqulo ye-beta ye IPostgreSQL 12 ngoku ivumela ukwenziwa kwemibuzo yendlela yeJSON Ngokwenkcazo ye-SQL / JSON kwi-SQL: 2016 esemgangathweni.
Njengamabinzana e-XPath eXML, amabinzana endlela yeJSON akuvumela ukuba uvavanye iintlobo ezahlukeneyo zokubonisa kunye nemisebenzi, kunye nokuthelekisa amaxabiso kumaxwebhu eJSON.
Ubuntununtunu bamatyala
Okokugqibela lolunye utshintsho ekufuneka lubalaselisiwe dLe nguqulo ye-beta yePostgreSQL 12 kukuba ngoku ixhasa ukuthelekiswa okungakhathaliyo kunye nesandi kuthelekiso olunikezwe yi-UCI, ekwabizwa ngokuba yi »non-deterministic collations«.
Xa zisetyenzisiwe, ezi zinto zidibeneyo zinokubonelela ngokulula ngokuthelekisa kunye nenqanaba, kodwa zinokukhokelela kwisohlwayo sokusebenza, njengoko ingqokelela inokudinga ukwenza ezinye iitshekhi kumtya.
Ekugqibeleni, iqela limema abahlali bePostgreSQL ukuba bavavanye le nguqulo.
Uzinzo kuhlobo ngalunye lwePostgreSQL luxhomekeke kakhulu eluntwini, ke nceda uzame. Umgangatho wovavanyo lwabasebenzisi uya kugqiba ukuba sinokwenza uhlobo lokugqibela nini, "utshilo.
Fumana kwaye uvavanye iPostgreSQL 12 beta 1