Siideynta DBMS SQLite 3.30.0

SQLite 3.30.0 DBMS waa la sii daayay. SQLite waa DBMS is haysta. Koodhka isha maktabadda ayaa loo wareejiyay magaca dadweynaha.

Maxaa ku cusub nooca 3.30.0:

  • ku daray awoodda isticmaalka "FILTER" odhaahda oo leh hawlo wadareedka, taas oo suurtogal ka dhigtay in la xaddido daboolida xogta ay farsamayso shaqadu kaliya diiwaanada xaalad la bixiyay;
  • blockka "AMAR BY" wuxuu taageero siiya calamada "NULLS FIRST" iyo "NULLS LAST" si loo go'aamiyo meesha ay ku yaalaan walxaha leh qiimaha NULL marka la kala saarayo;
  • lagu daray ".kabashada" amarka si loo soo celiyo waxa ku jira faylasha dhaawacan ee kaydka;
  • PRAGMA index_info iyo PRAGMA index_xinfo ayaa la kordhiyey si ay u bixiyaan macluumaadka ku saabsan qaabka kaydinta miisaska loo abuuray iyada oo aan qaabka ROWID;
  • lagu daray sqlite3_drop_modules() API si loo joojiyo rarka tooska ah ee miisaska farsamada;
  • PRAGMA function_list, PRAGMA module_list iyo PRAGMA pragma_list amarrada waxaa loo hawlgeliyay si default;
  • calanka SQLITE_DIRECTONLY ayaa la soo bandhigay, kaas oo kuu ogolaanaya inaad mamnuucdo isticmaalka hawlaha SQL ee gudaha kiciya iyo aragtida;
  • ikhtiyaarka la joojiyay SQLITE_ENABLE_STAT3 hadda lama heli karo.

Source: linux.org.ru

Add a comment