I-ProHoster > Π‘Π»ΠΎΠ³ > izindaba ze-inthanethi > Ukukhishwa kwe-DBMS SQLite 3.32. Iphrojekthi ye-DuckDB ithuthukisa okuhlukile kwe-SQLite ngemibuzo yokuhlaziya

Ukukhishwa kwe-DBMS SQLite 3.32. Iphrojekthi ye-DuckDB ithuthukisa okuhlukile kwe-SQLite ngemibuzo yokuhlaziya

eshicilelwe ukukhululwa I-SQLite 3.32.0, i-DBMS engasindi edizayinelwe njengomtapo wolwazi ofakiwe. Ikhodi ye-SQLite isatshalaliswa njengesizinda somphakathi, i.e. ingasetshenziswa ngaphandle kwemikhawulo futhi mahhala nganoma iyiphi injongo. Usekelo lwezezimali lwabathuthukisi be-SQLite luhlinzekwa yinhlangano edalwe ngokukhethekile, ehlanganisa izinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley ne-Bloomberg.

main shintsha:

  • Kwenziwa kulinganiselwa okuhlukile komyalo HLAZIYA, okuvumela ukuthi udlulele phambili ngokuqoqwa kwengxenye yezibalo kusizindalwazi esikhulu kakhulu, ngaphandle kokuskena okugcwele kwezinkomba. Umkhawulo enanini lamarekhodi lapho uskena inkomba eyodwa usethwa kusetshenziswa isiqondiso esisha "PRAGMA analysis_limit".
  • Kwengezwe ithebula elibonakalayo elisha "ikhodi", enikeza ulwazi mayelana ibhayithi izinkulumo ezilungiselelwe ngaphambilini (isitatimende esilungisiwe).
  • Kwengezwe isendlalelo se-VFS checksum, okwengeza ama-checksums angama-8-byte ekupheleni kwekhasi ngalinye ledatha kusizindalwazi futhi iwahlole isikhathi ngasinye lapho ifundwa kusizindalwazi. Isendlalelo sikuvumela ukuthi uthole umonakalo wesizindalwazi ngenxa yenkohlakalo engahleliwe yamabhithi kumadivayisi okugcina.
  • Kwengezwe umsebenzi omusha we-SQL iif(X,Y,Z), ibuyisela inani elingu-Y uma isisho X siyiqiniso, noma u-Z ngenye indlela.
  • FAKA futhi UBUYEKEZE izisho manje njalo kuyasebenza izinhlobo zekholomu eziqandisayo (ukuhambisana kwekholomu) ngaphambi kokuhlola izimo kubhulokhi HLOLA.
  • Umkhawulo enanini lamapharamitha unyusiwe kusuka ku-999 kuya ku-32766.
  • Kwengezwe isandiso Ukulandelana kokugoqa kwe-UINT ngokusetshenziswa kokuhlelwa kokulandelana okucabangela izinombolo eziphelele zombhalo ukuze kuhlungwe lowo mbhalo ngokulandelana kwezinombolo.
  • Ku-interface yomugqa womyalo, izinketho "-csv", "-ascii" kanye "-skip" zengezwe emyalweni othi ".import". Umyalo othi β€œ.lahla” uvumela ukusetshenziswa kwezifanekiso ze-LIKE ezimbalwa nokuhlanganiswa okukhiphayo kwawo wonke amathebula ahambisana namamaski ashiwo. Kwengezwe umyalo othi ".oom" wokwakhiwa kokususa iphutha. Kwengezwe inketho ethi "--bom" ku-".excel", ".output" kanye nemiyalo ethi ".once". Kwengezwe inketho ethi "--schema" kumyalo othi ".filectrl".
  • Inkulumo ethi ESCAPE ecaciswe ne-opharetha ethi LIKE manje ikhipha amakhadi asendle, ngokuhambisana nokuziphatha kwe-PostgreSQL.

Ukwengeza, singaqaphela ukuthuthukiswa kwe-DBMS entsha I-DuckDB, ethuthukisa okuhlukile kwe-SQLite elungiselelwe ukusetshenziswa imibuzo yokuhlaziya.
Ngaphezu kwekhodi yegobolondo evela ku-SQLite, iphrojekthi isebenzisa umhlaseli kusuka ku-PostgreSQL kanye nengxenye ye-Date Math evela I-MonetDB, ukuqaliswa kwayo kwemisebenzi yewindi (ngokusekelwe ku-algorithm ye-Segment Tree Aggregation), injini yokukhipha imibuzo evectorized (ngokusekelwe ku-algorithm ye-Hyper-Pipelining Query Execution), iphrosesa yenkulumo evamile esekelwe kulabhulali RE2, i-query optimizer yaso kanye nendlela ye-MVCC yokuphatha ukukhishwa kwemisebenzi ngasikhathi sinye (I-Multi-Version Concurrency Control).
Ikhodi yephrojekthi isatshalaliswa ngu ngaphansi kwelayisense ye-MIT. Intuthuko isasesigabeni ukwakheka ukukhishwa kokuhlola.

Source: opennet.ru

Engeza amazwana