Ho lokolloa ha SQLite 3.36, DBMS e bobebe e entsoeng e le laebrari ea plug-in, e hatisitsoe. Khoutu ea SQLite e ajoa sebakeng sa sechaba, ke hore. e ka sebelisoa ntle le lithibelo le ntle ho tefo bakeng sa morero ofe kapa ofe. Tšehetso ea lichelete bakeng sa bahlahisi ba SQLite e fanoa ke consortium e entsoeng ka ho khetheha, e kenyelletsang lik'hamphani tse kang Adobe, Oracle, Mozilla, Bentley le Bloomberg.
Liphetoho tse kholo:
- Sephetho sa taelo ea EXPLAIN QUERY PLAN se nolofalitsoe ho utloisisoa.
- E netefatsa hore ho na le phoso ha u leka ho fumana marang-rang ka VIEW kapa subquery. Ho khutlisa bokhoni ba ho fihlella rowid bakeng sa lipono, khetho ea kopano "-DSQLITE_ALLOW_ROWID_IN_VIEW" e fanoe.
- Maqhubu a sqlite3_deserialize() le sqlite3_serialize() a lumelloa ka ho sa feleng. Ho tima, khetho ea kopano "-DSQLITE_OMIT_DESERIALIZE" e fanoe
- VFS "memdb" e lumella ho arolelana polokelong ea polokelo ea memori ho likhokahano tse fapaneng ts'ebetsong e ts'oanang ha feela lebitso la database le qala ka "/".
- Ntlafatso ea "EXISTS-to-IN" e hlahisitsoeng tokollong e fetileng, e fokolitseng lipotso tse ling, e khutlisitsoe morao.
- Ntlafatso ea ho kopanya tlhahlobo e sa khaotseng e fetotsoe ho sebetsa le lipotso ntle le ho kopanya (ho ikopanya).
- Katoloso ea REGEXP e kenyelelitsoe ho CLI.
Source: opennet.ru