An buga sakin SQLite 3.38, DBMS mai nauyi wanda aka tsara azaman ɗakin karatu na toshe, an buga shi. 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.
Babban canje-canje:
- Ƙara goyon baya ga -> da ->> masu aiki don sauƙaƙe fitar da bayanai a cikin tsarin JSON. Sabuwar tsarin aiki na mai aiki ya dace da MySQL da PostgreSQL.
- Babban tsarin ya ƙunshi ayyuka don aiki tare da bayanai a cikin tsarin JSON, haɗin da aka haɗa a baya yana buƙatar taro tare da "-DSQLITE_ENABLE_JSON1". Don kashe goyan bayan JSON, an ƙara tutar "-DSQLITE_OMIT_JSON".
- Ƙara aikin unixepoch() wanda ke dawo da lokacin epochal (yawan daƙiƙa tun 1 ga Janairu, 1970).
- Don ayyukan da ke aiki tare da lokaci, an aiwatar da gyare-gyaren "auto" da "julianday".
- Aikin SQL printf() an sake masa suna zuwa tsari() don inganta dacewa da sauran DBMSs (an riƙe goyon bayan tsohon suna).
- An ƙara ƙirar sqlite3_error_offset() don sauƙaƙa gano kurakurai a cikin tambaya.
- An ƙara sabbin mu'amalar shirye-shiryen zuwa aiwatar da allunan kama-da-wane: sqlite3_vtab_distinct (), sqlite3_vtab_rhs_value() da sqlite3_vtab_in(), da kuma sabbin nau'ikan ma'aikata SQLITE_INDEX_CONSTRAINT_LIMIT da SQLITE_INDEX_CONSTRAINT_OFFS.
- Tsarin layin umarni yana tabbatar da daidai sarrafa shafi da haruffan ciyarwar layi a cikin fitowar rubutu a cikin yanayin ginshiƙai da yawa. Ƙara goyon baya don amfani da zaɓin "--wrap N", "--wordwrap on" da "-quote" zaɓuɓɓukan lokacin fitarwa zuwa ginshiƙai da yawa. Umurnin shigo da kaya yana ba da damar gyara sunayen shafi.
- Don hanzarta aiwatar da manyan tambayoyin bincike, mai tsara tambaya yana amfani da tsarin tace furanni mai yuwuwa don tantance ko wani abu yana cikin saiti. Ana amfani da madaidaicin bishiyar haɗakarwa don haɓaka aiki na UNION da UNION DUKAN tubalan da ke tattare da zaɓen kalamai tare da ORDER BY clauses.
Bugu da ƙari, zaku iya lura da buga sigar ƙirar sqlite-utils 3.24, wanda ya haɗa da kayan aiki da ɗakin karatu don sarrafa fayiloli daga bayanan SQLite. Ayyuka kamar ƙaddamar da bayanan JSON, CSV ko TSV kai tsaye a cikin fayil ɗin bayanai tare da ƙirƙirar atomatik na tsarin ajiya mai mahimmanci, aiwatar da tambayoyin SQL akan fayilolin CSV, TSV da JSON, binciken cikakken rubutu a cikin ma'ajin bayanai, canza bayanai da tsare-tsaren ajiya. A cikin yanayin da ALTER ba ya aiki ana tallafawa.TABLE (misali, don canza nau'in ginshiƙai), cire ginshiƙai zuwa tebur daban.
source: budenet.ru