Kutulutsidwa kwa DBMS SQLite 3.30.0

Kutulutsidwa kwa DBMS SQLite 3.30.0 kunachitika. SQLite ndi DBMS yophatikizidwa. Khodi yochokera ku laibulale yasamutsidwa public domain.

Zatsopano mu mtundu 3.30.0:

  • adawonjezera kuthekera kogwiritsa ntchito mawu oti "FILTER" ndi ntchito zophatikizika, zomwe zidapangitsa kuti zitheke kuchepetsa kubisala kwa data yomwe idakonzedwa ndi ntchitoyi kuti ikhale marekodi okha kutengera momwe adapatsidwa;
  • mu chipika cha "ORDER BY", chithandizo chimaperekedwa kwa mbendera za "NULLS FIRST" ndi "NULLS LAST" kuti mudziwe malo a zinthu zomwe zili ndi mtengo wa NULL posankha;
  • anawonjezera lamulo la ".recover" kuti abwezeretse zomwe zili m'mafayilo owonongeka kuchokera ku database;
  • PRAGMA index_info ndi PRAGMA index_xinfo awonjezedwa kuti apereke zambiri za masanjidwe osungira a matebulo opangidwa mu "POPANDA ROWID" mode;
  • API sqlite3_drop_modules() yawonjezedwa kuti kulola kutsitsa kwamatebulo enieni kuzimitsidwa;
  • malamulo PRAGMA function_list, PRAGMA module_list ndi PRAGMA pragma_list imayendetsedwa mwachisawawa;
  • mbendera ya SQLITE_DIRECTONLY yayambitsidwa, yomwe imakulolani kuletsa kugwiritsa ntchito ntchito za SQL mkati mwa zoyambitsa ndi mawonedwe;
  • Njira ya cholowa SQLITE_ENABLE_STAT3 palibenso.

Source: linux.org.ru

Kuwonjezera ndemanga