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 :
- Maganar da aka aiwatar don sabunta abubuwan da ke cikin tebur bisa zaɓi daga wani tebur. Maganar tana amfani da haɗin gwiwa daidai da PostgreSQL.
- An ƙara matsakaicin girman bayanan zuwa 281 TB.
- В An ba da ikon bincika takamaiman tebur kawai da fihirisa masu alaƙa (a da ana bincika duk bayanan bayanai koyaushe).
- Ƙara tsawo tare da madaidaicin ƙididdiga na ƙididdiga na ƙima.
- A fadada An inganta haɓaka don tallafawa lambobin binary64.
- Zuwa ga layin umarni (CLI) sabbin hanyoyin tsara kayan fitarwa "akwatin", "json", "markdown" da "tebur". A cikin yanayin fitarwa na "column", ana faɗaɗa ginshiƙai ta atomatik bisa abubuwan da ke cikin layi mafi tsayi. A cikin yanayin fitarwa na "quote", ana la'akari da ƙimar mai rarraba da umarnin ".separator" ya saita.
- An gina ƙawance na ƙima da ieee754 a cikin CLI.
- An yi gyare-gyare ga mai tsara tambaya. Ingantacciyar aikin "Zabi min(x) DAGA t INA y IN (?,?,?)" tambayoyin lokacin da index t(x,y) ke nan. Gano da aka aiwatar na yuwuwar amfani da cikakken shirin neman tambaya na fihirisa don tambayoyi tare da kalmar "INDEXED BY".
- A cikin yanayin (Rubuta-gaba da shiga) Idan aikin rubutu ya gaza, yana haifar da keta bayanai a cikin fayil ɗin shm, ma'amaloli na gaba yanzu na iya dawo da amincin fayil ɗin shm idan akwai ma'amalar karantawa mai aiki, maimakon jefa kuskuren SQLITE_PROTOCOL.
source: budenet.ru