Ukukhutshwa kwe-DBMS SQLite 3.32. Iprojekthi yeDuckDB iphuhlisa ukwahluka kweSQLite kwimibuzo yohlalutyo

ipapashiwe ukukhulula I-SQLite 3.32.0, i-DBMS ekhaphukhaphu eyenzelwe njengelayibrari yeplagi. Ikhowudi yeSQLite isasazwa njengendawo yoluntu, okt. inokusetyenziswa ngaphandle kwezithintelo kwaye simahla kuyo nayiphi na injongo. Inkxaso yemali kubaphuhlisi beSQLite inikezelwa yi-consortium eyenziwe ngokukodwa, equka iinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley kunye ne-Bloomberg.

Siseko utshintsho:

• Iphunyeziwe kuqikelelwa Umahluko womyalelo HLALUTYA, ekuvumela ukuba ugqithe ngokuqokelelwa kweenkcukacha-manani kwiindawo ezinkulu kakhulu, ngaphandle kovavanyo lwesalathisi esipheleleyo. Umda kwinani leerekhodi xa uskena isalathiso esinye usetwa kusetyenziswa ulwalathiso olutsha "PRAGMA analysis_limit«.
• Yongezwe itheyibhile entsha enenyani "Ikhowudi", enika ulwazi malunga bytecode iintetho ezilungiselelwe kwangaphambili (ingxelo elungisiweyo).
• I-VFS eyongeziweyo itsheki, eyongeza i-checksums ye-8-byte ekupheleni kwephepha ngalinye ledatha kwi-database kwaye ihlolisise rhoqo xa ifundwa kwisiseko sedatha. Umaleko ikuvumela ukuba ubone umonakalo wesiseko sedatha ngenxa yorhwaphilizo olungakhethiyo lwamasuntswana kwizixhobo zokugcina.
• Kongezwe umsebenzi omtsha weSQL ukuba(X,Y,Z), ibuyisela ixabiso elithi Y ukuba intetho X iyinyani, okanye Z ngenye indlela.
• INSERT kwaye HLAZIYA amabinzana ngoku rhoqo iyasebenza iintlobo zekholam zokukhenkceza (ikholam ubudlelwane) phambi kokuvavanya iimeko kwibhloko KHANGELA.
• Umda kwinani leeparamitha liye lanyuswa ukusuka kwi-999 ukuya kwi-32766.
• Ukongezwa kongeziweyo UINT ulandelelwano lokuhlanganisa ngokuphunyezwa kolandelelwano lokhetho oluthathela ingqalelo ii-integers kwisicatshulwa ukuhlela loo mbhalo ngokolandelelwano lwamanani.
• Kwi-interface yomgca womyalelo, ukhetho "-csv", "-ascii" kunye ne "-skip" zongezwe kumyalelo othi ".import". Umyalelo othi ".lahla" uvumela usebenziso lwetemplates NJENGENYE ngokudityaniswa kwemveliso yazo zonke iitafile ezihambelana nemaski ekhankanyiweyo. Kongezwe ".oom" umyalelo wokulungisa umonakalo. Kongezwe "--bom" ukhetho kwi ".excel", ".output" kunye ne ".once" imiyalelo. Kongezwe ukhetho "--schema" kumyalelo ".filectrl".
• Intetho ye-ESCAPE ebalulwe ngo-LIKE umsebenzisi ngoku ubeka ngaphezulu amakhadi asendle, ngokuhambelana nokuziphatha kwePostgreSQL.

Ukongezelela, sinokuqaphela ukuphuhliswa kwe-DBMS entsha I-DuckDB, ephuhlisa ukwahluka kweSQLite elungiselelwe ukwenziwa imibuzo yohlalutyo.
Ukongeza kwikhowudi yeqokobhe evela kwiSQLite, iprojekthi isebenzisa i-Parser esuka kwi-PostgreSQL, ibekwe kwithala leencwadi elahlukileyo, kunye necandelo leMathematika yoMhla ukusuka. I-MonetDB, uzalisekiso lwayo lwemisebenzi yefestile (ngokusekwe kwiSegment Tree Aggregation algorithm), iVectorized quecution engine (esekelwe kwi-hyper-Pipelining Query Execution algorithm), ilayibrari-based based expression processor RE2, eyakhe i-query optimizer kunye ne-MVCC mechanism yokulawula ukwenziwa kwemisebenzi ngaxeshanye (Multi-Version Concurrency Control).
Ikhowudi yeprojekthi isasazwa ngu phantsi kwelayisenisi ye-MIT. Uphuhliso lusekwinqanaba ukwakheka ukukhutshwa kovavanyo.

umthombo: opennet.ru