Ukukhutshwa kweSQLite 3.37, i-DBMS ekhaphukhaphu eyenzelwe njengelayibrari yeplagi, ishicilelwe. Ikhowudi yeSQLite isasazwa kwindawo yoluntu, okt. ingasetyenziswa ngaphandle kwezithintelo kwaye simahla kuyo nayiphi na injongo. Inkxaso yemali kubaphuhlisi beSQLite inikezelwa yi-consortium eyenziwe ngokukodwa, equka iinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley kunye ne-Bloomberg.
Utshintsho oluphambili:
- Inkxaso eyongeziweyo yokudala iitheyibhile kunye ne-"STRICT" yophawu, efuna uhlobo olunyanzelekileyo lwesalathiso xa ichaza iikholamu kwaye isebenzise uhlobo olungqongqo lokujonga ukulinganisa idatha yongezwa kwiikholomu. Xa le flegi iseti, i-SQLite iya kubonisa imposiso ukuba akunakwenzeka ukuphosa idatha ekhankanyiweyo kuhlobo lomhlathi. Umzekelo, ukuba ikholamu yenziwe njenge "INTEGER", ukugqithisa ixabiso lomtya '123' kuya kubangela ukuba inani 123 lidityaniswe, kodwa ukuzama ukukhankanya 'xyz' kuya kusilela.
- Kumsebenzi othi "ALTER TABLE ADD COLUMN", isheke seemeko zokuba khona kwemiqolo yongezwe xa ukongeza iikholomu kunye neetshekhi ezisekelwe kwintetho ethi "CHECK" okanye ngeemeko "NOT NULL".
- Kwenziwa ibinzana elithi βPRAGMA table_listβ ukubonisa ulwazi malunga neetafile kunye nezimvo.
- I-interface yomgca womyalelo isebenzisa umyalelo othi ".connection", okuvumela ukuba uxhase ngexesha elifanayo uxhulumaniso oluninzi kwisiseko sedatha.
- Kongezwe iparameter ethi "-safe", evala imiyalelo ye-CLI kunye neentetho zeSQL ezikuvumela ukuba wenze imisebenzi ngeefayile zedatha eyahlukileyo ukusuka kwisiseko sedatha esichazwe kumgca womyalelo.
- I-CLI iye yalungisa ukusebenza kokufunda iintetho zeSQL ezahlulwe zibe yimigca emininzi.
- Imisebenzi eyongezelelweyo sqlite3_autovacuum_pages(), sqlite3_changes64() kunye ne sqlite3_total_changes64().
- Umcwangcisi wemibuzo uqinisekisa ukuba UKUMISELWA NGOKUQHUBEKA kwamagatya kwi-subqueries kunye neembono azihoywa ngaphandle kokuba ukususa loo mihlathi ayitshintshi i-semantics yombuzo.
- Ulwandiso lwe-generity_series(START,END,STEP) lutshintshiwe, iparameter yokuqala apho (βSTARTβ) yenziwe yanyanzeleka. Ukubuyisela impatho endala, kuyenzeka ukuba uphinde wakhe ngo "-DZERO_ARGUMENT_GENERATE_SERIES" ukhetho.
- Ukunciphisa ukusetyenziswa kwememori yokugcina i-schema yedatha.
umthombo: opennet.ru