ndeye ACID-inoenderana nehukama dhatabhesi manejimendi system, iri mudiki raibhurari yakanyorwa muC
SQLite injini yakareruka yehukama database. inowanikwa kuburikidza nemutauro weSQL. Kusiyana neyakajairwa dhatabhesi maseva seMySQL kana PostgreSQL, kukosha kwayo hakusi kuburitsa yakajairwa mutengi-server scheme, asi yakabatanidzwa zvakananga muzvirongwa.
SQLite ndeye yakakwana-faira relational database manejimendi system. SQL, kana kuti Structured Query Mutauro, ndiyo indasitiri yakajairika programming mutauro wekuchengetedza uye kudzoreredza data. Yakakurumbira SQL dhatabhesi mamaneja anosanganisira Oracle, IBM's DB2, Microsoft's SQL Server uye Access, pamwe neyemahara MySQL uye PostgreSQL software.
Munguva pfupi yapfuura muvambi wechirongwa akanyunyuta chei "SQLite iri pachena uye zvisina kujeka 'yakavhurika sosi, kwete yakavhurika mupiro'", Inotaura kuti purojekiti parizvino ine chinangwa chidiki, chinova chekukurumidza, chidiki uye chakavimbika chakabatanidzwa dhatabhesi.
Icho chikonzero che Mashoko aya anobva pazvinhu zviviri, chekutanga nezvavo izvo iye nechikwata chake vanopopotedzana SQLite inoda kuvandudzwa nezvinhu zvitsva zvinokosha. Izvi zvinosanganisira kunyanya:
- Tsigiro yekugovera dhatabhesi inowanikwa pane akawanda maseva
- Asynchronous I/O rutsigiro kuburikidza neLinux io_uring API itsva
- eBPF yekugonesa SQLite nekubvumira mamwe maoperation kumhanya mukernel
- Tsigiro yemabasa anotsanangurwa nemushandisi muWasm (WebAssembly) kubvumidza kushandiswa kwemimwe mitauro, iyo inounganidzwa muWasm, pachinzvimbo cheC.
- Iyo libSQL purojekiti inoronga kushandisa Rust yakabatana neC kuita shanduko idzi.
Chechipiri ndechekuti munguva pfupi yapfuurae yakagadzira forogo nyowani yeSQLite, inonzi libSQL, ine chinangwa chekuvandudza yakakurumbira yakamisikidzwa SQLite DBMS. Kunze kwaizvozvo anoronga kushandisa Rust pamwe chete naC kuita shanduko dzinopokana nemuvambi.
Saka nekudaro, vazhinji vanogona kutaura kuti nei forogo uye kwete kuita zvikumbiro kune SQLite chirongwa pachayo? uye sezvatotaurwa, the dambudziko nderekuti iyo SQLite purojekiti ine chinangwa chakaganhurirwa
Zvinoenderana neSQLite yekuvandudza timu, iyo DBMS ingangove imwe yeashanu anonyanya kushandiswa software modules yechero tsananguro. Tichifunga kuti SQLite inoshandiswa zvakanyanya pamafoni ese uye kune anopfuura mabhiriyoni mana emafoni emafoni ari kushandiswa, imwe neimwe iine mazana emafaira eSQLite database, zvingangoita kuti kune anopfuura bhiriyoni mana emafoni emafoni ari kushandiswa uye bhiriyoni yeSQLite databases iri kushandiswa .
Nekuda kwekureruka kwayo kwakanyanya, SQLite ndeimwe yeanonyanya kushandiswa dhatabhesi injini munyika. Inoshandiswa muzvirongwa zvakawanda zvevatengi uye zvakare inozivikanwa zvakanyanya mumasisitimu akaiswa, kusanganisira mazhinji emazuva ano mafoni.
Saizi haisi zvese kune anozvininipisa musiki weSQLite, se Sezviri pachena ane pfungwa yekushandura purojekiti kuita chimwe chinhu chinobatsira, sezvo akadaro asingagamuchire zvikwereti zvemamiriyoni emakopi anoshandiswa nevashambadziri nevasiri vekutengesa uye pachiitiko ichi, anotaura kuti haafarire chikamu chemari uye mukutarisira kupokana kwake, kutsamwiswa kwake kunoenda kune imwe. kusvika.
Iyi inzira isina kujairika, kunyangwe munyika yemahara software. Yakawanda yakavhurika sosi kodhi inopihwa rezinesi pasi pechibvumirano chakadai seGNU GPL (General Public License), iyo inosanganisira mazwi anovimbisa kuti software inoramba yakasununguka, kunyange nhasi vagadziri vanoverengeka vezvirongwa zvakakosha vasvika kumagumo, kwavasingapokane zvachose kuti zvigadzirwa zvavo hazvina kuwana rutsigiro kubva kune vekutengesa vashandisi (chimwe chinhu chakafanana neiyo QT yakasvika).
"Ndakapfuura nemarezinesi ese," anodaro Hipp, "ndofunga, wadii kungoiisa pachena? Kuisirei izvi zvirambidzo pazviri? Ndaisambotarisira kuwana kana dime. Ndaingoda kuita kuti vamwe vanhu vagadzirise dambudziko ravo. »
"Hatisi kuedza kukwikwidzana nemamwe mainjini," anodaro Hipp. "Chinangwa chedu hachisi chekuwedzera marudzi ese emabhero nemuridzo, asi kuchengetedza SQLite idiki uye nekukurumidza. Isu tinoisa muganho usingabvumirwe kuchengetedza nzvimbo yeraibhurari iri pasi pe250KB. "
Pakupedzisira, Glauber Costa anotaura kuti «kubudirira kweSQLite kwakasanganiswa nekukura kwayo kwakavharika kunoita kuti zviome kuti forogo ibudirire, imwe sarudzo ndeyekuputira SQLite nekuwedzera kushanda, asi izvi zvine painogumira”, uko Costa anonongedza.
mabviro: https://devclass.com/