Kutulutsidwa kwa DBMS SQLite 3.32. Pulojekiti ya DuckDB imapanga mitundu yosiyanasiyana ya SQLite pamafunso owunikira

Lofalitsidwa kumasula SQLite 3.32.0, DBMS yopepuka yopangidwa ngati plug-in library. Khodi ya SQLite imagawidwa ngati malo a anthu onse, i.e. itha kugwiritsidwa ntchito popanda zoletsa komanso kwaulere pazifukwa zilizonse. Thandizo lazachuma kwa opanga ma SQLite limaperekedwa ndi bungwe lopangidwa mwapadera, lomwe limaphatikizapo makampani monga Adobe, Oracle, Mozilla, Bentley ndi Bloomberg.

waukulu kusintha:

• Zakhazikitsidwa pafupifupi mtundu wina wa lamulo la ANALYZE, lomwe limakupatsani mwayi wopitilira ndi kusonkhanitsa pang'ono kwa ziwerengero m'madatabase akulu kwambiri, osayang'ana mozama. Malire a kuchuluka kwa zolembedwa mukamasanthula index imodzi amayikidwa pogwiritsa ntchito malangizo atsopano "PRAGMA analysis_limit".
• Anawonjezera tebulo latsopano "chikhomo", yomwe imapereka zambiri za byte kodi mawu okonzedweratu (mawu okonzeka).
• Wowonjezera VFS wosanjikiza checksum, yomwe imawonjezera ma checksums a 8-byte kumapeto kwa tsamba lililonse la deta mu database ndikuyang'ana nthawi iliyonse yomwe ikuwerengedwa kuchokera ku database. Wosanjikiza amakulolani kuti muwone kuwonongeka kwa database chifukwa cha katangale mwachisawawa pazida zosungira.
• Anawonjezera ntchito yatsopano ya SQL ngati(X,Y,Z), kubwezera mtengo Y ngati mawu X ali owona, kapena Z ayi.
• INSERT ndi UPDATE mawu tsopano nthawi zonse kuyikidwa mitundu ya mizere yozizira (mgwirizano wapakatikati) musanayambe kuwunika momwe zinthu zilili mu block ZAKE.
• Malire pa kuchuluka kwa magawo awonjezeka kuchokera ku 999 mpaka 32766.
• Zowonjezera zowonjezera UINT kutsata ndondomeko ndi kukhazikitsa masanjidwe otsatizana omwe amaganizira zonse za mawuwo kuti asanthule mawuwo mwadongosolo la manambala.
• M'mawonekedwe a mzere wa malamulo, zosankha "-csv", "-ascii" ndi "-skip" zawonjezeredwa ku lamulo la ".import". Lamulo la ".dump" limalola kugwiritsa ntchito ma tempulo angapo a LIKE ndi kuphatikiza kwa matebulo onse ofanana ndi masks omwe atchulidwa. Lamulo lowonjezera la ".oom" la kukonza zolakwika. Anawonjezera "--bom" njira ".excel", ".output" ndi ".once" malamulo. Chowonjezera "--schema" ku lamulo la ".filectrl".
• Mawu a ESCAPE otchulidwa ndi LIKE wogwiritsa ntchito tsopano akuposa makadi akutchire, mogwirizana ndi khalidwe la PostgreSQL.

Kuphatikiza apo, titha kuzindikira kukula kwa DBMS yatsopano DuckDB, yomwe ikupanga zosinthika za SQLite zokongoletsedwa kuti zitheke mafunso analytics.
Kuphatikiza pa chipolopolo cha SQLite, polojekitiyi imagwiritsa ntchito cholembera kuchokera ku PostgreSQL ndi gawo la Date Math kuchokera. MonetDB, kukhazikitsa kwake kwa ntchito zazenera (kutengera algorithm ya Segment Tree Aggregation), injini yowunikira mafunso (yotengera Hyper-Pipelining Query Execution algorithm), purosesa yokhazikika ya library RE2, query optimizer yake ndi MVCC njira yoyendetsera ntchito munthawi imodzi (Multi-Version Concurrency Control).
Project kodi wogawidwa ndi pansi pa MIT layisensi. Chitukuko chidakali pa siteji mapangidwe zotulutsa zoyeserera.

Source: opennet.ru