Kutulutsidwa kwa DBMS SQLite 3.31 ndi chithandizo chamizere yopangidwa

Lofalitsidwa kumasula SQLite 3.31.0, DBMS yopepuka yopangidwa ngati plug-in library. 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 Adobe, Oracle, Mozilla, Bentley ndi Bloomberg.

waukulu kusintha:

• Thandizo lowonjezera mizati zopangidwa (mizere yowerengedwera), yomwe imakulolani kufotokozera ndime pamene mupanga tebulo lomwe mtengo wake umawerengedweratu malinga ndi zomwe zili mugawo lina. Mizati yopangidwa ikhoza kukhala yeniyeni (yopangidwa pa ntchentche ndi mwayi uliwonse) kapena kusungidwa m'dawunilodi (yosungidwa nthawi iliyonse mizati yofananirayo ikusinthidwa). Zomwe zili m'mizere yopangidwa zimapezeka pokhapokha mukamawerenga (zosintha zimangosinthidwa mwa kusintha kwa mtengo mu gawo lina lomwe likukhudzidwa ndi kuwerengera). Mwachitsanzo:

  PANGANI TABULO t1(
  CHIFUKWA CHA INTERGER PRIMARY,
  b INT,
  c TEXT,
  d INT IMAKHALA NTHAWI ZONSE MONGA (a*abs(b)) POKHALA,
  e LEMBA LAPANSI MONGA (substr(c,b,b+1)) ZOSEKEDWA
  );

• Anawonjezera PRAGMA trusted_schema, kukhazikitsa SQLITE_DBCONFIG_TRUSTED_SCHEMA ndi njira yolumikizira "-DSQLITE_TRUSTED_SCHEMA", yomwe imakupatsani mwayi wowongolera kuphatikizika kwa chitetezo ku kuwukira kudzera mukusintha kwa data schema mu database. Chitetezo chokhazikika chimaletsa kugwiritsa ntchito ntchito za SQL (zosalembedwa kuti SQLITE_INNOCUOUS) pazoyambitsa, mawonedwe, CHECK ndi DEFAULT mawu, indexes, ndi magawo opangidwa. Kugwiritsa ntchito matebulo muzoyambitsa ndi zowonera kumayimitsidwanso pokhapokha ngati tebulo lodziwika bwino lalengezedwa momveka bwino ndi mbendera ya SQLITE_VTAB_INNOCUOUS.
• Anakhazikitsa luso logawa katundu ku ntchito za SQL zomwe zafotokozedwa muzogwiritsira ntchito SQLITE_INNOCUOUS (ntchito zopanda vuto zomwe sizidalira magawo akunja ndipo sizingagwiritsidwe ntchito kuchita zoyipa) ndi SQLITE_DIRECTONLY (kungoyimba mwachindunji pamafunso a SQL, popanda mwayi wogwiritsa ntchito zoyambitsa, mawonedwe ndi zithunzi zamapangidwe a data);
• Module yowonjezera uwu ndi kukhazikitsa ntchito pokonza UUID (RFC-4122);
• Anawonjezera PRAGMA hard_heap_limit ndi ntchito sqlite3_hard_heap_limit64() kuwongolera kukula kwakukulu kwa mulu;
• Mu PRAGMA function_list anawonjezera linanena bungwe mtundu, katundu ndi chiwerengero cha mikangano iliyonse ntchito;
• Kuti muwone tebulo la DBSTAT anawonjezera njira yophatikizira deta;
• sqlite3_open_v2() imagwiritsa ntchito njira ya SQLITE_OPEN_NOFOLLOW, yomwe imakupatsani mwayi woletsa kutsegula kwa maulalo ophiphiritsa;
• Kwa mkangano PATH, yapititsidwa ku ntchito za JSON, yowonjezera chithandizo cha "#-N" zolemba;
• Mu dongosolo logawa kukumbukira kuyang'ana kumbali kuthandizira pazigawo ziwiri zokumbukira zakhazikitsidwa, iliyonse yomwe ingagwiritsidwe ntchito kugawa midadada yamitundu yosiyanasiyana (kupatukana kumakupatsani mwayi wowonjezera kugwiritsa ntchito mawonekedwe owoneka bwino, ndikuchepetsa kukula kwa buffer yomwe imaperekedwa ku kulumikizana kulikonse kuchokera ku 120 mpaka 48. KB);
• Thandizo la PRAGMA lathetsedwa legacy_file_format, zomwe zinali zosemphana ndi VACUUM, mizati yopangidwa, ndi zolozera zotsika (zothandizira zamtundu wa cholowa zitha kubwezedwa kudzera pa SQLITE_DBCONFIG_LEGACY_FILE_FORMAT mbendera mu sqlite3_db_config()).

Source: opennet.ru