I-SQLite 3.40 ifika ngenkxaso esemthethweni ye-Wasm kunye nokunye

SQLite

I-SQLite yinjini yedatha ekhaphukhaphu

I ukukhululwa kwenguqulelo entsha ye-DBMS eyaziwayo "SQLite 3.40", i-DBMS ekhaphukhaphu eyilwe njengelayibrari yeplagi.

SQLite yinjini yedatha ekhaphukhaphu yobudlelwane efikelelekayo ngolwimi lweSQL. Ngokungafaniyo neeseva zedatha yemveli, ezinje ngeMySQL okanye iPostgreSQL, eyona nto ibalulekileyo ayikokuvelisa i-schema yesiqhelo yomxhasi, kodwa ukudibanisa ngqo kwiinkqubo. Enyanisweni, yonke i-database (iingxelo, iitheyibhile, izalathisi, kunye nedatha) igcinwe kwifayile ezimeleyo yeqonga.

Enkosi ngobukhaphukhaphu bayo obugqithisileyo, iSQLite yenye yeenjini zedatha esetyenziswa kakhulu kwihlabathi. Isetyenziswa kwiinkqubo ezininzi zabathengi kwaye idume kakhulu kwiinkqubo ezifakwe ngaphakathi, kubandakanya uninzi lwee-smartphones zanamhlanje.

Iimpawu ezintsha eziphambili ze-SQLite 3.40

Kolu guqulelo lutsha luvezwayo, kugxininiswe ukuba a isakhono sokulinga ukuqulunqa iSQLite kwikhowudi yeWebAssembly I-Intermediate enokuthi iqhutywe kwi-browser yewebhu kwaye ifanelekile ukuququzelela umsebenzi wedatha evela kwizicelo zewebhu kulwimi lweJavaScript.

Abaphuhlisi bewebhu bane-interface ejoliswe kwizinto eziphezulu zokusebenza kunye nedatha kwisitayela se-sql.js okanye i-Node.js, edibanisa i-API ephantsi ye-C API kunye ne-API esekelwe kwi-Web Worker mechanism evumela ukuba wenze abalawuli abangavumelaniyo. ukuba zibaleka ngemisonto eyahlukeneyo. Idata ezigcina izicelo zewebhu kuguqulelo lweWASM yeSQLite ingagcinwa kwicala lomxhasi usebenzisa iOPFS (Origin-Private FileSystem) okanye iwindow.localStorage API.

Olunye utshintsho olubalaseleyo kolu guqulelo lutsha yi kuphuculwe ukusebenza komcwangcisi wemibuzo, Ukongeza, izithintelo xa kusetyenziswa izalathisi ezineetheyibhile ezingaphezulu kwama-63 iikholamu zaye zasuswa (i-indexing yangaphambili ayizange isetyenziswe kwimisebenzi eneekholomu ezinenombolo ye-ordinal edlula i-63).

ISQLite 3.40 nayo yazisa a isalathisi esiphuculweyo samaxabiso asetyenziswa kwiintetho, Kwakhona kuyekile ukulayisha iintambo ezinkulu kunye neeblobhu kwidiski xa kusenziwa i- NOT NULL kwaye IS NULL abasebenzisi. Ukwenziwa kwezinto eziphathekayo kukhutshiwe kwiimboniselo apho iskena esipheleleyo senziwe kube kanye kuphela.

Iitshekhi ezongezelelweyo zongeziwe ekuphunyezweni kwe-parameter "PRAGMA Integrity_check". Umzekelo, iitheyibhile ezingenalo uphawu lwe STRICT akufuneki luqulathe amaxabiso amanani kwimiqolo yokubhaliweyo kunye namaxabiso omtya onamanani kwikholamu zamanani.

Ukongeza koku, kukwagxininiswa ukuba ulwandiso lokubuyisela longeziwe, eyilelwe ukubuyisela idatha kwiifayile zogcino ezonakeleyo. Ujongano lomgca womyalelo usebenzisa ".ukubuyisela" umyalelo ukubuyisela.

Olunye utshintsho evelele kule nguqulo intsha:

  • Kwisiseko sekhowudi, endaweni yohlobo lwe "char *", uhlobo olwahlukileyo lwe-sqlite3_filename lusetyenziswa ukumela amagama eefayile.
  • Umsebenzi wongeziweyo wangaphakathi sqlite3_value_encoding().
  • Yongezwe imowudi ye-SQLITE_DBCONFIG_DEFENSIVE ukunqanda ukutshintsha inguqulelo yeschema sogcino.
  • Kwakhona kongezwe ukujonga ukuchaneka kolandelelwano lwemiqolo kwiitheyibhile ngophawu "NGAPHANDLE KOROWID".
  • Intetho ethi "VACUUM INTO" ithatha useto "PRAGMA synchronous" kwiakhawunti.
  • Inketho yokudibanisa eyongeziweyo SQLITE_MAX_ALLOCATION_SIZE, ekuvumela ukuba unciphise ubungakanani beebhloko xa unikeza inkumbulo.
  • I-algorithm yokuvelisa amanani e-pseudorandom eyakhelwe kwi-SQLite ikhutshwe ekusebenziseni i-RC4 yomjelo we-cipher ukuya kwi-Chacha20.
  • Kuvunyelwe ukusebenzisa izalathisi ezinegama elifanayo kwii-schemas ezahlukeneyo zedatha.
  • Ukulungiswa komsebenzi kwenziwe ukunciphisa umthwalo we-CPU malunga ne-1% ngexesha lomsebenzi oqhelekileyo.

Ekugqibeleni, ukuba unomdla wokwazi okungakumbi ngayo Ufanele ukwazi ukuba ikhowudi ye-SQLite isasazwa kwi-domain yoluntu, oko kukuthi, inokusetyenziswa ngaphandle kwezithintelo kwaye simahla kuyo nayiphi na injongo.

Inkxaso yemali kubaphuhlisi beSQLite inikezelwa yi-consortium eyenziwe ngokukodwa, equka iinkampani ezifana neAdobe, Oracle, Mozilla, Bentley, kunye neBloomberg.

Ungajonga iinkcukacha ezithe kratya malunga nolu kukhutshwa lutsha apha eli khonkco lilandelayo.


Umxholo wenqaku uyabambelela kwimigaqo yethu imigaqo yokuziphatha yokuhlela. Ukuxela impazamo cofa apha.

Yiba ngowokuqala ukuphawula

Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.