Mwepụta nke DBMS SQLite 3.28

Ewebata hapụ SQLite 3.28.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:

• Gbasaa Ọrụ windo (ọrụ windo ma ọ bụ ọrụ nyocha nke na-enye ohere maka ahịrị ajụjụ ọ bụla iji mee mgbako site na iji ahịrị ndị ọzọ): nkwado agbakwunyere maka nkwupụta. Ewezuga, ọ bịara kwe omume iji agbụ ígwè ọrụ window (a na-akọwa otu windo na mpaghara nke ọzọ), nyere nkwado otu na-eji okwu GROUP, yana mmachi RANGE na-emejuputa atumatu NA-ebu ụzọ и Na-eso;
• Mmejuputa iwu a emelitere"Mkpuchi n'ime", nke enwere ike iji ugbu a na ọdụ data dị na ọnọdụ ọgụgụ naanị;
• Nkwalite ajụjụ ọhụrụ agbakwunyere: Ọsọ ọsọ arụmọrụ nke okwu LIKE yana okwu ESCAPE yana mgbe agbanyere ọnọdụ "PRAGMA case_sensitive_like". N'ihu nke ndepụta akụkụ nlele na-enweghị isi nke doro anya na ezi ọnọdụ akọwapụtara n'ime ebe a na-ekpochapụ nkebiokwu;
• Iwu ahụ".paramita» maka ọrụ ahụ mgbakwunye mgbakwunye (masks dochie n'ime okwu SQL ọ bụla). N'iwu ".archive", emezigharị nhọrọ "--update", nke na-awụpụ faịlụ na-agbanweghi agbanwe ugbua na ebe nchekwa, na nhọrọ "--insert" agbakwunyere iji tinye faịlụ na ebe nchekwa;
• Mgbakwunye agbakwunyere fossildelta.c, nke na-enye gị ohere ịmepụta, tinye na ịkwasa ebe a Fossil delta mgbanwe eji na RBU ndọtị;
• Enwekwu ntụkwasị obi nke ịrụ ọrụ na faịlụ nchekwa data mebiri emebi;
• Agbanyela enyo nke ebe nchekwa ọrụ ahụ GitHub (nke bụ isi ebe nchekwa kwadoro site na iji njikwa ụdị Fossil, nke onye dere SQLite kere).

isi: opennet.ru