yinkqubo yolawulo lwesiseko sedatha ehambelana ne-ACID, equlethwe kwithala leencwadi elincinci elibhalwe kuC
I-SQLite yinjini yedatha ekhaphukhaphu yobudlelwane. ifikeleleka ngolwimi lweSQL. Ngokungafaniyo neeseva zedatha zemveli ezifana neMySQL okanye iPostgreSQL, eyona nto ayikuko ukuvelisa kwakhona inkqubo yesiqhelo yomncedisi womthengi, kodwa idityaniswe ngokuthe ngqo kwiinkqubo.
SQLite yinkqubo yolawulo lwedatha yefayile enye epheleleyo. I-SQL, okanye i-Structured Query Language, lulwimi olusemgangathweni lwenkqubo yokugcina nokubuyisela idatha. Abaphathi bedatabase abadumileyo beSQL baquka iOracle, iDB2 yeIBM, iMicrosoft's SQL Server kunye noFikelelo, kunye nesoftware yeMySQL nePostgreSQL yasimahla.
Mva nje umseki weprojekthi wakhalaza yantnoni "I-SQLite ngokucacileyo kwaye ngokungathandabuzekiyo 'umthombo ovulekileyo, hayi igalelo elivulekileyo'", Ikhankanya ukuba iprojekthi ngoku inenjongo enyiniweyo, ekukuba ibe nguvimba weenkcukacha okhawulezayo, omncinci nothembekileyo odibeneyo.
Isizathu se La magqabaza avela kwizinto ezimbini, eyokuqala ngabo ukuba yena neqela lakhe baxambulisane I-SQLite ifuna ukuphuculwa ngeempawu ezintsha ezibalulekileyo. Ezi ziquka ngokukodwa:
- Inkxaso yokusasazwa kwedatha ekhoyo kwiiseva ezininzi
- I-Asynchronous I/O inkxaso ngeLinux io_uring API entsha
- I-eBPF yokwandisa iSQLite ngokuvumela imisebenzi ethile ukuba iqhube kwi-kernel
- Inkxaso yemisebenzi echazwe ngumsebenzisi kwiWasm (WebAssembly) ukuvumela ukusetyenziswa kwezinye iilwimi, ezihlanganiswe kwiWasm, endaweni yeC.
- Iprojekthi ye-libSQL iceba ukusebenzisa iRust ngokubambisana noC ukuphumeza olu tshintsho.
Okwesibini kukuba kutshanjee wenze ifolokhwe entsha yeSQLite, ebizwa ngokuba libSQL, ijonge ukwenza yangoku iSQLite DBMS edume kakhulu. Ngaphandle koko uceba ukusebenzisa i-Rust kunye no-C ukuphumeza utshintsho oluphikisana nomsunguli.
Ngaloo ndlela, abaninzi banokukhankanya ukuba kutheni ifolokhwe kwaye ungenzi izindululo kwiprojekthi yeSQLite ngokwayo? kwaye njengoko sele kukhankanyiwe, i Ingxaki kukuba iprojekthi yeSQLite inenjongo elinganiselweyo
Ngokweqela lophuhliso lweSQLite, i-DBMS mhlawumbi yenye yezona modyuli zintlanu eziphunyezwe ngokubanzi kuyo nayiphi na inkcazo. Ngenxa yokuba iSQLite isetyenziswa kakhulu kuzo zonke ii-smartphones kwaye kukho ngaphezulu kwe-4000 yeebhiliyoni zee-smartphones ezisebenzayo, nganye iqulathe amakhulukhulu eefayile zedatha yeSQLite, kusenokwenzeka ukuba kukho ngaphezu kwe-4000 yeebhiliyoni zee-smartphones ezisetyenziswayo kunye nezigidigidi zedatha yeSQLite esebenzayo. .
Ngenxa yokukhanya kwayo okugqithisileyo, I-SQLite yenye yeenjini zedatha esetyenziswa kakhulu emhlabeni. Isetyenziswa kwiinkqubo ezininzi zabathengi kwaye idume kakhulu kwiinkqubo ezifakwe ngaphakathi, kubandakanya uninzi lwee-smartphones zanamhlanje.
Ubungakanani ayisiyiyo yonke into kumdali othobekileyo weSQLite, njengoko Kuyabonakala ukuba unombono wokuguqula iprojekthi ibe yinto enenzuzo, kuba ngenxa yoko akafumani ntlawulo yezigidi zeekopi ezisetyenziswa ngabasebenzisi bezorhwebo nabangengabo ukurhweba kwaye kwimeko, ukhankanya ukuba akanamdla ngokwenene kwinxalenye yemali kwaye ekujongeni ingxoxo yakhe, ukucaphuka kwakhe kuya kwenye. ukusondela.
Le yindlela engaqhelekanga, nakwilizwe lesoftware yasimahla. Uninzi lwekhowudi yomthombo ovulekileyo inelayisensi phantsi kwesivumelwano esifana ne-GNU GPL (iLayisensi yoLuntu ngokubanzi), leyo ibandakanya imigaqo eqinisekisa ukuba isoftware ihlala isimahla, nangona namhlanje abaphuhlisi abaninzi beeprojekthi ezibalulekileyo baye bafikelela kwisigqibo, apho bengavumelani ngokupheleleyo ukuba iimveliso zabo azizange zifumane inkxaso kubasebenzisi bezorhwebo (into efana neyokufika kwe-QT).
UHipp uthi: “Ndawajonga onke amaphepha-mvume, ndaza ndacinga ukuba, kutheni ndingavele ndiyibeke ebantwini? Kutheni kubekwe le miqathango kuyo? Khange ndilindele ukufumana nesenti. Ndandifuna nje ukuyenza ifumaneke kwabanye abantu ukuze bacombulule ingxaki yabo. »
“Asizami ukukhuphisana nezinye iinjini,” utshilo uHipp. “Injongo yethu ayikokongeza zonke iintlobo zeentsimbi kunye neempempe, kodwa kukugcina iSQLite incinci kwaye ikhawuleza. Sibeka umda ongekho mthethweni wokugcina indawo yethala leencwadi ingaphantsi kwama-250KB.”
Ekugqibeleni, uGlauber Costa ukhankanya ukuba «impumelelo yeSQLite idityaniswe nophuhliso lwayo oluvalekileyo lwenza kube nzima ukuba ifolokhwe iphumelele, enye inketho kukusonga iSQLite ngomsebenzi owongezelelweyo, kodwa oku kunemida”, apho iCosta ibhekisa khona.
Umthombo: https://devclass.com/