SQLite 3.35 saki an buga kuma a cikin wannan sabon sakin wannan manajan bayanan Karin haske akan aikin lissafi, kazalika da tallafi ga kalmar ALTER TABLE DROP COLUMN don sauke ginshiƙai daga tebur, ingantattun ayyuka, da ƙari.
Ga waɗanda ba su saba da kunshin SQLite ba DBMS ne mara nauyi, an tsara shi azaman ɗakin karatu na plugin. Lambar SQLite an rarraba azaman yankin jama'a, ma'ana, ana iya amfani dashi ba tare da takurawa ba kuma kyauta ga kowane dalili.
Babban sabon fasali na SQLite 3.35
Kamar yadda aka ambata a farkon, a cikin wannan sabon sigar ginannen ayyukan lissafi (log2 (), cos (), tg (), exp (), ln (), pow (), da sauransu)) ana iya amfani da shi a cikin SQL. Don ba da damar ayyukan ginannen, ana buƙatar taro tare da zaɓi "-DSQLITE_ENABLE_MATH_FUNCTIONS".
Bayanan "ALTER TABLE DROP COLUMN" yanzu yana goyan bayan sauke ginshiƙai daga tebur da kuma share bayanan da aka adana a wannan rukunin.
Aiwatar da aikin UPSERT (addara ko gyara), wanda zai baka damar amfani da maganganu kamar "INSERT ON RIGIMING BA KOME BA / GABATARWA" don watsi da kuskure ko aiwatar da ɗaukakawa maimakon sanyawa idan ba zai yuwu ba a ƙara bayanai ta hanyar "Saka" (misali, idan rikodin, Za a iya sabuntawa maimakon Saka).
A cikin sabon sigar, an ba shi izinin tantance tubalan da yawa «A CIGABA«, Wanne za a sarrafa shi cikin tsari. A cikin toshe na "ON RIGIMA" na ƙarshe, an ba da izinin kada a ayyana ma'anar ma'anar rikice-rikice don amfani da "KARANTA YANZU".
Ayyukan SAMU, INSERT da kuma UPDATE suna goyon bayan maido dawowar, ana iya amfani da hakan don nuna abun cikin rikodin da aka share, wanda aka saka, ko aka gyara. Misali, "saka cikin ... ID na dawowa" zai dawo da wanda aka kara mai ganowa, kuma "sabuntawa ... saita farashi = farashin * farashin dawowa 1.10" zai dawo da kimar farashin da aka sabunta.
Don cikakkun maganganun tebur (Bayyanannen Magana na Cable, CTE), wanda ke ba da damar amfani da jerin sakamakon sakamako mai suna, ta amfani da TAMBAYA ga mai aiki, yarda da zaɓin yanayin «MATERIALIZED» da «NOT MATERIALIZED».
- "MATerially" na nufin adana tambayar da aka kayyade a cikin ra'ayi a cikin tebur na zahiri daban tare da dawo da bayanai daga wannan tebur.
- Kuma tare da "BA KYAUTA", za a yi maimaita tambayoyin duk lokacin da aka sami damar ganin ra'ayi. Da farko, SQLite ya karkata zuwa "BA MATERIALIZED" amma yanzu an canza shi zuwa "MATERIALIZED" don ana amfani da CTEs fiye da sau ɗaya.
Na sauran canje-canje wanda ya fice daga wannan sabon sigar:
- Rage amfani da ƙwaƙwalwar ajiya yayin aiwatar da ayyukan VACUUM don ɗakunan bayanai waɗanda suka haɗa da manyan ƙimomi tare da nau'in TEXT ko BLOB.
- An yi aiki don haɓaka aikin mai haɓakawa da mai tsara tambaya.
- An ƙara haɓaka yayin amfani da ƙaramin aiki da max tare da kalmar "IN".
- Zartar da bayanan EXISS da sauri.
- An ƙaddamar da faɗaɗa ƙananan thean Majalisar Dinkin Duniya DUK maganganun da aka yi amfani da su a cikin KASHE.
- Fihirisar da aka yi amfani da ita ba KYAUTA ba ce.
- Canza "x BA NULL bane" da "x BA NULL BA" zuwa KARYA ko GASKIYA an samar da shi don ginshiƙai tare da alamar "BA NULL BA"
- Duba maɓallin waje waje a cikin UPDATE an tsallake idan aikin bai canza ginshiƙan da ke hade da maɓallin waje ba.
- Ana ba da izinin matsar da sassan INGANTA zuwa ƙananan lamuran da ke ɗauke da ayyukan taga idan waɗannan sassan sun iyakance ga aiki tare da mahimman bayanai da kuma kwafin "SASHE NA BY" kalmomin da aka yi amfani da su a ayyukan taga.
Canje-canje ga layin layin umarni:
- Ara umarnin ".filectrl data_version".
- Umurnin ".once" da ".output" sun ƙara goyan baya don tura fitarwa ga mai kira da aka yi amfani da bututun da ba a ambata sunan su ba ("|").
- Umurnin ".stats" ya ƙara muhawara ta "stmt" da "vmstep" don nuna ƙididdiga akan ƙididdigar injunan kamala da maganganu.
Finalmente idan kuna sha'awar ƙarin sani game da shi game da wannan sabon sigar na SQLite, zaku iya bincika cikakkun bayanai ta hanyar zuwa mahaɗin mai zuwa.