An buga sakin SQLite 3.35, 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:
- Ƙara ginanniyar ayyukan lissafi (log2(), cos(), tg(), exp(), ln(), pow(), da sauransu) waɗanda za a iya amfani da su a cikin SQL. Kunna ayyukan ginanniyar yana buƙatar gini tare da zaɓin "-DSQLITE_ENABLE_MATH_FUNCTIONS".
- An aiwatar da goyan bayan "ALTER TABLE DROP COLUMN" don cire ginshiƙai daga tebur da share bayanan da aka adana a baya a cikin wani shafi da aka bayar.
- An faɗaɗa aiwatar da aikin UPSERT (ƙara-ko-gyara), yana ba da damar ta hanyar maganganu kamar "SAKA ... ON RIKICIN KADA KA YI KOMAI / UPDATE" don watsi da kuskure ko yin sabuntawa maimakon sakawa idan ba zai yiwu a ƙara ba. bayanai ta hanyar "INSERT" (misali, idan rikodin ya riga ya wanzu, maimakon INSERT za ku iya yin UPDATE). Sabuwar sigar tana ba ku damar tantance ɓangarorin ARZIKI da yawa, waɗanda za a sarrafa su cikin tsari. Katange "ON RASHIN TSORO" na ƙarshe yana ba da damar barin ma'anar ma'anar rikici don amfani da "KA UPDATE".
- Ayyukan DELETE, INSERT, da UPDATE suna goyan bayan furcin MAYARWA, wanda za a iya amfani da shi don nuna abubuwan da ke cikin rikodin da aka goge, shigar, ko gyara. Misali, kalmar "saka cikin ... id na dawowa" zai dawo da mai gano layin da aka ƙara, kuma "sabuntawa ... saita farashin = farashin * 1.10 farashin dawowa" zai dawo da ƙimar farashin da aka canza.
- Don Maganganun Tebu gama gari (CTE), waɗanda ke ba da izinin amfani da saitin sakamako mai suna na wucin gadi da aka ƙayyade ta amfani da bayanin WITH, zaɓin hanyoyin “MATERIALIZED” da “BA KYAUTA” an yarda da su. "MATERIALIZED" yana nufin caching tambayar da aka kayyade a cikin ra'ayi a cikin wani tebur na zahiri na daban sannan a kwaso bayanai daga wannan tebur, kuma tare da "BA'A MATERIALIZED" maimaita tambayoyin za'a yi duk lokacin da aka sami damar gani. SQLite da farko an ƙirƙira shi zuwa "BA KYAUTA BA", amma yanzu ya canza zuwa "MATERIALIZED" don CTEs da aka yi amfani da su fiye da sau ɗaya.
- Rage yawan amfani da ƙwaƙwalwar ajiya lokacin yin aikin VACUUM akan ma'ajin bayanai waɗanda suka haɗa da ƙimar TEXT ko BLOB manya sosai.
- An yi aiki don haɓaka aikin ingantawa da mai tsara tambaya:
- Ƙara ingantawa lokacin amfani da ayyukan min da max tare da kalmar "IN".
- An hanzarta aiwatar da sanarwar EXISTS.
- Aiwatar da faɗaɗa ƙararraki daga UNION DUK maganganun da aka yi amfani da su azaman ɓangare na JOIN.
- Ana amfani da fihirisar don baƙar magana.
- Yana tabbatar da cewa "x IS NULL" da "x BA BUTU BA" an canza su zuwa KARYA ko GASKIYA don ginshiƙan da ke da sifa "BA MATA BA".
- Tsallake duba maɓallan ƙasashen waje a cikin UPDATE idan aikin bai canza ginshiƙan da ke da alaƙa da maɓallin ketare ba.
- Ana ba da izinin matsar da sassan INA toshe zuwa cikin abubuwan da ke ɗauke da ayyukan taga, muddin waɗannan sassan sun iyakance ga aiki tare da kullun da kwafin maganganu daga PARTITION BY tubalan amfani da ayyukan taga.
- Canje-canje a cikin layin umarni:
- An ƙara umarnin ".filectrl data_version".
- Umarnin ". sau ɗaya" da ".fitarwa" yanzu suna goyan bayan ƙaddamar da fitarwa zuwa mai sarrafa da ake kira ta amfani da bututun da ba a bayyana sunansa ba ("|").
- An ƙara muhawarar "stmt" da "vmstep" zuwa umarnin ".stats" don nuna ƙididdiga akan maganganu da ƙididdiga na inji.
source: budenet.ru