Tso tawm DBMS SQLite 3.31 nrog kev txhawb nqa rau cov kab tsim tawm

luam tawm tso tawm SQLite 3.31.0, ib lub teeb DBMS tsim los ua lub tsev qiv ntawv plug-in. SQLite code yog faib raws li pej xeem sau, i.e. tuaj yeem siv yam tsis muaj kev txwv thiab pub dawb rau txhua lub hom phiaj. Kev them nyiaj yug rau SQLite developers yog muab los ntawm ib tug tshwj xeeb tsim consortium, uas muaj xws li cov tuam txhab xws li Adobe, Oracle, Mozilla, Bentley thiab Bloomberg.

ntsiab hloov:

• Ntxiv kev txhawb nqa tsim kab (xws li kab), uas tso cai rau koj los txhais ib kem thaum koj tsim ib lub rooj uas nws tus nqi raug txiav txim siab raws li cov ntsiab lus ntawm lwm kem. Cov kab tsim tawm tuaj yeem yog virtual (tsim tawm ntawm yoov nrog txhua qhov nkag) lossis khaws cia hauv cov ntaub ntawv (txuag txhua zaus cov kab sib txuas tau hloov kho). Cov ntsiab lus ntawm cov kab tsim tawm tsuas yog muaj nyob rau hauv hom nyeem (kev hloov pauv tsuas yog los ntawm kev hloov kho tus nqi hauv lwm kem koom nrog hauv kev suav). Piv txwv li:

  CREATE TABLE t1(
  ib tug INTEGER PRIMARY KEY,
  IB INT,
  c TEXT,
  d YUAV TSUM TAU TXAIS AS (a*abs(b)) VIRTUAL,
  e TEXT GENERATED AS (substr(c,b,b+1)) STORED
  );

• Ntxiv PRAGMA ntseeg_schema, kev teeb tsa SQLITE_DBCONFIG_TRUSTED_SCHEMA thiab kev xaiv los ua ke "-DSQLITE_TRUSTED_SCHEMA", uas tso cai rau koj los tswj kev suav nrog kev tiv thaiv kev tawm tsam los ntawm kev hloov kho cov ntaub ntawv schema hauv database. Kev tiv thaiv nquag txwv tsis pub siv SQL lub luag haujlwm (tsis cim SQLITE_INNOCUOUS) hauv kev tshwm sim, kev pom, CHECK thiab DEFAULT nqe lus, indexes, thiab cov kab tsim tawm. Kev siv cov ntxhuav virtual hauv kev ua kom pom thiab kev pom kuj tseem raug cuam tshuam tshwj tsis yog tias lub rooj virtual tau tshaj tawm meej meej nrog tus chij SQLITE_VTAB_INNOCUOUS.
• Siv lub peev xwm los muab cov khoom rau SQL kev ua haujlwm tau teev tseg hauv daim ntawv thov SQLITE_INNOCUOUS (kev ua haujlwm tsis raug mob uas tsis nyob ntawm qhov tsis zoo sab nraud thiab tsis tuaj yeem siv los ua qhov phem) thiab SQLITE_DIRECTONLY (tsuas yog hu ncaj qha rau hauv SQL queries, tsis muaj peev xwm siv hauv kev ua, kev xav thiab cov qauv duab kos duab);
• Ntxiv module UUID nrog rau kev ua haujlwm ntawm kev ua haujlwm UUID (RFC-4122);
• Ntxiv PRAGMA hard_heap_limit thiab muaj nuj nqi sqlite3_hard_heap_limit64() tswj qhov siab tshaj plaws heap loj;
• Hauv PRAGMA function_list ntxiv cov zis ntawm hom, khoom thiab tus naj npawb ntawm kev sib cav ntawm txhua txoj haujlwm;
• Rau virtual rooj DBSTAT ntxiv hom kev sib sau cov ntaub ntawv;
• sqlite3_open_v2() siv SQLITE_OPEN_NOFOLLOW kev xaiv, uas tso cai rau koj mus lov tes taw qhib cov cim txuas;
• Rau kev sib cav PATH, dhau mus rau JSON lub luag haujlwm, ntxiv kev txhawb nqa rau "#-N" array sau;
• Nyob rau hauv lub cim xeeb faib system saib kev them nyiaj yug rau ob lub cim xeeb sib cais tau ua tiav, txhua qhov tuaj yeem siv los faib cov blocks ntawm ntau qhov sib txawv (kev sib cais tso cai rau koj kom nthuav dav kev siv lub ntsej muag, thaum txo qhov loj ntawm qhov tsis faib rau txhua qhov kev sib txuas ntawm 120 txog 48. KB);
• Kev txhawb nqa PRAGMA tau raug txiav lawm legacy_file_format.

Tau qhov twg los: opennet.ru