An buga sakin SQLite 3.36, DBMS mai nauyi wanda aka tsara azaman ɗakin karatu na toshe, an buga shi. Ana rarraba lambar SQLite azaman yanki na jama'a, watau. ana iya amfani da shi ba tare da hani ba kuma kyauta don kowane dalili. Tallafin kuɗi na masu haɓaka SQLite yana samuwa ta hanyar haɗin gwiwa na musamman da aka ƙirƙira, wanda ya haɗa da kamfanoni kamar Adobe, Oracle, Mozilla, Bentley da Bloomberg.
Babban canje-canje:
- Fitowar umarni na EXPLAIN QUERY PLAN ya sami sauƙin fahimta.
- Yana tabbatar da cewa an haifar da kuskure lokacin ƙoƙarin samun dama ga layi a cikin VIEW ko subquery. Don dawo da ikon shiga layi don ra'ayoyi, an ba da zaɓin taron "-DSQLITE_ALLOW_ROWID_IN_VIEW"
- Sqlite3_deserialize() da sqlite3_serialize() musaya ana kunna su ta tsohuwa. Don kashe, an ba da zaɓin taron "-DSQLITE_OMIT_DESERIALIZE".
- VFS "memdb" yana ba da damar raba bayanan cikin ƙwaƙwalwar ajiya a cikin haɗe-haɗe daban-daban zuwa tsari ɗaya muddin sunan bayanan ya fara da "/".
- Haɓakawa na "EXISTS-to-IN" da aka gabatar a cikin sakin ƙarshe, wanda ya rage jinkirin wasu tambayoyin, an koma.
- An daidaita haɓakawa don haɗa dubawa akai-akai don aiki tare da tambayoyi ba tare da haɗawa ba (hanka).
- An haɗa haɓaka REGEXP a cikin CLI.
source: budenet.ru