I-SQLite iyinjini yedathabheyisi yobudlelwano elula, efinyeleleka ngolimi lwe-SQL . Ngokungafani namaseva edathabheyisi endabuko, njenge-MySQL noma i-PostgreSQL, isici sayo esihlukile akusikho ukuphinda ukwakheka kweklayenti-seva evamile, kodwa kunalokho ukuhlanganisa ngqo ezinhlelweni.
Yonke i-database (izitatimende, amathebula, izinkomba, kanye nedatha) igcinwa kufayela elingasebenzisi ipulatifomu. Ngenxa yemvelo yayo elula kakhulu, phakathi kwezinye izizathu, isetshenziswa ezinhlelweni eziningi zabathengi futhi ithandwa kakhulu ezinhlelweni ezifakiwe, kufaka phakathi ama-smartphone akamuva.
Ngokungafani nezinhlelo zokuphathwa kwedathabheyisi yamakhasimende, injini ye-SQLite akuyona inqubo ehlukile uhlelo oluyinhloko oluxhumana nayo. Esikhundleni salokho , umtapo wolwazi we-SQLite uxhunywe ohlelweni, uba yingxenye ebalulekile yalo.
Uhlelo lusebenzisa ukusebenza kwe-SQLite ngezingcingo ezilula kuma-subroutines nemisebenzi. Lokhu kunciphisa ukubambezeleka kokufinyelela ku-database, ngoba izingcingo zomsebenzi zisebenza kangcono kunokuxhumana okuphakathi kwenqubo.
Yonke i-database (izincazelo, amatafula, izinkomba, kanye nedatha uqobo) kugcinwa njengefayela elilodwa elijwayelekile kumshini wokubamba. Lo mklamo olula utholakala ngokukhiya lonke ifayili ledatha ekuqaleni kokuthengiselana ngakunye.
Mayelana nenguqulo entsha ye-SQLite 3.32.0
Muva nje, kumenyezelwe inguqulo ye-SQLite 3.32.0, ehlanganisa izinguquko eziningana, ikakhulukazi inguqulo ethuthukisiwe yomyalo we-ANALYZE . Lokhu kuvumela ukuqoqwa okungaphelele kwezibalo ezivela kudathabheyisi enkulu kakhulu ngaphandle kokuhlaziywa okugcwele kwenkomba. Umkhawulo wenani lamarekhodi askeniwe kunkomba eyodwa usethwe kusetshenziswa isiqondiso esisha se-"PRAGMA analysis_limit".
Olunye ushintsho oluza kule nguqulo entsha ye-SQLite ithebula elisha elibonakalayo , elithi "bytecode," elinikeza ulwazi mayelana nekhodi ye-byte yezitatimende ezilungisiwe.
Ngaphezu kwalokho, kufakwe ungqimba lwe-VFS checksum, olufaka ama-checksum angu-8-byte ekugcineni kwekhasi ngalinye ledatha ku-database futhi luwaqinisekisa njalo lapho idatha ifundwa kusuka ku-database. Lolu ngqimba oluphakathi luvumela ukutholakala kokonakala kwe-database okubangelwa ukuphambuka kwe-bit okungahleliwe kumadivayisi okugcina.
Ngakolunye uhlangothi, kungezwe umsebenzi omusha we-SQL iif (X, Y, Z), kubuyiselwa inani Y uma isisho X siyiqiniso, noma uZ ngenye indlela.
Izinkulumo ze-INSERT kanye ne-UPDATE manje sezisebenzisa njalo izimo zohlobo lwekholomu ngaphambi kwebhulokhi yokubala ye-CHECK, futhi umkhawulo wenani lamapharamitha ukhushulwe kusuka ku-999 kuya ku-32766.
Ezinye izinguquko eziphawulekayo kule nguqulo entsha zifaka:
- Kungezwe isandiso sokulandelana kokuhlelwa kwe-UINT ngokusetshenziswa kokulandelana kohlobo okufaka izinombolo embhalweni ku-akhawunti ukuhlunga lo mbhalo ngokulandelana kwamanani.
- Ku-interface yomugqa womyalo, izinketho "--csv", "- ascii" ne "- skip" zengezwe kumyalo ".port".
- Umyalo we- ". Dump" uvumela ukusetshenziswa kwamathempulethi amaningi we-LIKE ngokuhlanganiswa kokukhishwa kwawo wonke amatafula ahambelana namaski abekiwe. Kungezwe umyalo we- ".oom" wokususa iphutha.
- Inketho ye - bom ingezwe kumiyalo ye- ".excel", ".putput" kanye ".once". Kungezwe inketho ye- –schema kumyalo we ".filectrl".
- Isisho se-ESCAPE esichazwe nge-opharetha we-LIKE manje sibhala ngaphezulu kwamakhadi wasendle, ahambisana nokuziphatha kwePostgreSQL.
Okokugcina, uma ufuna ukufunda kabanzi ngokukhishwa kwale nguqulo entsha, ungabheka uhlu lwezinguquko kusixhumanisi esilandelayo.
Landa
Kulabo abanesifiso sokufaka le nguqulo entsha ye-SQLite ohlelweni lwabo, amaphakheji angatholakala kuwebhusayithi yayo esemthethweni esigabeni sokulanda, lapho kutholakala khona ikhodi yomthombo (yokuhlanganiswa) namaphakheji ahlanganiswe kusengaphambili.