An buga sakin SQLite 3.40, 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:
- An aiwatar da fasalin gwaji don haɗa SQLite zuwa lambar tsaka-tsakin WebAssembly, mai iya aiki a cikin mai binciken gidan yanar gizo kuma ya dace da tsara aiki tare da bayanan bayanai daga aikace-aikacen yanar gizo a cikin JavaScript. Ana ba da masu haɓaka gidan yanar gizo tare da babban matakin abin da ke da alaƙa don yin aiki tare da bayanai a cikin salon sql.js ko Node.js, ɗaure kan ƙaramin matakin C API da API dangane da tsarin Ma'aikacin Yanar gizo, wanda ke ba da izini. ka ƙirƙiri masu sarrafa asynchronous da aka kashe a zaren daban. Bayanan da aikace-aikacen yanar gizo ke adanawa a cikin nau'in WASM na SQLite za a iya adana su a gefen abokin ciniki ta amfani da OPFS (Asali-Private FileSystem) ko taga.localStorage API.
- Ƙara tsawo na farfadowa, ƙirƙira don maido da bayanai daga lalace fayiloli daga database. A cikin layin umarni, ana amfani da umarnin ".warkewa" don dawowa.
- Inganta aikin mai tsara tambaya. An cire ƙuntatawa lokacin amfani da fihirisa tare da teburi masu sama da ginshiƙai 63 (a da, ba a yi amfani da fihirisa ba lokacin da ake gudanar da ginshiƙan waɗanda adadinsu ya wuce 63). Ingantattun firikwensin da aka yi amfani da su a cikin maganganu. An dakatar da loda manyan igiyoyi da tsummoki daga diski lokacin sarrafa masu sarrafa NOT NULL da IS NULL. An cire kayan aikin ra'ayi wanda aka yi cikakken bincike sau ɗaya kawai.
- A cikin codebase, maimakon nau'in "char *", ana amfani da nau'in sqlite3_filename daban don wakiltar sunayen fayil.
- Ƙara aikin ciki sqlite3_value_encoding().
- An ƙara yanayin SQLITE_DBCONFIG_DEFENSIVE, wanda ke hana canza sigar ma'ajiyar bayanai.
- An ƙara ƙarin bincike don aiwatar da sigar "PRAGMA integrity_check". Misali, teburi ba tare da sifa STRICT ba dole ne ya ƙunshi ƙimar lambobi a cikin ginshiƙan nau'in TEXT da ƙimar kirtani tare da lambobi a cikin ginshiƙan nau'in NUMERIC. Har ila yau, an ƙara shi ne bincika madaidaicin tsarin layuka a cikin tebur tare da sifa "BA TARE DA ROWID".
- Maganar "VACUUM INTO" tana la'akari da saitunan "PRAGMA synchronous".
- Ƙara zaɓin taro SQLITE_MAX_ALLOCATION_SIZE, wanda ke ba ku damar iyakance girman tubalan lokacin da ake rarraba ƙwaƙwalwar ajiya.
- SQLite's ginannen ƙirar ƙirƙira-bazuwar adadin ƙirƙira algorithm an motsa shi daga amfani da sifar rafin RC4 zuwa Chacha20.
- An ba da izinin yin amfani da fihirisa masu suna iri ɗaya a cikin tsare-tsaren bayanai daban-daban.
- An inganta haɓaka aiki don rage nauyin CPU da kusan 1% yayin aiki na yau da kullun.
source: budenet.ru