Siideynta DBMS SQLite 3.32. Mashruuca DuckDB wuxuu horumariyaa kala duwanaanshiyaha SQLite ee su'aalaha falanqaynta

la daabacay sii daayo SQLite 3.32.0, DBMS khafiifa oo loo qaabeeyey sidii maktabad fur-in. Koodhka SQLite waxa loo qaybiyaa goob dadweyne ahaan, i.e. waxaa loo isticmaali karaa xad la'aan iyo lacag la'aan ujeedo kasta. Taageerada maaliyadeed ee horumarinta SQLite waxaa bixiya isbahaysi si gaar ah loo abuuray, oo ay ku jiraan shirkado ay ka mid yihiin Adobe, Oracle, Mozilla, Bentley iyo Bloomberg.

Main isbedel:

• La fuliyay qiyaastii kala duwanaansho ka mid ah amarka ANALYZE, kaas oo kuu ogolaanaya inaad ku hesho by ururinta qayb ka mid ah tirokoobyada ee database aad u weyn, iyada oo aan si buuxda scan of indexes. Xadka tirada diiwaanada marka la sawirayo hal tusmo ayaa la dejiyay iyadoo la isticmaalayo dardaaranka cusub"PRAGMA falanqaynta_limit«.
• Miis cusub oo dalwad ah ayaa lagu daray"code byte", kaas oo bixiya macluumaad ku saabsan bytecode weedho horay loo sii diyaariyay (hadal diyaarsan).
• Lakabka VFS ee lagu daray hubin, kaas oo ku daraya 8-byte checksums dhammaadka bog kasta oo xogta ku jira kaydka oo hubiya mar kasta oo laga akhriyo kaydka. Lakabku wuxuu kuu ogolaanayaa inaad ogaato burburka keydka xogta taasoo ka dhalatay musuqmaasuqa random ee qashin-qubka ee aaladaha kaydinta.
• Lagu daray hawl cusub oo SQL iif(X,Y,Z), soo celinta qiimaha Y haddii odhaahda X run tahay, ama Z haddii kale.
• GELI oo cusboonaysii tibaaxaha hadda had iyo jeer codsatay noocyada tiirarka qaboojinta (xidhiidhka tiirka) ka hor inta aan la qiimeyn xaaladaha ku jira block HUBI.
• Xadka tirada halbeegyada ayaa laga kordhiyey 999 ilaa 32766.
• Kordhinta lagu daray UINT isku xigxiga iyada oo la fulinayo kala-saarid isku xigxig ah oo tixgalinaysa is-dhex-galka qoraalka si loo kala saaro qoraalkaas sida ay u kala horreeyaan.
• In interface line amarka, fursadaha "-csv", "-ascii" iyo "-skip" ayaa lagu daray amarka ".import". Amarka ". daadinta" wuxuu u oggolaanayaa isticmaalka dhowr nooc oo LIKE ah oo ay la socdaan wax soo saarka dhammaan miisaska u dhigma waji-xidhka la cayimay. Lagu daray ".oom" amarka dhisidda cilladaha. Waxaa lagu daray "-bom" ikhtiyaarka ".excel", ".output" iyo ".mar" amarrada. Lagu daray "--schema" ikhtiyaarka ".filectrl" amarka.
• Odhaahda ESCAPE ee lagu sheegay hawlwadeenka LIKE ayaa hadda meesha ka saaraya kaararka duurjoogta ah, oo waafaqsan dhaqanka PostgreSQL.

Intaa waxaa dheer, waxaan ogaan karnaa horumarinta DBMS cusub DuckDB, kaas oo horumarinaya kala duwanaansho SQLite ah oo loo habeeyay fulinta weydiimaha gorfaynta.
Marka lagu daro koodhka qolofka ee SQLite, mashruucu waxa uu isticmaalayaa parser ka PostgreSQL iyo qaybta xisaabta taariikhda MonetDB, hirgelinteeda u gaarka ah ee hawlaha daaqada (oo ku saleysan Qaybta Iskudarka Algorithm ee Geedka), mashiinka fulinta weydiinta vectorized (oo ku saleysan Hyper-Pipeling Query Execution Algorithm), soo-saare hadalka joogtada ah ee maktabad ku saleysan RE2, wanaajiye su'aal u gaar ah iyo habka MVCC ee maaraynta fulinta isku mar ah ee shaqooyinka
Koodhka mashruuca qaybiyey hoos shatiga MIT. Horumarku wali waa heerkii samaynta sii dayn tijaabo ah.

Source: opennet.ru