Kuburitswa kweDBMS SQLite 3.28

Introduced kusunungura SQLite 3.28.0, DBMS isingaremi yakagadzirwa seraibhurari yeplug-in. Iyo SQLite kodhi inogoverwa senzvimbo yeruzhinji, i.e. inogona kushandiswa pasina kurambidzwa uye pasina muripo kune chero chinangwa. Rutsigiro rwemari rwevagadziri veSQLite rwunopihwa nemubatanidzwa wakanyatsogadzirwa, unosanganisira makambani akadai seAdobe, Oracle, Mozilla, Bentley neBloomberg.

chikuru change:

• Yakawedzerwa hwindo mabasa (mahwindo emabasa kana analytical mabasa anobvumira kuti mutsara wega wega wemubvunzo uite maverengero uchishandisa mimwe mitsara): yakawedzera rutsigiro rwekutaura. SUNGAMIRIRA, zvakava nyore kushandisa maketani hwindo mabasa (rimwe hwindo rinotsanangurwa munzvimbo yeimwe), rakapihwa kutsigira mapoka anoshandisa GROUP kutaura, uye RANGE zvirambidzo zvinoiswa PRECEDING и ZVINOTEVERA;
• Kuvandudzwa kwekushandiswa kwemurairo "VACUUM INTO", iyo ikozvino inogona kushandiswa nedatabase inowanikwa mukuverenga-chete modhi;
• Yakawedzera mitsva yemubvunzo optimizations: Accelerated kushanda kweLIKE mataurirwo pamwe chete ne ESCAPE kiyi kiyi uye kana iyo "PRAGMA kesi_sensitive_like" modhi inogoneswa. Pamberi pe chikamu indekisi kuongororwa kusingakoshi kwemamiriro echokwadi echokwadi anotsanangurwa muWHERE clause inobviswa;
• Murairo ".parameter»zvebasa racho zvakabatanidzwa zvinotsiva (masiki anotsiviwa mune chero SQL mataurirwo). Mumurairo we ".archive", sarudzo ye "--update" yakagadziridzwa, iyo ikozvino inodarika mafaira asina kuchinjwa atova mudura, uye "--insert" sarudzo yakawedzerwa kuisa mafaira mudura;
• Kuwedzera kwakawedzerwa fossildelta.c, iyo inobvumira iwe kugadzira, kushandisa uye kuparadzanisa формат Fossil delta shanduko inoshandiswa muRBU yekuwedzera;
• Kuwedzera kuvimbika kwekushanda nemafaira edatabase akakuvadzwa;
• Girazi renzvimbo yekuchengetera chirongwa chakatangwa GitHub ( basic repository inotsigirwa uchishandisa vhezheni control chifusirwa, yakagadzirwa nemunyori weSQLite).

Source: opennet.ru