kusunungura , DBMS isingaremi yakagadzirwa seraibhurari yeplug-in. Iyo SQLite kodhi inogoverwa senzvimbo yeruzhinji, i.e. inogona kushandiswa pasina kurambidzwa uye pasina muripo kune chero chinangwa. Rutsigiro rwemari rwevagadziri veSQLite rwunopihwa nemubatanidzwa wakanyatsogadzirwa, unosanganisira makambani akadai seAdobe, Oracle, Mozilla, Bentley neBloomberg.
chikuru :
- Yakawedzera SQLITE_DBCONFIG_DQS_DML uye SQLITE_DBCONFIG_DQS_DDL sarudzo ku sqlite3_db_config() kutonga kana single uye kaviri quote kubata kunogoneswa. SQlite pakutanga yaitsigira chero mamaki ekotesheni etambo uye zviziviso, asi SQL mwero unoda zvakajeka kushandiswa kwemakotesheni mamaki etambo literals uye kaviri quotation mamaki ezviziviso (senge mazita emakoramu). Maitiro eSQLite anoramba achitsigirwa nekusarudzika, uye sarudzo yekuvaka "-DSQLITE_DQS=0" inopihwa kuti ikwanise kutevedzera chiyero;
- Optimizations yakawedzerwa kune query planner kuti ikurumidze kushanda kweAND uye OR vafambisi kana imwe yema operands ichingogara, pamwe chete neLIKE opareta kana koramu yakatsanangurwa kuruboshwe iri manhamba;
- Yakawedzera tafura nyowani "sqlite_dbdata" kudzoreredza zvirimo pane sosi yedata data level, kunyangwe dhatabhesi yakashatiswa;
- MuCLI interface iyo ".recover" murairo, iyo inoedza kudzoreredza data kubva kune yakakuvadzwa dhatabhesi zvakanyanya sezvinobvira. Yakawedzerwawo ".filectrl" murairo wekuedza kuedza uye ".dbconfig" murairo wekuona kana kuchinja sqlite3_db_config() sarudzo.
Source: opennet.ru