Siideynta DuckDB 0.10.0 DBMS ayaa la soo bandhigay, iyadoo la isku darayo sifooyinka SQLite sida isafgaradka, awoodda isku xirka qaab maktabad ku xiran, kaydinta xogta hal fayl iyo interface CLI ku habboon, oo leh qalab iyo hagaajinta fulinta Weydiimaha gorfaynta ee daboolaya qayb muhiim ah oo ka mid ah xogta la kaydiyay, tusaale ahaan isu geynaya dhammaan waxa ku jira miisaska ama isku dara dhowr miisas oo waaweyn. Xeerka mashruuca waxa lagu qaybiyaa shatiga MIT. Horumarka ayaa weli ku jira marxaladda samaynta siidaynta tijaabada ah, maadaama qaabka kaydinta aan weli la dejin oo uu beddelo nooc ilaa nooc.
DuckDB waxay bixisaa lahjad horumarsan oo SQL ah oo ay ku jiraan awoodo dheeraad ah oo lagu maareynayo weydiimaha aadka u adag oo waqti badan qaata. Isticmaalka noocyo kakan (habayn, qaab-dhismeedyo, ururo) iyo kartida lagu fulinayo wax-is-daba-marin hoose ayaa la taageeray. Waxay taageertaa socodsiinta su'aalo badan isku mar, ka socodsiinta su'aalaha si toos ah faylasha CSV iyo Parquet. Waa suurtogal in laga keeno PostgreSQL DBMS.
Marka lagu daro koodhka qolofka ee SQLite, mashruucu wuxuu isticmaalaa parser-ka PostgreSQL ee maktabad gaar ah, Qaybta Xisaabta Taariikhda ee MonetDB, hirgelinteeda u gaarka ah ee hawlaha daaqada (oo ku salaysan Segment Tree Aggregation algorithm), farsameeyaha muujinta joogtada ah ee ku salaysan maktabadda RE2, hagaajinteeda su'aalaheeda, iyo habka xakamaynta MVCC ee fulinta hawlaha isku mar ah (Multi-Version Concurrency Concurrency), iyo sidoo kale matoorka fulinta weydiinta ee ku salaysan algorithm-ka Hyper-pipelining Query Execution, kaas oo u oggolaanaya qaybo badan oo qiyam ah. in hal mar lagu farsameeyo hal qaliin.
Waxaa ka mid ah isbeddelada sii deynta cusub:
- Waxqabadka xog-ururinta ee qaabka CSV ayaa si weyn loo hagaajiyay. Tusaale ahaan, akhrinta faylka CSV oo wata 11 milyan oo saf oo nooca cusub ah ayaa laga dhimay 2.6 ilbiriqsi. ilaa 1.15 ilbidhiqsi, iyo samaynta "Xulashada COUNT(*)" hawlgalka dushiisa faylka CSV laga bilaabo 1.8 ilbiriqsi. ilaa 0.3 ilbiriqsi
- Taageerada lagu daray ee jaangooyooyinka cabbirka go'an, kuwaas oo u eg liisaska ay ku jiraan tiro go'an oo walxo ah ("SUURID TABLE vectors(v DOUBLE[3]);").
- Taageero lagu daray isku xirka MySQL, PostgreSQL iyo SQLite DBMS, taas oo kuu ogolaanaysa inaad xogta ka soo dejiso DBMS dibadeed DuckDB una gudbiso nidaamyada kala duwan. Xog-ururinta dibadda waxa lagu gelayaa iyadoo la isticmaalayo jaantusyada caadiga ah. Ku dheji 'postgres:dbname=postgresscanner' AS postgres; Dooro ciwaanka, sanadka sii daynta, dhererka FROM postgres.filim LIMIT 5;
- Taageero lagu daray odhaahda "COMMENT ON" ee lagu kaydinayo faallooyinka ku saabsan shay ku jira kaydka
- Taageero lagu daray "NOOQI KA NOQODAY DATABASE" odhaahda dhammaan nuxurka laga soo minguuriyay xog ururinta mid kale.
- Taageero lagu daray wax ka beddelka "ALL" marka laga reebo tibaaxaha INTERSECT.
- Nooca la fuliyay
Source: opennet.ru
