kumasula , DBMS yopepuka yopangidwa ngati plug-in library. Khodi ya SQLite imagawidwa ngati malo a anthu onse, i.e. itha kugwiritsidwa ntchito popanda zoletsa komanso kwaulere pazifukwa zilizonse. Thandizo lazachuma kwa opanga ma SQLite limaperekedwa ndi bungwe lopangidwa mwapadera, lomwe limaphatikizapo makampani monga Adobe, Oracle, Mozilla, Bentley ndi Bloomberg.
waukulu :
- ntchito zazenera (ntchito zazenera kapena zowunikira zomwe zimalola kuti mzere uliwonse wa funso uwerenge pogwiritsa ntchito mizere ina): thandizo lowonjezera la mawu , zinakhala zotheka kugwiritsa ntchito ntchito zenera (zenera limodzi limatanthauzidwa m'dera lina), loperekedwa magulu pogwiritsa ntchito mawu a GROUP, ndi zoletsa za RANGE zimakhazikitsidwa и ;
- Kukhazikitsa bwino kwa lamulo "", yomwe tsopano ingagwiritsidwe ntchito ndi nkhokwe zomwe zilipo powerenga kokha;
- Anawonjezera kukhathamiritsa kwa mafunso atsopano: kagwiridwe ka mawu a LIKE pamodzi ndi mawu ofunika a ESCAPE komanso pamene "PRAGMA case_sensitive_like" mode yayatsidwa. Pamaso pa kuwunika kosafunikira kwa mikhalidwe yodziwika bwino yomwe yafotokozedwa MENE ndime yachotsedwa;
- Lamulo "»kwa ntchito (masks amalowetsedwa m'mawu aliwonse a SQL). Mu lamulo la ".archive", njira ya "--update" yakonzedwanso, yomwe tsopano ikudumpha mafayilo osasinthika omwe ali kale mu archive, ndipo "--insert" njira yawonjezedwa kuti ikhale ndi mafayilo muzosungira;
- Kuwonjezera anawonjezera , zomwe zimakulolani kupanga, kugwiritsa ntchito ndi kusokoneza Zosintha zakale za delta zomwe zimagwiritsidwa ntchito pakukulitsa kwa RBU;
- Kuchulukitsa kudalirika kogwira ntchito ndi mafayilo owonongeka a database;
- Kalilore wa nkhokwe ya polojekiti yakhazikitsidwa (zoyambira amathandizidwa pogwiritsa ntchito kuwongolera mtundu , yopangidwa ndi wolemba SQLite).
Source: opennet.ru