I-SQLite 3.53.0

Ngomhla wesi-9 ku-Epreli, kwakhutshwa inguqulelo yesi-3.53.0 ye-DBMS ehlanganisiweyo yeqonga elinqamlezileyo. SQLiteIkhowudi yeprojekthi ibhalwe ngo-C kwaye isasazwa kuluntu.

Utshintsho:

• Ibug elungisiweyo Iphutha lokonakala kwedatabase ye-WAL-resetJonga iindaba zangaphambili I-SQLite 3.51.3 ilungisa ukonakala okunokwenzeka kwisiseko sedatha kwimo ye-WAL.
• Kongezwe ilayibrari yokufometha iziphumo zemibuzo ye-SQL Ifomathi yeZiphumo zoMbuzo (i-QRF) ukuqinisekisa ukuba kulula ukufunda kwisikrini esinefonti enobubanzi obumiselweyo.
• Indlela eyongeziweyo format к Ujongano lwe-TCL ukufikelela kwi-QRF kwi-TCL.
  • I-QRF ngoku isetyenziswa kwisixhobo sekhonsoli Isikwere ukufomatha iziphumo zemibuzo, ukuphucula umboniso wazo.
• Iimpawu ezintsha zolwimi lwe-SQL:
  • Ukuphucula amandla okulawula ALTER TABLE ukubonelela ngokukwazi ukongeza nokususa imiqathango ye-NOT NULL kunye ne-CHECK.
  • Umqhubi AMAGAMA E-REINDEX yenza uhlengahlengiso lwee-indices zokubonisa. Iluncedo ekubuyiseleni ii-index ze-legacy expression.
  • Ngoku I-TEMP iqalisa inokutshintsha kunye/okanye ibuze idatha kwiitheyibhile eziphambili zeschema.
  • Umyalelo ophuculweyo GQUMA KU: Ukuba indawo ekuyiwa kuyo ligama lefayile kwifomathi ye-URI equlathe iparameter yemibuzo reserve=N (apho u-N elinani eliqala ku-0 ukuya ku-255), ubungakanani bokubhukisha bekopi yedatha edaliweyo busetelwe ku-N.
• Imisebenzi emitsha ye-SQL yongeziwe:
  • i-json_array_insert()
  • jsonb_array_insert()
• Uhlaziyo kwi isixhobo sekhonsoli:
  • Uphuculo olubalulekileyo lweqela .imowudi.
  • Siyabonga Ukwandiswa kwe-QRF Ukufometha kweziphumo kuphuculwe. Umzekelo, amanani ngoku alungelelaniswe ngasekunene ngokuzenzekelayo kwi imveliso yetafile.
  • Ngokuzenzekelayo, i-QRF ngoku isetyenziswa xa kusetyenziswa i-console utility ngokusebenzisana ukubonisa iziphumo zemibuzo kwiibhloko ezenziwe kusetyenziswa oonobumba be-Unicode block-drawing, nto leyo ephucula ukufundeka. Ifomathi yemveliso yelifa isetyenziswa xa kusetyenziswa imiyalelo kwiibhetshi ngezizathu zokuhambelana.
  • Iisemicolons ezingatshatanga (ezingacatshulwanga) ekupheleni imiyalelo yamachaphaza azinakwa ngaphandle kwesilumkiso. Oku kukungahambelani okunokwenzeka!
  • Imiyalelo ye-.testcase kunye ne-.check ilungisiwe. Ngoku iyasebenza kwaye isetyenziswa kwizikripthi ezifakwe kwi-test suite eqhelekileyo ye-SQLite efakwe kwikhowudi yomthombo.
  • Iingxoxo zomgca womyalelo ezihambelana neepateni ze-*.sql okanye ze-*.txt kwaye zingamagama eefayile ezingenanto zifundwa kwaye zitolikwe njengezikripthi eziqulethe iingxelo ze-SQL kunye/okanye [imiyalelo yamachaphaza]((https://sqlite.org/cli.html#dotcmd).
  • Ngoku ungachaza kube kanye njengengxoxo kumyalelo we-.timer ukuze ubangele ukuba isibali-xesha sidubule kuphela xa umbuzo olandelayo we-SQL uphunyeziwe.
  • Ukhetho olutsha lwe--timeout S lomyalelo we-.progress lubangela ukuba imibuzo ye-SQL iyeke ukwenziwa emva kwemizuzwana ye-S.
  • Umyalelo we-.indexes utshintshiwe ukuze impikiswano ye-PATTERN ngoku ifane negama lesalathisi endaweni yegama letafile ebekwe kwisalathisi (okwenza impikiswano ye-PATTERN ibe luncedo ngokwenene). Ukongeza, kukho iindlela ezintsha ezininzi ezongeziweyo kumyalelo we-.indexes.
• Uphuculo kwi-C API:
  • sqlite3_str_truncate()
  • sqlite3_str_free()
  • sqlite3_carray_bind_v2()
  • Ukusebenza sqlite3_prepare_v3() ukhetho longeziwe I-SQLITE_PREPARE_FROM_DDL, evumela ukuphunyezwa kwetafile ebonakalayo ukulungiselela ngokukhuselekileyo iingxelo ze-SQL ezifunyenwe kwi-schema yedatha.
  • Kongezwe rhoqo SQLITE_UTF8_ZT, enokusetyenziswa njengepharamitha yokubhala ikhowudi kwimisebenzi sqlite3_result_text64() okanye sqlite3_bind_text64() ukubonisa ukuba ixabiso lifakwe kwi-UTF-8 kwaye alipheli.
  • Ukusebenza sqlite3_limit() ukhetho longeziwe Ubunzulu_be-SQLITE_LIMIT_PARSER_.
  • Ukusebenza sqlite3_db_config() ukhetho longeziwe I-SQLITE_DBCONFIG_FP_DIGITSJonga kwakhona inqaku 9b ngezantsi.
• Uphuculo lwesicwangciso semibuzo:
  • NGAPHANDLE kwe-, INTERSECT, kunye ne-UNION, i-algorithm yokukhetha nokudibanisa isoloko isetyenziswa, njengoko phantse ikhawuleza kakhulu kunokusebenzisa iitafile ze-hash.
  • Uphuculo kwindlela yokukhetha i-join order xa kwenziwa i-multi-way joins enkulu kuyilo lweenkwenkwezi.
  • Kuphuculwe ukwenziwa ngcono kokuguqulwa kwe-EXISTS ukuya kwi-JOIN ukuze iimeko ze-JOIN ezifakiweyo zingabikho kwi-inner loops, okoko nje zonke izinto ezixhomekeke kwi-EXISTS ukuya kwi-JOIN conversion loops zikwi-outer loops.
  • Ukuphuculwa kokwenziwa ngcono kwe-omit-noop-join ukuze ikwazi ukukhupha uthotho lwee-joins ezingachaphazeli iziphumo.
  • Ukuphucula imibuzo kusetyenziswa i-GROUP BY e1 ORDER BY e2, apho i-e1 kunye ne-e2 zifana ngaphandle kwe-ASC/DESC sort order, kusetyenziswa i-index enye.
  • Lungiselela umqhubi we-DISTINCT kwiitheyibhile ezibonakalayo xa iseti yesiphumo sombuzo ingahambelani ngokupheleleyo nemeko ye-ORDER BY.
• В ulwandiso lweseshoni Kongezwe ii-interfaces ezintsha ezivumela usetyenziso ukuba longeze utshintsho ngalunye kwinto ye-sqlite3_changegroup:
  • sqlite3changegroup_change_begin()
  • sqlite3changegroup_change_blob()
  • sqlite3changegroup_change_double()
  • sqlite3changegroup_change_int64()
  • sqlite3changegroup_change_null()
  • sqlite3changegroup_change_text()
  • sqlite3changegroup_change_finish()
  • sqlite3changegroup_config()
• Uphuculo ekuguqulweni kombhalo we-floating point ↔.
  • Ikhowudi ibhalwe ngokutsha ngokupheleleyo ukuphucula ukusebenza.
  • Ukujikelezisa ngoku yinto ezenzekelayo iveliswe ukuya kuthi ga kwi-17 amanani abalulekileyo endaweni ye-15, njengakwiinguqulelo zangaphambili. Ukuba kuyimfuneko, eli xabiso lingatshintshwa kusetyenziswa umsebenzi i-sqlite3_db_config ngokhetho I-SQLITE_DBCONFIG_FP_DIGITS (jonga inqaku eliyi-6g ngasentla apho).
• Uphawu olongeziweyo isalathisi sokuziphilisa ukusombulula ingxaki ii-index ze-legacy expression.
• Kwisixhobo sekhonsoli sqlite3_rsync Kongezwe ukhetho lwe--p|—port.
• Inkxaso iyekile IWindows RT.
• IJavaScript/WASM
  • I-opfs-wl VFS yongezwe. Isebenza ngendlela efanayo ne-opfs kodwa isebenzisa ii-Web Locks kwii-locks, iqinisekisa ukusasazwa kwe-lock okufanelekileyo kune-protocol ye-opfs. i-opfs-wl ifuna umsebenzi we-Atomics.waitAsync(), ngoko ke ifuna iinguqulelo ezintsha zesikhangeli kune-opfs.

umthombo: linux.org.ru