Kuburitswa kweSQLite 3.37, 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:
- Yakawedzerwa tsigiro yekugadzira matafura ane "STRICT" hunhu, iyo inoda inosungirwa mhando chiratidzo kana uchizivisa makoramu uye kushandisa yakasimba mhando yekufananidza cheki yedata rakawedzerwa kumakoramu. Kana mureza uyu waiswa, SQLite icharatidza kukanganisa kana zvisingaite kukanda iyo data yakatarwa kurudzi rwekoramu. Semuyenzaniso, kana koramu yagadzirwa se "INTEGER", kupfuudza kukosha kwetambo '123' kunoita kuti nhamba 123 iwedzere, asi kuedza kudoma 'xyz' kunotadza.
- Mukushanda kwe "ALTER TABLE ADD COLUMN", cheki yemamiriro ezvinhu ekuvapo kwemitsara yakawedzerwa pakuwedzera makoramu ane cheki zvichienderana ne "CHECK" kutaura kana ne "NOT NULL" mamiriro.
- Yaita chirevo che "PRAGMA table_list" kuratidza ruzivo nezve matafura uye maonero.
- Iyo yekuraira mutsara interface inoshandisa iyo ".connection" murairo, iyo inokubvumira iwe panguva imwe chete kutsigira akawanda ekubatanidza kune database.
- Yakawedzera "-safe" parameter, iyo inodzima mirairo yeCLI uye SQL mataurirwo ayo anobvumidza iwe kuti uite mashandiro nemafaira edatabase akasiyana kubva kudhatabhesi inotsanangurwa pamutsetse wekuraira.
- Iyo CLI yakagonesa kuita kwekuverenga SQL mataurirwo akapatsanurwa kuita mitsetse yakawanda.
- Akawedzera mabasa sqlite3_autovacuum_pages(), sqlite3_changes64() uye sqlite3_total_changes64().
- Murongi wemubvunzo anovimbisa kuti ORDER BY clauses mune subqueries uye maonero anofuratirwa kunze kwekunge kubvisa izvo clause kusachinja semantics yemubvunzo.
- Iyo yekuwedzera generate_series(START,END,STEP) yakashandurwa, iyo yekutanga parameter umo ("START") yakaitwa inosungirwa. Kudzosa maitiro ekare, zvinokwanisika kuvaka patsva uchishandisa "-DZERO_ARGUMENT_GENERATE_SERIES" sarudzo.
- Yakaderedzwa ndangariro kushandiswa kuchengetedza schema database.
Source: opennet.ru