ProHoster > Blog > internet nhau > SQLite 3.35 kuburitswa

SQLite 3.35 kuburitswa

Kuburitswa kweSQLite 3.35, isingaremi DBMS yakagadzirwa senge plug-in raibhurari, yakaburitswa. Iyo SQLite kodhi inogoverwa munharaunda yeruzhinji, i.e. inogona kushandiswa pasina zvirambidzo uye pasina muripo kune chero chinangwa. Rutsigiro rwemari rwevagadziri veSQLite rwunopihwa nemubatanidzwa wakanyatsogadzirwa, unosanganisira makambani akadai seAdobe, Oracle, Mozilla, Bentley neBloomberg.

Shanduko huru:

  • Akawedzera akavakirwa-mukati masvomhu mabasa (log2(), cos(), tg(), exp(), ln(), pow(), nezvimwewo) anogona kushandiswa muSQL. Kugonesa mabasa akavakirwa mukati kunoda kuvaka ne "-DSQLITE_ENABLE_MATH_FUNCTIONS" sarudzo.
  • Yakaitwa tsigiro ye "ALTER TABLE DROP COLUMN" kutaura kubvisa makoramu patafura uye kujekesa data yakambochengetwa mukoramu yakapihwa.
  • Kuitwa kweUPSERT (add-or-modify) operation kwakawedzerwa, zvichibvumira kuburikidza nekutaura sekuti β€œINSERT ... PAKUKANGANANA USAITA CHINHU/UPDATE” kufuratira chikanganiso kana kuita update pachinzvimbo chekuisa kana zvisingaite kuwedzera. data kuburikidza ne "INSERT" (somuenzaniso, kana rekodhi yatovepo, Unogona kuita UPDATE pachinzvimbo che INSERT). Iyo itsva vhezheni inokubvumira kuti utaure akawanda ON CONFLICT blocks, ayo anozogadziriswa akarongeka. Yekupedzisira "ON CONFLICT" block inobvumira iyo gakava yekumisa parameter kuti isiiwe kuitira kushandisa "ITA UPDATE".
  • Iyo DELETE, INSERT, uye UPDATE mashandiro anotsigira iyo RETURNING kutaura, iyo inogona kushandiswa kuratidza zviri mukati meyakadzimwa, yakaiswa, kana yakagadziridzwa rekodhi. Semuenzaniso, chirevo chekuti "isa mu ... kudzorera id" ichadzorera chiziviso chemutsara wakawedzerwa, uye "update ... set price = mutengo * 1.10 kudzorera mutengo" ichadzorera mutengo wakashandurwa.
  • KuCommon Table Expressions (CTE), iyo inobvumira kushandiswa kwemaseti enguva pfupi ane mazita akataurwa uchishandisa WITH chirevo, sarudzo ye "MATERIALIZED" uye "NOT MATERIALIZED" modes inobvumirwa. β€œMATERIALIZED” zvinoreva kuchengeta muvhunzo watsanangurwa mukuona mune imwe tafura yenyama wobva watora data kubva patafura iyi, uye ne”NOT MATERIALIZED” mivhunzo inodzokororwa ichaitwa pese panoonekwa. SQLite pakutanga yaive neiyo default mode "NOT MATERIALIZED", asi ikozvino yachinja kuita "MATERIALIZED" yeCTEs yakashandiswa kanopfuura kamwe.
  • Yakaderedzwa ndangariro kushandiswa paunenge uchiita VACUUM oparesheni pane dhatabhesi inosanganisira yakakura kwazvo TEKSTO kana BLOB kukosha.
  • Basa rakaitwa kuti riwedzere kuita kwe optimizer uye query planner:
    • Yakawedzerwa optimizations kana uchishandisa iyo min uye max mabasa ane "IN" kutaura.
    • Kuitwa kwechirevo che EXISTS kwave nekukasira.
    • Yakaitwa yekuwedzera ye subqueries kubva kuUNION YESE mataurirwo anoshandiswa sechikamu cheJOIN.
    • Indekisi inoshandiswa kureva IS NOT NULL mataurirwo.
    • Inova nechokwadi chekuti "x IS NULL" uye "x IS NOT NULL" inoshandurwa kuita FALSE kana CHOKWADI kumakoramu ane "NOT NULL" hunhu.
    • Svetuka kutarisa makiyi ekunze mune UPDATE kana oparesheni ikasachinja makoramu ane chekuita nekiyi yekunze.
    • Inotenderwa kufambisa zvikamu zveWHERE block kuita subqueries ine mahwindo mabasa, chero izvo zvikamu zvinogumira pakushanda nemaconstants uye makopi ezvekutaura kubva kuPARTITION BY mabhuroko anoshandiswa mumahwindo mabasa.
  • Shanduko mune yekuraira mutsara interface:
    • Yakawedzerwa ".filectrl data_version" murairo.
    • Mitemo ye ".once" uye ".output" ikozvino inotsigira kupfuudza kuburitsa kune mubato anodaidzwa kushandisa mapaipi asina zita ("|").
    • Mapoka e "stmt" uye "vmstep" awedzerwa kumurairo we ".stats" kuratidza nhamba dzemashoko uye makaunda emuchina chaiwo.

Source: opennet.ru

Voeg