I-ProHoster > Π‘Π»ΠΎΠ³ > izindaba ze-inthanethi > Ukukhishwa kwe-SQLite 3.38 DBMS kanye nesethi ye-sqlite-utils 3.24 yezinsiza

Ukukhishwa kwe-SQLite 3.38 DBMS kanye nesethi ye-sqlite-utils 3.24 yezinsiza

Ukukhishwa kwe-SQLite 3.38, i-DBMS engasindi eklanywe njengomtapo wolwazi we-plug-in, kushicilelwe. Ikhodi ye-SQLite isatshalaliswa esizindeni somphakathi, i.e. ingasetshenziswa ngaphandle kwemikhawulo futhi mahhala nganoma iyiphi injongo. Usekelo lwezezimali lwabathuthukisi be-SQLite luhlinzekwa yinhlangano edalwe ngokukhethekile, ehlanganisa izinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley ne-Bloomberg.

Izinguquko eziyinhloko:

  • Kungezwe ukusekelwa kwama-opharetha -> kanye ->> ukuze kube lula ukukhipha idatha ngefomethi ye-JSON. I-syntax entsha ye-opharetha iyahambisana ne-MySQL ne-PostgreSQL.
  • Isakhiwo esiyinhloko sihlanganisa imisebenzi yokusebenza ngedatha ngefomethi ye-JSON, ukuxhumana kwakho obekudinga ngaphambilini ukuhlanganiswa ngefulegi elithi β€œ-DSQLITE_ENABLE_JSON1”. Ukuze ukhubaze ukusekela kwe-JSON, ifulegi elithi "-DSQLITE_OMIT_JSON" lengeziwe.
  • Kwengezwe umsebenzi we-unixepoch() obuyisela isikhathi se-epochal (inani lamasekhondi kusukela ngomhla ka-Januwari 1, 1970).
  • Emisebenzini esebenza nesikhathi, izilungisi "ezizenzakalelayo" kanye "ne-julianday" zisetshenzisiwe.
  • Umsebenzi we-SQL printf() uqanjwe kabusha ukuze ufomethi() ukuthuthukisa ukuhambisana namanye ama-DBMS (usekelo lwegama elidala luyagcinwa).
  • Kwengezwe isixhumi esibonakalayo se-sqlite3_error_offset() ukuze kube lula ukuthola amaphutha embuzweni.
  • Izixhumanisi zohlelo olusha zengezwe ekusetshenzisweni kwamathebula abonakalayo: sqlite3_vtab_distinct(), sqlite3_vtab_rhs_value() kanye ne-sqlite3_vtab_in(), kanye nezinhlobo zama-opharetha ezintsha SQLITE_INDEX_CONSTRAINT_LIMIT kanye ne-SQLITE_INDEX_CONSTRAINT_OFFSET.
  • Isixhumi esibonakalayo somugqa womyalo siqinisekisa ukuphathwa okulungile kwethebhu nezinhlamvu zesiphakeli somugqa ekuphumeni kombhalo kumamodi wamakholomu amaningi. Ukwesekwa okwengeziwe kokusebenzisa izinketho ze-"--wrap N", "--wordwrap on" kanye "-quote" lapho ukhiphela kumakholomu amaningi. Umyalo othi .import uvumela ukulungiswa kwamagama ekholomu.
  • Ukuze kusheshiswe ukuqaliswa kwemibuzo emikhulu yezibalo, umhleli wombuzo usebenzisa ukwakheka kwesihlungi se-bloom esingenzeka ukuze sinqume ukuthi i-elementi ikhona yini kusethi. Isihlahla sokuhlanganisa esinokulinganisela sisetshenziselwa ukuthuthukisa ukucutshungulwa kwe-UNION kanye ne-UNION ALL amabhulokhi ahlanganisa izitatimende KHETHA ezinezigatshana ze-ORDER BY.

Ukwengeza, ungakwazi ukuqaphela ukushicilelwa kwenguqulo yesethi ye-sqlite-utils 3.24, ehlanganisa izinsiza kanye nomtapo wolwazi wokukhohlisa amafayela kusuka kusizindalwazi se-SQLite. Imisebenzi efana nokulayisha ngokuqondile idatha ye-JSON, i-CSV noma i-TSV kufayela lesizindalwazi elidaleka ngokuzenzakalelayo uhlelo lokulondoloza oludingekayo, ukusetshenziswa kwemibuzo ye-SQL ngamafayela e-CSV, TSV kanye ne-JSON, ukusesha umbhalo ogcwele kusizindalwazi, ukuguqulwa kwedatha nezikimu zokulondoloza. ezimeni lapho i-ALTER ingasebenzi ziyasekelwa ITHEBULA (isibonelo, ukuze ushintshe uhlobo lwamakholomu), ikhiphe amakholomu abe amathebula ahlukene.

Source: opennet.ru

Engeza amazwana