Sakin DBMS SQLite 3.30.0

An saki DBMS SQLite 3.30.0. SQLite ƙaƙƙarfan DBMS ne. An canja wurin lambar tushe na ɗakin karatu zuwa yankin jama'a.

Menene sabo a cikin 3.30.0:

  • ya kara da ikon yin amfani da kalmar "FILTER" tare da ayyuka masu tarawa, wanda ya ba da damar iyakance ɗaukar bayanan da aka sarrafa ta hanyar yin rikodin kawai bisa ga yanayin da aka ba;
  • a cikin toshe “ORDER BY”, ana ba da tallafi don tutocin “NULLS FIRST” da “NULLS LAST” don tantance wurin abubuwan da ke da ƙimar NULL yayin da ake rarrabawa;
  • ya kara da umarnin ".warkewa" don mayar da abubuwan da ke cikin fayilolin da suka lalace daga ma'ajin bayanai;
  • 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 sqlite3_drop_modules () an ƙara don ba da damar yin amfani da tebur ta atomatik don kashewa;
  • umarnin PRAGMA function_list, PRAGMA module_list da PRAGMA pragma_list ana kunna su ta tsohuwa;
  • An gabatar da tutar SQLITE_DIRECTONLY, wanda ke ba ka damar hana amfani da ayyukan SQL a cikin abubuwan da ke haifar da ra'ayi;
  • Zaɓin gadon SQLITE_ENABLE_STAT3 baya samuwa.

source: linux.org.ru

Add a comment