Qhov kev tso tawm ntawm SQLite 3.38, lub teeb DBMS tsim los ua lub tsev qiv ntawv plug-in, tau luam tawm. SQLite code yog muab faib rau hauv 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.
Cov kev hloov loj:
- Ntxiv kev txhawb nqa rau -> thiab ->> cov neeg ua haujlwm kom yooj yim rau rho tawm cov ntaub ntawv hauv JSON hom. Tus neeg teb xov tooj tshiab syntax yog sib xws nrog MySQL thiab PostgreSQL.
- Cov qauv tseem ceeb suav nrog kev ua haujlwm rau kev ua haujlwm nrog cov ntaub ntawv hauv JSON, kev sib txuas uas yav dhau los xav tau kev sib dhos nrog "-DSQLITE_ENABLE_JSON1" chij. Txhawm rau kaw kev txhawb nqa JSON, tus chij "-DSQLITE_OMIT_JSON" tau ntxiv lawm.
- Ntxiv unixepoch() muaj nuj nqi uas rov qab lub sij hawm epochal (tus naj npawb ntawm vib nas this txij li lub Ib Hlis 1, 1970).
- Rau cov haujlwm uas ua haujlwm nrog lub sijhawm, "auto" thiab "julianday" modifiers tau ua tiav.
- Lub SQL muaj nuj nqi printf() tau renamed rau format() txhim kho compatibility nrog rau lwm yam DBMSs (txhawb rau lub qub lub npe yog khaws cia).
- Ntxiv qhov sqlite3_error_offset() interface kom nws yooj yim dua los nrhiav qhov yuam kev hauv cov lus nug.
- Cov kev pabcuam tshiab cuam tshuam tau ntxiv rau kev siv cov ntxhuav virtual: sqlite3_vtab_distinct(), sqlite3_vtab_rhs_value() thiab sqlite3_vtab_in(), nrog rau cov neeg teb xov tooj tshiab SQLITE_INDEX_CONSTRAINT_LIMIT thiab SQLITE_INDEX_CONSTRAINT_OFFSET.
- Cov kab hais kom ua interface ua kom raug tuav ntawm tab thiab kab noj cov cim hauv cov ntawv tso tawm hauv ntau hom kab. Ntxiv kev txhawb nqa rau kev siv "--wrap N", "--wordwrap on" thiab "-quote" kev xaiv thaum tso tawm rau ntau kab. Lub .import hais kom ua tso cai kho cov npe kab.
- Txhawm rau txhawm rau ua kom tiav cov lus nug loj analytic, cov lus nug npaj siv cov qauv tsim tawm los txiav txim seb puas muaj cov khoom nyob hauv ib txheej. Ib tsob ntoo sib koom ua ke yog siv los txhim kho kev ua haujlwm ntawm UNION thiab UNION TAG NRHO cov blocks hla SELECT nqe lus nrog ORDER BY clauses.
Tsis tas li ntawd, koj tuaj yeem nco ntsoov qhov kev tshaj tawm ntawm ib qho version ntawm sqlite-utils 3.24 teeb, uas suav nrog cov khoom siv hluav taws xob thiab lub tsev qiv ntawv rau kev siv cov ntaub ntawv los ntawm SQLite database. Kev ua haujlwm xws li kev thauj khoom ncaj qha ntawm JSON, CSV lossis TSV cov ntaub ntawv rau hauv cov ntaub ntawv database nrog kev tsim cov txheej txheem khaws cia tsim nyog, ua tiav cov lus nug SQL dhau CSV, TSV thiab JSON cov ntaub ntawv, nrhiav cov ntawv sau tag nrho hauv cov ntaub ntawv, cov ntaub ntawv hloov dua siab tshiab thiab khaws cov tswv yim. Hauv cov xwm txheej uas ALTER tsis siv tau raug txhawb nqa TABLE (piv txwv li, hloov hom kab), rho cov kab rau hauv cov rooj sib cais.
Tau qhov twg los: opennet.ru