saki , DBMS mai sauƙi wanda aka tsara azaman ɗakin karatu na toshewa. Ana rarraba lambar SQLite azaman yanki na jama'a, watau. ana iya amfani da shi ba tare da hani ba kuma kyauta don kowane dalili. Tallafin kuɗi na masu haɓaka SQLite yana samuwa ta hanyar haɗin gwiwa na musamman da aka ƙirƙira, wanda ya haɗa da kamfanoni kamar Adobe, Oracle, Mozilla, Bentley da Bloomberg.
Main :
- An ƙara SQLITE_DBCONFIG_DQS_DML da SQLITE_DBCONFIG_DQS_DDL zažužžukan zuwa sqlite3_db_config() don sarrafa ko an kunna sarrafa fa'ida ɗaya da sau biyu. Asalin SQlite yana goyan bayan duk wata alamar zance don kirtani da masu ganowa, amma ma'aunin SQL a sarari yana buƙatar amfani da alamomin zance guda ɗaya don madaidaicin kirtani da alamomin ambato biyu don masu ganowa (kamar sunayen shafi). Halin SQLite yana ci gaba da tallafawa ta tsohuwa, kuma ana ba da zaɓin ginin "-DSQLITE_DQS=0" don ba da damar bin ƙa'ida;
- An kara ingantawa ga mai tsara tambaya don hanzarta gudanar da ayyukan AND da OR a lokacin da daya daga cikin operands ya kasance akai-akai, da kuma mai sarrafa LIKE lokacin da ginshiƙi da aka ƙayyade a hagu yana da adadi;
- An ƙara sabon tebur mai kama-da-wane "sqlite_dbdata" don dawo da abun ciki a matakin bayanan ginshiƙi na tushen, koda kuwa bayanan sun lalace;
- A cikin CLI interface umarnin ".recover", wanda ke ƙoƙarin maido da bayanai daga cikin rumbun adana bayanai da suka lalace gwargwadon yiwuwa. Hakanan an ƙara shine umarnin ".filectrl" don gudanar da gwaje-gwaje da kuma umarnin ".dbconfig" don dubawa ko canza zaɓuɓɓukan sqlite3_db_config().
source: budenet.ru