Sakin DBMS SQLite 3.28

Ƙaddamar da saki SQLite 3.28.0, DBMS mai sauƙi wanda aka tsara azaman ɗakin karatu na toshewa. Ana rarraba lambar SQLite azaman yanki na jama'a, watau. ana iya amfani da shi ba tare da hani ba kuma kyauta don kowane dalili. Tallafin kuɗi na masu haɓaka SQLite yana samuwa ta hanyar haɗin gwiwa na musamman da aka ƙirƙira, wanda ya haɗa da kamfanoni kamar Adobe, Oracle, Mozilla, Bentley da Bloomberg.

Main canji:

• Fadada Ayyukan taga (ayyukan taga ko ayyukan nazari waɗanda ke ba da izinin kowane jere na tambaya don yin lissafin ta amfani da wasu layuka): ƙarin tallafi don magana. BAYANI, ya zama mai yiwuwa a yi amfani da shi sarƙoƙi Ayyukan taga (ana bayyana taga ɗaya a cikin yanki na wani), an bayar goyon baya Ƙungiya ta amfani da furcin GROUP, kuma ana aiwatar da ƙuntatawa na RANGE GABATARWA и GABA;
• Ingantattun aiwatar da umarni"WUTA ZUWA", wanda yanzu za a iya amfani da shi tare da bayanan bayanan da ake samu a yanayin karantawa kawai;
• An ƙara sabbin haɓakar tambaya: Gaggauta aiki na LIKE maganganu tare da kalmar ESCAPE da lokacin da aka kunna yanayin "PRAGMA case_sensitive_like". A gaban m index duban da ba dole ba na tabbataccen yanayi na gaskiya da aka ƙayyade a cikin INA an kawar da magana;
• Umurnin".parameter»don aikin haɗe-haɗe (masks da aka maye gurbinsu cikin kowane maganganun SQL). A cikin umarnin ".archive", an sake fasalin zaɓin "--update", wanda yanzu ya tsallake fayilolin da ba a canza ba a cikin rumbun adana bayanai, kuma an ƙara zaɓin "--insert" don haɗa fayiloli a cikin tarihin;
• Bugu da kari fossildelta.c, wanda ke ba ka damar ƙirƙira, amfani da tarwatsawa Task Canje-canjen burbushin halittu da aka yi amfani da su a cikin tsawan RBU;
• Ingantacciyar amincin aiki tare da lalata fayilolin bayanai;
• An kaddamar da madubi na ma'ajiyar aikin GitHub (na asali wurin ajiya goyan bayan amfani da sarrafa sigar burbushin, wanda marubucin SQLite ya halitta).

source: budenet.ru