Sakin DBMS SQLite 3.30

aka buga saki SQLite 3.30.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:

• Ƙara ikon yin amfani da furcin "tace»tare da ayyukan tarawa, wanda ke ba da damar iyakance ɗaukar bayanan da aka sarrafa ta aikin tarawa zuwa kawai bayanan da suka gamsar da yanayin da aka bayar;
• Tushen "ORDER BY" yana ba da tallafi ga "NULLS FARKO"Kuma"NULLS KARSHE» don ƙayyade wurin abubuwan da ke da ƙimar NULL yayin rarrabawa;
• Umurnin".murmurewa» don maido da abubuwan da suka lalace daga rumbun adana bayanai;
• A fadada UBI goyon baya kara indexing maganganu;
• An tsawaita PRAGMA index_info da PRAGMA index_xinfo don samar da bayanai game da tsarin ajiya na tebur da aka kirkira a cikin yanayin "BA TARE DA ROWID" ba;
• API ɗin da aka ƙara sqlite3_drop_modules(), wanda ke ba ku damar hana ɗaukar nauyin tebur na atomatik daga aikace-aikacen;
• An canza fasalin tsarin bayanai don nuna kuskure lokacin da nau'in, suna, da ginshiƙan tbl_name a cikin tebur na sqlite_master suka lalace lokacin da aka haɗa ba cikin yanayin rubutu ba;
• Lissafin aikin PRAGMA, PRAGMA module_list da umarnin PRAGMA pragma_list ana kunna su ta tsohuwa. Don canza dabi'ar ginawa ta asali, dole ne ku saka a sarari "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS";
• Don ƙayyadaddun ayyukan SQL na aikace-aikacen, ana ba da shawarar tutar SQLITE_DIRECTONLY, wanda ke ba ku damar hana amfani da waɗannan ayyukan a cikin abubuwan jan hankali da ra'ayoyi.

source: budenet.ru