Kuburitswa kweDBMS SQLite 3.30.0

Kuburitswa kweDBMS SQLite 3.30.0 kwakaitika. SQLite ndeye compact yakamisikidzwa DBMS. Kodhi yekwakabva raibhurari yaendeswa kune public domain.

Chii chitsva mushanduro 3.30.0:

  • yakawedzera kugona kushandisa iyo "FILTER" kutaura neaggregate mabasa, izvo zvakaita kuti zvikwanise kudzikamisa kuvharwa kwedata rakagadziriswa nebasa kune marekodhi chete zvichienderana nemamiriro akapihwa;
  • mu "ORDER BY" block, rubatsiro runopiwa kune "NULLS FIRST" uye "NULLS LAST" mireza kuti ione nzvimbo yezvinhu zvine NULL kukosha pakusarudza;
  • akawedzera ".recover" murairo kuti udzorere zvinyorwa zvemafaira akakuvadzwa kubva kune database;
  • PRAGMA index_info uye PRAGMA index_xinfo yakawedzerwa kuti ipe ruzivo pamusoro pekuchengetedza marongero ematafura akagadzirwa mu "VASISINA ROWID" modhi;
  • API sqlite3_drop_modules() yakawedzerwa kuti ibvumire kurodha otomatiki kwematafura chaiwo kuvharwa;
  • iyo mirairo PRAGMA function_list, PRAGMA module_list uye PRAGMA pragma_list inogadziriswa nekukasira;
  • iyo SQLITE_DIRECTONLY mureza yakaunzwa, iyo inobvumidza iwe kurambidza kushandiswa kweSQL mabasa mukati mezvinokonzeresa uye maonero;
  • Iyo legacy sarudzo SQLITE_ENABLE_STAT3 haichawanikwi.

Source: linux.org.ru

Voeg