Ukukhishwa kwe-SQLite 3.36

Ukukhishwa kwe-SQLite 3.36, i-DBMS engasindi eklanywe njengomtapo wolwazi we-plug-in, kushicilelwe. Ikhodi ye-SQLite isatshalaliswa esizindeni somphakathi, i.e. ingasetshenziswa ngaphandle kwemikhawulo futhi mahhala nganoma iyiphi injongo. Usekelo lwezezimali lwabathuthukisi be-SQLite luhlinzekwa yinhlangano edalwe ngokukhethekile, ehlanganisa izinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley ne-Bloomberg.

Izinguquko eziyinhloko:

  • Okuphumayo komyalo we-CHAZA I-QUERY PLAN yenziwe kwaba lula ukuyiqonda.
  • Iqinisekisa ukuthi iphutha liyakhiqizwa uma uzama ukufinyelela umugqa ku-VIEW noma umbuzo ongaphansi. Ukuze ubuyisele ikhono lokufinyelela umugqa ukuze ubuke, inketho yokuhlanganisa β€œ-DSQLITE_ALLOW_ROWID_IN_VIEW” inikeziwe.
  • Ukuxhumana kwe-sqlite3_deserialize() kanye ne-sqlite3_serialize() kunikwe amandla ngokuzenzakalelayo. Ukuze ukhubaze, inketho yokuhlanganisa β€œ-DSQLITE_OMIT_DESERIALIZE” inikeziwe
  • I-VFS "memdb" ivumela ukwabelana kwesizindalwazi sememori ekuxhumaneni okuhlukene enqubweni efanayo inqobo nje uma igama lesizindalwazi liqala ngokuthi "/".
  • Ukulungiselelwa kwe-"EXISTS-to-IN" okwethulwe ekukhishweni kokugcina, okwehlise ijubane eminye imibuzo, kubuyiselwe emuva.
  • Ukuthuthukisa ukuhlanganisa ukuhlola njalo kuguqulelwe ukusebenza nemibuzo ngaphandle kokuhlanganisa (joyina).
  • Isandiso se-REGEXP sifakiwe ku-CLI.

Source: opennet.ru

Engeza amazwana