Mwepụta nke DBMS SQLite 3.32. Ọrụ DuckDB na-emepụta ụdị dị iche iche nke SQLite maka ajụjụ nyocha

bipụtara hapụ SQLite 3.32.0, DBMS dị fechaa emebere ka ọbá akwụkwọ nkwụnye. A na-ekesa koodu SQLite dịka ngalaba ọha, ya bụ. enwere ike iji ya na-enweghị mgbochi yana n'efu maka ebumnuche ọ bụla. Nkwado ego maka ndị mmepe SQLite bụ ụlọ ọrụ emebere nke ọma, nke gụnyere ụlọ ọrụ dịka Adobe, Oracle, Mozilla, Bentley na Bloomberg.

Main gbanwee:

• Emere ya oruru ụdị dị iche iche nke iwu ANALYZE, nke na-enye gị ohere iji nweta mkpokọta ọnụ ọgụgụ dị na ọdụ data buru ibu, na-enweghị nyocha zuru ezu nke index. Oke na ọnụọgụ ndekọ mgbe ị na-enyocha otu ndeksi ka edobere site na iji ntuziaka ọhụrụ "PRAGMA analysis_limit".
• Tebụlụ mebere ọhụrụ agbakwunyere"koodu byte", nke na-enye ozi gbasara bytecode okwu akwadoro tupu (nkwupụta akwadoro).
• agbakwunyere oyi akwa VFS checksum, nke na-agbakwunye 8-byte checksums na njedebe nke ibe ọ bụla nke data na nchekwa data ma na-enyocha ha oge ọ bụla a na-agụ ya na nchekwa data. Igwe oyi akwa na-enye gị ohere ịchọpụta mmebi nchekwa data n'ihi nrụrụ aka nke ibe n'ibe na ngwaọrụ nchekwa.
• Agbakwunyere ọrụ SQL ọhụrụ iif (X, Y, Z), iweghachi uru Y ma ọ bụrụ na okwu X bụ eziokwu, ma ọ bụ Z ma ọ bụghị.
• Tinye na kwalite okwu ugbu a mgbe niile etinyere ya Ụdị kọlụm na-ajụ oyi (njikọ kọlụm) tupu nyochaa ọnọdụ na ngọngọ Lelee.
• Oke na ọnụ ọgụgụ nke paramita abawanyela site na 999 ruo 32766.
• agbakwunyere mgbakwunye Usoro nchịkọta UINT na mmejuputa nhazi usoro nke na-eburu n'uche ọnụọgụ ọnụọgụgụ dị na ederede iji hazie ederede ahụ n'usoro ọnụọgụ.
• Na interface ahịrị ahịrị, agbakwunyere nhọrọ "-csv", "-ascii" na "-skip" na iwu ".import". Iwu ".dump" na-enye ohere iji ọtụtụ ndebiri LIKE na nchịkọta mmepụta nke tebụl niile kwekọrọ na ihe mkpuchi akọwapụtara. agbakwunyere iwu ".oom" maka nrụpụta nbibi. Agbakwunyere nhọrọ "--bom" na ".excel", ".mmepụta" na ".otu oge" iwu. Etinyere nhọrọ "--schema" na iwu ".filectrl".
• Okwu ESCAPE akọwapụtara ya na onye na-ahụ maka LIKE na-ewepụzi kaadị ọhịa, dabara na omume PostgreSQL.

Na mgbakwunye, anyị nwere ike ịhụ mmepe nke DBMS ọhụrụ DuckDB, nke na-etolite ụdị SQLite kachasị maka igbu ya ajụjụ nyocha.
Na mgbakwunye na koodu shei sitere na SQLite, oru ngo a na-eji parser sitere na PostgreSQL yana ngwa mgbakọ na mwepụ ụbọchị sitere na. MonetDB, mmejuputa iwu nke ya nke ọrụ windo (dabere na Segment Tree Aggregation algọridim), igwe nyocha ajụjụ vectorized (dabere na Hyper-Pipeling Query Execution algọridim), nhazi okwu oge niile dabere na ọba akwụkwọ. RE2, ihe njikarịcha ajụjụ nke ya na usoro MVCC maka ijikwa mmezu nke ọrụ n'otu oge (Multi-Version Concurrency Control).
Koodu oru ngo kesara site n'okpuru ikike MIT. Mmepe ka nọ na ogbo nhazi mwepụta nnwale.

isi: opennet.ru