ProHoster > Blog > internet nhau > SQLite 3.44 kuburitswa

SQLite 3.44 kuburitswa

Kuburitswa kweSQLite 3.44, isingaremi DBMS yakagadzirwa senge plug-in raibhurari, yakaburitswa. Iyo SQLite kodhi inogoverwa senzvimbo yeruzhinji, i.e. inogona kushandiswa pasina kurambidzwa uye pasina muripo kune chero chinangwa. Tsigiro yezvemari yevagadziri veSQLite inopihwa neyakagadzirwa mubatanidzwa, iyo inosanganisira makambani akadai seBentley, Bloomberg, Expensify uye Navigation Data Standard.

Shanduko huru:

  • Aggregate mabasa anobvumira "ORDER BY" clause mushure mekupedzisira parameter kugadzirisa nharo dzebasa nenzira yakatarwa, iyo inogona kubatsira kumabasa akaita se string_agg () uye json_group_array ().
  • Yakawedzerwa rutsigiro rwe scalar SQL mabasa concat() uye concat_ws(), inoenderana nePostgreSQL, MS SQL Server uye MySQL.
  • Yakawedzera tsigiro yetambo_agg() aggregate basa, inoenderana nePostgreSQL uye MS SQL Server.
  • Yakawedzera tsigiro yezvinoreva "% e", "% F", "% I", "%k", "%l", "% p", "% P", "% R" kune SQL basa strftime( ) "% T" uye "%u".
  • Zvikanganiso zvakawanda zvine chekuita neCREATE TABLE statement zvave kubuda mushure mekunge CREATE TABLE statement yaitwa, pane kuti tafura yashandiswa kekutanga.
  • Iyo "PRAGMA kutendeseka_check" yekuraira zvishandiso inotarisa kuenderana kwezviri mukati akasiyana akavakirwa-mukati matafura matafura anoshandiswa muFTS3, FTS4, FTS5, RTREE uye GEOPOLY ekuwedzera.
  • Akavakirwa-mukati matafura anoshandiswa muFTS3, FTS4, FTS5, RTREE uye GEOPOLY ekuwedzera anotenderwa kushandiswa mukati mezvinokonzeresa.
  • Kana uchitsanangura iyo SQLITE_DBCONFIG_DEFENSIVE kuseta, dziviriro inopihwa kubva mukugonesa iyo "PRAGMA writable_schema" modhi.
  • Kana yaunganidzwa neMicrosoft C compiler, iyo SQLITE_USE_SEH (Structured Exception Handling) inogoneswa nekusarudzika.
  • Optimizations yakaitwa kumubvunzo wekuronga zvine chekuita nechikamu index scans kana uchitsanangura kukosha kwenguva dzose kwetafura yekoramu muWHERE clause. Nekuda kwekudzokororwa kwakaonekwa, iyo yekuona scanning optimization yakawedzerwa muvhezheni 3.42.0 yakadzimwa.
  • Inopa run-time verification yerutsigiro rwesistimu yerudzi rwe "refu kaviri" nehupamhi hwepamusoro kupfuura iyo yemhando ye "double".
  • MuWindows command interface, UTF-8 encoding inogoneswa nekusarudzika yekupinza uye kubuda (iyo "-no-utf8" sarudzo inopihwa kuidzima).

Source: opennet.ru

Voeg