Kuburitswa kweSQLite 3.41, isingaremi DBMS yakagadzirwa senge plug-in raibhurari, yakaburitswa. Iyo SQLite kodhi inogoverwa munharaunda yeruzhinji, i.e. inogona kushandiswa pasina zvirambidzo uye pasina muripo kune chero chinangwa. Rutsigiro rwemari rwevagadziri veSQLite rwunopihwa nemubatanidzwa wakanyatsogadzirwa, unosanganisira makambani akadai seAdobe, Oracle, Mozilla, Bentley neBloomberg.
Shanduko huru:
- Optimizations yakaitwa kune query planner, inokanganisa mibvunzo yakaunganidzwa neGROUP BY clause, kushandiswa kwe indexes, kushandiswa kwema coroutines pachinzvimbo chekugadzirisa subqueries uye maonero, iyo json_tree () uye json_each () mabasa.
- Yakawedzerwa yekuwedzera nebase64 uye base85 mabasa, ayo ave kuwanikwawo mune yekuraira mutsara interface (CLI).
- Yakawedzerwa ".scanstats est" raira kuCLI kuti iongorore mafambisirwo emubvunzo wekuronga.
- Iyo CLI inopa shanduko kune yekumisikidza yekumisikidza kuratidza kuti nzvimbo yekuisa iri mukati metambo chaiyo, kutaura, identifier, kana trigger tsananguro.
- Kana uchitsanangura iyo "-safe" yekuraira mutsara sarudzo, rondedzero yenjodzi SQL mabasa anogona kuvharwa anowedzerwa.
- Nekumisikidza, iyo modhi inobvumira tambo literals kuvharirwa mumakotesheni maviri inovharwa.
- Iyo PRAGMA integrity_check command inovimbisa kuti mavara tambo mumutambo wetafura kana uchishandisa akasiyana byte kurongeka mune index.
- Iyo parser ikozvino inofuratira mamwe maparenthes akatenderedza subquery yakatsanangurwa kurudyi rweIN opareta, izvo zvinoenderana nePostgreSQL maitiro (kare, SQLite yaibata zvidiki zvakadaro sechiratidziro chiri pasi pe "LIMIT 1" chinomanikidza).
Source: opennet.ru