Kuburitswa kweDBMS SQLite 3.32. DuckDB purojekiti inovandudza SQLite musiyano wemibvunzo yekuongorora

rakabudiswa kusunungura SQLite 3.32.0, DBMS isingaremi yakagadzirwa seraibhurari yeplug-in. Iyo SQLite kodhi inogoverwa senzvimbo yeruzhinji, i.e. inogona kushandiswa pasina kurambidzwa uye pasina muripo kune chero chinangwa. Rutsigiro rwemari rwevagadziri veSQLite rwunopihwa nemubatanidzwa wakanyatsogadzirwa, unosanganisira makambani akadai seAdobe, Oracle, Mozilla, Bentley neBloomberg.

chikuru change:

• Implemented approximated mutsauko weiyo ANALYZE command, iyo inokutendera iwe kuti upfuure nechikamu muunganidzwa wenhamba mune yakakura kwazvo dhatabhesi, pasina yakazara scanner ye indexes. Muganho wehuwandu hwemarekodhi kana uchitarisa imwe index inoiswa uchishandisa iyo nyowani dhairekitori "PRAGMA analysis_limit".
• Yakawedzera tafura nyowani "byte code", iyo inopa ruzivo nezve bytecode mashoko akafanogadzirirwa (chirevo chakagadzirirwa).
• Yakawedzera VFS layer checksum, iyo inowedzera 8-byte checksums kusvika kumagumo epeji rega rega re data mudhatabhesi uye inovatarisa nguva imwe neimwe iyo inoverengwa kubva mudura. Iyo layer inobvumidza iwe kuti uone kukuvadzwa kwedhatabhesi semhedzisiro yehuwori hwema bits mumidziyo yekuchengetedza.
• Yakawedzera itsva SQL basa iif(X,Y,Z), kudzorera kukosha Y kana kutaura X kuri chokwadi, kana Z neimwe nzira.
• INSERT uye UPDATE mataurirwo izvozvi nguva dzose kuiswa mhando dzembiru dzechando (column affinity) asati aongorora mamiriro ari mubhuroko Check.
• Muganho wehuwandu hwema parameter akawedzera kubva 999 kusvika 32766.
• Added extension UINT inotevedzana nekushandiswa kwekuronga kwenhevedzano uko kunotora pfungwa dzezvikamu zviri muzvinyorwa kuronga zvinyorwa izvozvo munhevedzano yenhamba.
• Mumutsara wekuraira, sarudzo "-csv", "-ascii" uye "-skip" dzakawedzerwa ku ".import" murairo. Murairo we ".dump" unobvumira kushandiswa kwematemu akati wandei AKAFANANA neinobuda nekubatanidzwa kwematafura ese anoenderana nemasiki akataurwa. Yakawedzerwa ".oom" murairo wekugadzirisa kugadzirisa. Yakawedzerwa "--bom" sarudzo ye ".excel", ".output" uye ".once" mirairo. Yakawedzerwa "--schema" sarudzo kune ".filectrl" murairo.
• Chirevo cheESCAPE chakatsanangurwa neAKAFANANA neanoshanda zvino chinodarika makadhi emusango, zvinoenderana nePostgreSQL maitiro.

Pamusoro pezvo, tinogona kucherechedza kuvandudzwa kweDBMS itsva DuckDB, iyo iri kugadzira musiyano weSQLite yakagadziridzwa kuti iite analytical mibvunzo.
Pamusoro peiyo shell kodhi kubva kuSQLite, chirongwa ichi chinoshandisa parser kubva kuPostgreSQL uye Date Math chikamu kubva. MonetDB, kuita kwayo kwekuita kwemahwindo emabasa (zvichienderana neSegment Tree Aggregation algorithm), vectorized query execution injini (yakavakirwa paHyper-Pipelining Query Execution algorithm), raibhurari-yakavakirwa nguva dzose kutaura processor. RE2, yayo yega query optimizer uye MVCC maitiro ekugadzirisa panguva imwe chete yekuitwa kwemabasa (Multi-Version Concurrency Control).
Project code inoparadzirwa ne pasi peMIT rezinesi. Budiriro ichiri padanho kuumbwa kuyedza kuburitswa.

Source: opennet.ru