Kuburitswa kweSQLite 3.36, 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:
- Zvabuda zve EXPLAIN QUERY PLAN command zvaitwa kuti zvive nyore kunzwisisa.
- Inovimbisa kuti kukanganisa kunogadzirwa paunenge uchiedza kuwana rowid muVIEW kana subquery. Kudzosa kugona kuwana rowid yemaonero, sarudzo yegungano "-DSQLITE_ALLOW_ROWID_IN_VIEW" inopihwa.
- Iyo sqlite3_deserialize() uye sqlite3_serialize() ma interfaces anogoneswa nekusarudzika. Kudzima, sarudzo yegungano "-DSQLITE_OMIT_DESERIALIZE" inopihwa
- VFS "memdb" inobvumira kugovaniswa kwe-in-memory dhatabhesi mukati mekubatana kwakasiyana kune imwechete maitiro chero bedzi zita re database richitanga ne "/".
- Iyo "EXISTS-to-IN" optimization yakaunzwa mukuburitswa kwekupedzisira, iyo yakadzora mamwe mibvunzo, yadzoserwa kumashure.
- Optimization yekubatanidza kugara uchitarisa yakagadziridzwa kushanda nemibvunzo pasina kusanganisa (join).
- Iyo REGEXP yekuwedzera inosanganisirwa muCLI.
Source: opennet.ru