ProHoster > Blog > internet nhau > Kuburitswa kweDBMS SQLite 3.30

Kuburitswa kweDBMS SQLite 3.30

rakabudiswa kusunungura SQLite 3.30.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:

  • Yakawedzera kugona kushandisa izwi rekuti "FILTERΒ»ine aggregate mabasa, izvo zvinoita kuti zvikwanise kudzikisira kufukidzwa kwedata rakagadziriswa neaggregate basa kune zvinyorwa chete zvinogutsa mamiriro akapihwa;
  • Iyo "ORDER BY" block inopa rutsigiro rwe "NULLS KUTANGA"Uye"NULLS ROKUPEDZISIRAΒ»kuona nzvimbo yezvinhu zvine kukosha kweNULL paunenge uchironga;
  • Murairo ".poraΒ»kudzoreredza zvirimo mumafaira akakuvadzwa kubva kudhatabhesi;
  • Mukuwedzera UBI rutsigiro rwakawedzerwa indexing kutaura;
  • PRAGMA index_info uye PRAGMA index_xinfo yakawedzerwa kuti ipe ruzivo pamusoro pekuchengetedza marongero ematafura akagadzirwa mu "VASISINA ROWID" modhi;
  • Yakawedzerwa API sqlite3_drop_modules(), iyo inobvumidza iwe kurambidza otomatiki kurodha kwematafura chaiwo kubva pachishandiso;
  • Iyo database schema parser yakashandurwa kuratidza chikanganiso kana mhando, zita, uye tbl_name makoramu musqlite_master tafura yakuvadzwa kana yakabatana isiri muwritable_schema modhi;
  • Iyo PRAGMA function_list, PRAGMA module_list uye PRAGMA pragma_list mirairo inogoneswa nekusarudzika. Kuti uchinje maitiro ekuvaka ekutanga, unofanirwa kujekesa "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS";
  • Pamashandisirwo-anotsanangurwa SQL mabasa, iyo SQLITE_DIRECTONLY mureza inokurudzirwa, iyo inobvumidza iwe kurambidza kushandiswa kweaya mabasa mukati mezvinokonzeresa uye maonero.

Source: opennet.ru

Voeg