Kuburitswa kweSQLite 3.38, 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 rutsigiro rwe -> uye ->> vanoshanda kuti zvive nyore kuburitsa data muJSON fomati. Iyo itsva opareta syntax inoenderana neMySQL uye PostgreSQL.
- Chimiro chikuru chinosanganisira mabasa ekushanda nedata muJSON fomati, kubatana kwaimboda kuungana ne "-DSQLITE_ENABLE_JSON1" mureza. Kudzima rutsigiro rweJSON, "-DSQLITE_OMIT_JSON" mureza wawedzerwa.
- Yakawedzera unixepoch () basa rinodzosa epochal nguva (nhamba yemasekonzi kubvira Ndira 1, 1970).
- Kune mabasa anoshanda nenguva, iyo "auto" uye "julianday" modifiers yaitwa.
- Iyo SQL function printf() yakatumidzwa zita rekuti fomati () kuvandudza kuenderana nemamwe maDBMS (rutsigiro rwezita rekare rinochengetwa).
- Yakawedzera iyo sqlite3_error_offset() interface kuti zvive nyore kutsvaga zvikanganiso mumubvunzo.
- Mapurogiramu matsva ekubatanidza akawedzerwa pakuitwa kwematafura chaiwo: sqlite3_vtab_distinct(), sqlite3_vtab_rhs_value() uye sqlite3_vtab_in(), pamwe nemhando itsva dzevashandi SQLITE_INDEX_CONSTRAINT_LIMIT uye SQLITE_INDEX_CONSTRAINT_OFFSET.
- Iyo yekuraira mutsara interface inovimbisa kubata kwakaringana kwetabhu uye mutsara feed mavara mune zvinyorwa zvinobuda mune akawanda-column modes. Yakawedzerwa rutsigiro rwekushandisa iyo "--wrap N", "--wordwrap pa" uye "-quote" sarudzo paunenge uchiburitsa kune akawanda makoramu. The .import command inobvumira kururamiswa kwemazita emakoramu.
- Kumhanyisa kuitwa kwemibvunzo mikuru yekuongorora, murongi wemubvunzo anoshandisa probabilistic bloom sefa chimiro kuona kana chinhu chiripo museti. Muti wekubatanidza wakaenzana unoshandiswa kukwenenzvera kugadziridzwa kweUNION uye UNION ALL mabhuroko anotenderera SARUDZWA zvirevo zvine ORDER BY clauses.
Pamusoro pezvo, iwe unogona kucherechedza kuburitswa kweshanduro yesqlite-utils 3.24 set, iyo inosanganisira zvishandiso uye raibhurari yekushandura mafaera kubva kuSQLite dhatabhesi. Mashandiro akadai sekurodha zvakananga kweJSON, CSV kana TSV data mudhatabhesi faira ine otomatiki kugadzirwa kweinodiwa yekuchengetedza, kuitisa SQL mivhunzo pamusoro peCSV, TSV neJSON mafaera, yakazara-mavara kutsvaga mudhatabhesi, kushandura data uye zvirongwa zvekuchengeta. mumamiriro ezvinhu apo ALTER isingashandiswi inotsigirwa TABLE (somuenzaniso, kuchinja rudzi rwemakoramu), kubvisa makoramu mumatafura akasiyana.
Source: opennet.ru