Siideynta SQLite 3.40, DBMS khafiifa oo loogu talagalay sidii maktabad fur-in, ayaa la daabacay. Koodhka SQLite waxa lagu qaybiyaa qaybta dadweynaha, i.e. waxa loo isticmaali karaa xad la'aan iyo lacag la'aan ujeedo kasta. Taageerada maaliyadeed ee horumarinta SQLite waxaa bixiya isbahaysi si gaar ah loo abuuray, oo ay ku jiraan shirkado ay ka mid yihiin Adobe, Oracle, Mozilla, Bentley iyo Bloomberg.
Isbeddellada ugu waaweyn:
- Hirgeliyay awoodda tijaabada ah ee lagu ururin karo SQLite koodka WebAssembly dhexdhexaad ah kaas oo ku shaqeyn kara biraawsarkaaga wuxuuna ku habboon yahay abaabulka shaqada xogta macluumaadka ee codsiyada webka ee luqadda JavaScript. Soosaarayaasha shabakadaha waxaa la siiyaa interface heer sare ah oo ku jihaysan shayga si ay ugula shaqeeyaan xogta qaabka sql.js ama Node.js, ku duubida heerka hoose ee C API, iyo API ku salaysan habka Shaqeeyaha Shabakadda ee kuu ogolaanaya si loo abuuro gacan-ku-hayayaal asynchronous ah oo ku shaqeeya dunta kala duwan. Xogta ay arjiyada shabakadu ku kaydiyaan nooca WASM ee SQLite waxa lagu kaydin karaa dhinaca macmiilka iyadoo la isticmaalayo OPFS (Asal-Private FileSystem) ama window.localStorage API.
- Kordhinta dib u soo kabashada ayaa lagu daray, loogu talagalay in lagu soo celiyo xogta faylasha dhaawacan ee kaydka. Interface-ka khadka talisku wuxuu isticmaalaa amarka ". soo kabashada" si loo soo celiyo.
- Waxqabadka qorsheeye weydiinta oo la hagaajiyay. Xayiraadaha ayaa meesha laga saaray marka la isticmaalayo tusmooyin leh jaantusyo leh in ka badan 63 tiir (horay, tusmaynta laguma dabaqin hawlgallada tiirarka leh ee nambarkooda caadiga ahi dhaafo 63). Tilmaanta la hagaajiyay ee qiimaha lagu isticmaalo tibaaxaha. La joojiyay rarista xadhkaha waaweyn iyo baloobyada saxanka marka la farsameynayo hawlwadeennada NO NULL iyo IS NULL Ka-saarista muuqaal-samaynta aragtiyaha kaas oo iskaanka buuxa la sameeyo hal mar oo keliya.
- Gudaha codebase, halkii laga isticmaali lahaa nooca "char *", nooc sqlite3_filename gaar ah ayaa loo isticmaalaa si loogu matalo magacyada faylka.
- Lagu daray sqlite3_value_encoding() shaqada gudaha
- Waxaa lagu daray qaabka SQLITE_DBCONFIG_DEFENSIVE, kaas oo mamnuucaya beddelka qaabka kaydinta qaabka.
- Jeegagag dheeraad ah ayaa lagu daray hirgelinta halbeegga "PRAGMA integrity_check". Tusaale ahaan, jaantusyada aan lahayn sifada STRICT waa in aanay ku jirin qiimayaal tirooyin ah oo ku jira tiirarka TEXT iyo qiyamka xargaha oo leh tirooyin ku jira tiirarka NUMERIC. Sidoo kale lagu daray hubi sax ahaanshiyaha sida ay u kala horreeyaan safafka miisaska leh sifada "LA'AAN ROWID".
- Ereyga "VACUUM INTO" wuxuu ixtiraamayaa "PRAGMA synchronous" settings.
- Doorashada dhismaha lagu daray SQLITE_MAX_ALLOCATION_SIZE si loo xaddido cabbirka xannibaadda marka loo qoondeynayo xusuusta.
- Algorithm-ka soo saarida nambarada random-ka-random ee lagu dhisay SQLite ayaa laga raray adeegsiga xarafka qulqulka RC4 oo loo beddelay Chacha20.
- Waa la oggol yahay in la isticmaalo tusmooyinka isku magaca ah ee qorshayaasha xogta ee kala duwan.
- Hagaajinta waxqabadka ayaa la sameeyay si loo yareeyo culeyska CPU ilaa 1% inta lagu jiro dhaqdhaqaaqa caadiga ah.
Source: opennet.ru