Fa'asa'olotoina ole DBMS SQLite 3.31 fa'atasi ma le lagolago mo koluma fa'atupuina

lomia faasalalau tatala SQLite 3.31.0, o se DBMS mama ua mamanuina e fai ma faletusi faʻapipiʻi. O le SQLite code o loʻo tufatufa atu o se faʻalapotopotoga lautele, i.e. e mafai ona fa'aoga e aunoa ma ni tapula'a ma e leai se totogi mo so'o se fa'amoemoe. Lagolago tau tupe mo SQLite atiaʻe e tuʻuina atu e se faʻasalalauga faʻapitoa, lea e aofia ai kamupani e pei o Adobe, Oracle, Mozilla, Bentley ma Bloomberg.

tele suiga:

• Faaopoopo lagolago koluma gaosia (koluma fuafuaina), lea e mafai ai ona e faʻamalamalamaina se koluma pe a e fatuina se laulau e otometi lava ona fuafuaina lona tau e faʻatatau i mea o loʻo i totonu o le isi koluma. O koluma fa'atupuina e mafai ona fa'ata'atia (fausia i luga o le lele ma avanoa ta'itasi) pe teu i totonu o fa'amaumauga (fa'asaoina i taimi uma e fa'afou ai koluma e feso'ota'i). O mea o lo'o i totonu o koluma fa'atupuina e maua na'o le faitau faitau (suiga e na'o le suiga o le tau i se isi koluma o lo'o a'afia i le fa'atatauga). Faataitaiga:

  FAITAU LAVA t1(
  a INTEGER PIMARY KI,
  e INT,
  i TEXT,
  d INT GENERATE PEA E FAI (a*abs(b)) VIRTUAL,
  u TUSI E FAIA PEA (substr(c,b,b+1)) TEU.
  );

• Faaopoopo PRAGMA trusted_schema, faatulagaga SQLITE_DBCONFIG_TRUSTED_SCHEMA ma le filifiliga faʻapotopotoga "-DSQLITE_TRUSTED_SCHEMA", lea e faʻatagaina oe e pulea le aofia ai o le puipuiga mai osofa'iga e ala i le suiga o le fa'asologa o fa'amaumauga i totonu o fa'amaumauga. O le puipuiga malosi e fa'agata ai le fa'aogaina o galuega SQL (e le'o fa'ailoga SQLITE_INNOCUOUS) i fa'aoso, va'aiga, CHECK ma DEFAULT fa'amatalaga, fa'asino igoa, ma koluma gaosia. O le fa'aogaina o laulau fa'ata'ita'i i fa'aoso ma va'aiga e fa'aletonu fo'i se'i vagana ua fa'ailoa manino mai le laulau fa'ata'ita'i ma le fu'a SQLITE_VTAB_INNOCUOUS.
• Faʻatinoina le gafatia e tuʻuina atu meatotino i galuega SQL faʻamatalaina i talosaga SQLITE_INNOCUOUS (gaioiga le afaina e le faʻalagolago i faʻamaufaʻailoga fafo ma e le mafai ona faʻaaogaina e fai ai gaioiga leaga) ma SQLITE_DIRECTONLY (naʻo le valaʻau tuusaʻo i fesili SQL, e aunoa ma le avanoa e faʻaaogaina i faʻaoso, vaaiga ma faʻasologa o faʻamaumauga);
• Fa'aopoopo module uuid faʻatasi ai ma le faʻatinoina o galuega mo le faʻaogaina o le UUID (RFC-4122);
• Faaopoopo PRAGMA hard_heap_limit ma faʻagaioiga sqlite3_hard_heap_limit64() ia pulea le tele o faupu'ega;
• I le PRAGMA galuega_lisi fa'aopoopoina galuega faatino o le ituaiga, meatotino ma le numera o finauga o galuega taitasi;
• I luga o le laulau fa'ata'ita'i DBSTAT faʻaopoopo faiga fa'aopoopo fa'amaumauga;
• sqlite3_open_v2() faʻaaogaina le SQLITE_OPEN_NOFOLLOW filifiliga, lea e mafai ai ona e faʻamalo le tatalaina o fesoʻotaʻiga faʻatusa;
• Mo finauga PATH, pasi atu i galuega a le JSON, faʻaopoopo le lagolago mo le faʻasologa o faʻamatalaga "#-N";
• I le faiga o le tufatufaina o manatua va'ava'ai lagolago mo vaituloto eseese e lua ua faʻatinoina, e mafai ona faʻaogaina ia mea taʻitasi e tuʻufaʻatasia poloka o lapopoa eseese (vavaeeseina e mafai ai ona e faʻalauteleina le faʻaogaina o le vaʻavaʻai, aʻo faʻaititia le tele o le paʻu ua tuʻuina atu i soʻotaga taʻitasi mai le 120 i le 48 KB);
• Ua taofia le lagolago a le PRAGMA legacy_file_format, lea e le fetaui ma VACUUM, koluma fa'atupuina, ma fa'asolo i lalo (e mafai ona toe fa'afo'i le lagolago fa'asologa o talatuu e ala i le fu'a SQLITE_DBCONFIG_LEGACY_FILE_FORMAT i le sqlite3_db_config()).

puna: opennet.ru