ukukhululwa , i-DBMS engasindi edizayinelwe njengomtapo wolwazi ofakiwe. Ikhodi ye-SQLite isatshalaliswa njengesizinda somphakathi, i.e. ingasetshenziswa ngaphandle kwemikhawulo futhi mahhala nganoma iyiphi injongo. Usekelo lwezezimali lwabathuthukisi be-SQLite luhlinzekwa yinhlangano edalwe ngokukhethekile, ehlanganisa izinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley ne-Bloomberg.
main :
- Isisho esisetshenzisiwe ukuze ubuyekeze okuqukethwe kwethebula ngokusekelwe kokukhethiwe kwelinye ithebula. Isisho sisebenzisa i-syntax ehambisana ne-PostgreSQL.
- Usayizi omkhulu wesizindalwazi unyusiwe waba ngu-281 TB.
- В Ikhono lokuhlola ngokukhetha ithebula elithile kuphela kanye nezinkomba ezihambisanayo zinikeziwe (ngaphambilini yonke imininingwane egciniwe yayihlala ihlolisiswa).
- Kwengezwe isandiso ngemisebenzi yezibalo zedesimali enembayo.
- Ekwandiseni Ukuthuthukiswa kwenziwe ukusekela izinombolo ze-binary64.
- Kusixhumanisi somugqa womyalo (CLI) izindlela ezintsha zokufometha okukhiphayo “ibhokisi”, “json”, “markdown” kanye “nethebula”. Kumodi yokuphuma "yekholomu", amakholomu anwetshwa ngokuzenzakalelayo ngokusekelwe kokuqukethwe komugqa omude kakhulu. Kumodi yokuphuma "yokucaphuna", inani lesihlukanisi esimiswe umyalo ".separator" liyacatshangelwa.
- Izandiso zedesimali kanye ne-ieee754 zakhelwe ku-CLI.
- Ukuthuthukiswa kwenziwe kumhleli wemibuzo. Ukusebenza okuthuthukisiwe kwemibuzo ethi “KHETHA iminithi(x) KUSUKA LAPHO UNGENA (?,?,?)” uma inkomba ethi t(x,y) ikhona. Ukutholwa okusetshenzisiwe kwamathuba okusebenzisa uhlelo lombuzo lwenkomba egcwele yemibuzo enomusho othi “INDEXED BY”.
- Kwindlela (Bhala-Phambili Ukuloga) Uma umsebenzi wokubhala wehluleka, okuholela ekwephulweni kwedatha kufayela le-shm, okwenziwayo okulandelayo manje sekungakwazi ukubuyisela ubuqotho befayela le-shm uma kukhona imisebenzi yokufunda esebenzayo, esikhundleni sokuphonsa iphutha le-SQLITE_PROTOCOL.
Source: opennet.ru