Siideynta SQLite 3.44, DBMS khafiifa oo loogu talagalay sidii maktabad fur-in, ayaa la daabacay. Koodhka SQLite waxa loo qaybiyaa goob dadweyne ahaan, i.e. waxaa 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 Bentley, Bloomberg, Expensify iyo Standard Data Navigation.
Isbeddellada ugu waaweyn:
- Hawlaha isku-darka ah waxay oggolaadaan jumlada "AMAR BY" ka dib halbeegga u dambeeya si loo habeeyo dooda shaqada ee habka la cayimay, kaas oo waxtar u yeelan kara hawlaha sida string_agg () iyo json_group_array().
- Taageerada lagu daray ee hawlaha SQL scalar concat () iyo concat_ws(), oo ku habboon PostgreSQL, MS SQL Server iyo MySQL.
- Taageero lagu daray string_agg() shaqada wadareedka, oo ku habboon PostgreSQL iyo MS SQL Server.
- Taageerada lagu daray tilmaamayaasha "%e", "%F", "%I", "%k", "%l", "%p", "%P", "%R" ee shaqada SQL strftime ( ) "%T" iyo "%u".
- Qaladaad badan oo la xidhiidha qoraalka Miisaanka ABUURID ayaa hadda soo baxay ka dib marka la sameeyo bayaanka Miiska Abuur, halkii laga isticmaali lahaa miiska markii ugu horeysay.
- Amarka "PRAGMA integrity_check" wuxuu fuliyaa hubinta joogtaynta waxa ku jira miisaska farsamada ee lagu dhex dhisay ee FTS3, FTS4, FTS5, RTREE iyo GEOPOLY.
- Miisaska farsamada ee lagu dhex dhisay FTS3, FTS4, FTS5, RTREE iyo GEOPOLY kordhinta waa la ogol yahay in loo isticmaalo kiciyeyaasha gudahooda.
- Marka la tilmaamayo goobta SQLITE_DBCONFIG_DEFENSIVE, ka hortagga waxaa la bixiyaa ka hortagga awood u yeelashada habka "PRAGMA writable_schema".
- Marka la isku daro Microsoft C compiler, SQLITE_USE_SEH (Habka Ka-reebitaanka Habaysan) ayaa si toos ah loo hawlgeliyaa.
- Wanaajin ayaa lagu sameeyay qorsheeyeha weydiinta ee laxidhiidha baarista tusmada qaybeed marka la tilmaamayo qiimaha joogtada ah ee tiirka miiska ee jumlada HALKEE. Sababo la xiriira dib-u-celinta la aqoonsaday, hagaajinta iskaanka aragtida ee lagu daray nooca 3.42.0 waa la joojiyay.
- Waxay siisaa xaqiijinta wakhtiga orodka ee taageerada nidaamka nooca "laba-dheer" oo leh saxnaan sare oo ka sareysa nooca "laba-laab".
- In interface-ka amarka Windows, UTF-8 encoding-ku si toos ah ayaa loogu sahlayaa gelinta iyo soo saarista (β-no-utf8β ikhtiyaarka ayaa la bixiyaa si loo joojiyo).
Source: opennet.ru