SQLite iyinjini yedatha yobudlelwano engasindi, efinyeleleka ngolimi lwe-SQL. Ngokungafani namaseva wedatha yendabuko, njenge-MySQL noma i-PostgreSQL, ukubonakala kwayo akuyona into yokukhiqiza kabusha uhlelo olujwayelekile lwamakhasimende, kepha ukuhlanganisa ngqo ezinhlelweni.
Imininingwane ephelele (izitatimende, amatafula, izinkomba kanye nedatha) igcinwa kwifayela elizimele lepulatifomu. Ngenxa yokukhanya kwayo okwedlulele, phakathi kwabanye, isetshenziswa ezinhlelweni eziningi zabathengi futhi futhi ithandwa kakhulu ezinhlelweni ezishumekiwe, kufaka phakathi ama-smartphones anamuhla kakhulu.
Ngokungafani nohlelo lokuphathwa kwedatha yamakhasimende-server, injini ye-SQLite akuyona inqubo ezimele yodwa lapho uhlelo olukhulu luxhumana khona. Esikhundleni salokho, umtapo wezincwadi we-SQLite uxhunyaniswe nohlelo oluba yingxenye 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 entsha ye-SQLite 3.32.0, lapho kwenziwe khona izinguquko eziningana futhi phakathi kwazo kugqanyiswa uhlobo olunzima lomyalo we-ANALYZE, okuyinto ivumela imininingwane eminingana emikhulu kakhulu ukubhekana nokuqoqwa okuyingxenye kwezibalo futhi ngaphandle kokuhlaziywa okuphelele kwama-indices. Umkhawulo wenombolo yamarekhodi lapho kuthwetshulwa inkomba eyodwa isethwe kusetshenziswa inkomba entsha "PRAGMA analysis_limit".
Olunye ushintsho oluza kule nguqulo entsha ye-SQLite ngu itafula elisha elibonakalayo "Bytecode", okuyi inikeza ulwazi mayelana nekhodi yokudlula yezitatimende ezilungiselelwe.
Futhi, kungezwe ungqimba lwe-checksum VFS, engeza amasheke ama-8-byte ekugcineni kwekhasi ngalinye ledatha ku-database futhi ubheke njalo lapho ifundwa kusuka ku-database. Isendlalelo esiphakathi singathola inkohlakalo yedatha njengomphumela wokuhlanekezelwa okungahleliwe kumadivayisi wesitoreji.
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 ne-UPDATE manje zihlala zisebenza ukuphina izimo zohlobo lwekholomu ngaphambi kwebhulokhi yokubalwa kwe-CHECK nomkhawulo wenani lamapharamitha kwandisiwe kusuka ku-999 kuye ku-32766.
Kwezinye izinguquko ezigqamile yale nguqulo entsha:
- 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 ukwazi kabanzi ngayo mayelana nokukhishwa kwale nguqulo entsha, ungabheka uhlu lwezinguquko Kulesi sixhumanisi esilandelayo.
Landa
Kulabo abanentshisekelo yokukwazi ukufaka le nguqulo entsha ye-SQLite kusistimu yabo, bazokwazi ukuthola amaphakheji kusuka kuwebhusayithi yabo esemthethweni esigabeni sayo sokulanda lapho kukhona khona ikhodi yomthombo (yokuhlanganiswa), kanye namaphakeji ahlelwe ngaphambilini atholakala.