Qhov kev tso tawm ntawm SQLite 3.44, lub teeb DBMS tsim los ua lub tsev qiv ntawv plug-in, tau luam tawm. SQLite code yog muab faib ua pej xeem sau, i.e. tuaj yeem siv yam tsis muaj kev txwv thiab pub dawb rau txhua lub hom phiaj. Kev txhawb nqa nyiaj txiag rau SQLite cov neeg tsim khoom yog muab los ntawm cov koom haum tsim tshwj xeeb, uas suav nrog cov tuam txhab xws li Bentley, Bloomberg, Expensify thiab Navigation Data Standard.
Cov kev hloov loj:
- Kev ua haujlwm sib sau tso cai rau "YOG BY" kab lus tom qab qhov kawg tsis ua haujlwm cov lus sib cav hauv qhov kev txiav txim tau teev tseg, uas tuaj yeem pab tau rau cov haujlwm xws li string_agg() thiab json_group_array().
- Ntxiv kev txhawb nqa rau scalar SQL functions concat() thiab concat_ws(), sib xws nrog PostgreSQL, MS SQL Server thiab MySQL.
- Ntxiv kev txhawb nqa rau string_agg() aggregate muaj nuj nqi, sib xws nrog PostgreSQL thiab MS SQL Server.
- Ntxiv kev txhawb nqa rau cov specifiers “%e”, “% F”, “% I”, “%k”, “%l”, “%p”, “%P”, “%R” rau SQL muaj nuj nqi strftime( ) "%T" thiab "%u".
- Ntau qhov yuam kev cuam tshuam nrog CREATE TABLE nqe lus tam sim no tau tso tawm tom qab CREATE TABLE nqe lus raug tua, tsis yog tom qab lub rooj siv thawj zaug.
- Cov lus txib "PRAGMA integrity_check" siv los tshuaj xyuas qhov sib xws ntawm cov ntsiab lus ntawm ntau lub rooj virtual built-in siv hauv FTS3, FTS4, FTS5, RTREE thiab GEOPOLY txuas ntxiv.
- Built-in virtual tables siv nyob rau hauv FTS3, FTS4, FTS5, RTREE thiab GEOPOLY extensions raug tso cai siv rau hauv kev ua.
- Thaum qhia txog qhov teeb tsa SQLITE_DBCONFIG_DEFENSIVE, kev tiv thaiv yog muab los ntawm kev ua kom "PRAGMA writable_schema" hom.
- Thaum muab tso ua ke nrog Microsoft C compiler, SQLITE_USE_SEH (Structured Exception Handling) teeb tsa tau qhib los ntawm lub neej ntawd.
- Optimizations tau ua rau cov lus nug npaj muaj feem cuam tshuam nrog ib feem kev ntsuas ntsuas thaum qhia tus nqi tas li rau kab lus nyob rau hauv WHERE clause. Vim muaj kev txheeb xyuas qhov kev rov qab los, qhov pom kev ua kom zoo dua ntxiv hauv version 3.42.0 tau raug kaw.
- Muab lub sijhawm ua haujlwm pov thawj ntawm kev txhawb nqa rau hom "ntev ob npaug" nrog qhov tseeb siab dua li ntawm hom "ob npaug".
- Nyob rau hauv lub qhov rais hais kom ua interface, UTF-8 encoding yog enabled los ntawm lub neej ntawd rau input thiab tso zis (qhov "--tsis-utf8" kev xaiv yog muab los lov tes taw nws).
Tau qhov twg los: opennet.ru