Ukukhishwa kwe-SQLite 3.39, i-DBMS engasindi eklanywe njengomtapo wolwazi we-plug-in, kushicilelwe. Ikhodi ye-SQLite isatshalaliswa esizindeni 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.
Izinguquko eziyinhloko:
- Ukwesekwa okwengeziwe kokusebenza kokujoyina kwangaphandle okulungile nokugcwele emathebulani - "RIGHT OUTER JOIN" kanye "FULL OUTER JOIN".
- Ama-opharetha amasha okuqhathanisa ahlongozwayo - "AKUHLUKE NA" kanye "AKUHLUKE NAKHO", afana nama-opharetha atholakala ngaphambilini okuthi "IS" kanye "IS NOT", futhi kwengezwe ukuze kuthuthukiswe ukusebenzisana namazinga e-SQL kanye ne-PostgreSQL.
- Ezinhlelweni ze-Unix, zonke izixhumanisi ezingokomfanekiso kumagama esizindalwazi ziyanwetshwa ukuze kutholwe igama lesizindalwazi se-canonical ngaphambi kokuvula ifayela.
- Kuvunyelwe ukusebenzisa isisho esithi HAVING kunoma yimiphi imibuzo ehlanganisiwe, okuhlanganisa naleyo engaqukethe isisho esithi “GROUP BY”.
- Kusetshenziswe ukulungiselelwa okuncane okuningana, okuthe sekuphelele kwehlise umthwalo we-CPU ekuhlolweni ngo-2.3%.
Source: opennet.ru
