Kutulutsidwa kwa SQLite 3.44, DBMS yopepuka yopangidwa ngati laibulale ya pulagi, kwasindikizidwa. Khodi ya SQLite imagawidwa ngati malo a anthu onse, i.e. itha kugwiritsidwa ntchito popanda zoletsa komanso kwaulere pazifukwa zilizonse. Thandizo lazachuma kwa opanga ma SQLite limaperekedwa ndi bungwe lopangidwa mwapadera, lomwe limaphatikizapo makampani monga Bentley, Bloomberg, Expensify ndi Navigation Data Standard.
Zosintha zazikulu:
- Ntchito zophatikizana zimalola chiganizo cha "ORDER BY" pambuyo pa gawo lomaliza kuti likonze mfundo za ntchitoyi motsatira ndondomeko yomwe mwatchulidwa, yomwe ingakhale yothandiza pamatenda monga string_agg() ndi json_group_array().
- Thandizo lowonjezera la ntchito za scalar SQL concat() ndi concat_ws(), zomwe zimagwirizana ndi PostgreSQL, MS SQL Server ndi MySQL.
- Thandizo lowonjezera la string_agg() aggregate function, yogwirizana ndi PostgreSQL ndi MS SQL Server.
- Thandizo lowonjezera la zofotokozera "%e", "%F", "%I", "%k", "%l", "%p", "%P", "%R" ku SQL function strftime( ) "%T" ndi "%u".
- Zolakwa zambiri zomwe zimagwirizanitsidwa ndi mawu a CREATE TABLE tsopano zimatuluka pambuyo poti mawu a CREATE TABLE aperekedwa, osati tebulo litagwiritsidwa ntchito koyamba.
- Lamulo la "PRAGMA integrity_check" limagwiritsa ntchito kuyang'ana kusasinthasintha kwa zomwe zili m'matebulo osiyanasiyana omangidwa omwe amagwiritsidwa ntchito pazowonjezera za FTS3, FTS4, FTS5, RTREE ndi GEOPOLY.
- Matebulo omangidwa mkati omwe amagwiritsidwa ntchito mu FTS3, FTS4, FTS5, RTREE ndi GEOPOLY zowonjezera amaloledwa kugwiritsidwa ntchito mkati mwa zoyambitsa.
- Mukatchula zochunira za SQLITE_DBCONFIG_DEFENSIVE, chitetezo chimaperekedwa kuti musatsegule "PRAGMA writable_schema".
- Mukapangidwa ndi Microsoft C compiler, makonzedwe a SQLITE_USE_SEH (Structured Exception Handling) amayatsidwa mwachisawawa.
- Kuwongola bwino kwapangidwa kwa query planner yokhudzana ndi ma index ang'onoang'ono pofotokoza mtengo wokhazikika wagawo la tebulo mu ndime ya WHERE. Chifukwa cha kusinthika komwe kwazindikirika, kukhathamiritsa kwazithunzi zomwe zawonjezeredwa mu mtundu 3.42.0 kwayimitsidwa.
- Amapereka chitsimikiziro cha nthawi yoyendetsera chithandizo chamtundu wa "long double" molondola kwambiri kuposa mtundu wa "double".
- Mu mawonekedwe a Windows command, UTF-8 encoding imayatsidwa mwachisawawa kuti mulowetse ndikutulutsa (njira ya "--no-utf8" imaperekedwa kuti muyimitse).
Source: opennet.ru