An buga sakin SQLite 3.37, 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 don ƙirƙirar teburi tare da sifa "STRICT", wanda ke buƙatar alamar nau'in tilas lokacin bayyana ginshiƙai kuma yana aiwatar da tsauraran matakan daidaita nau'in don bayanan da aka ƙara zuwa ginshiƙan. Lokacin da aka saita wannan tutar, SQLite zai nuna kuskure idan ba zai yiwu a jefa ƙayyadadden bayanai ba zuwa nau'in shafi. Misali, idan an ƙirƙiri ginshiƙi a matsayin "INTEGER", to wucewa ƙimar kirtani '123' zai haifar da ƙara lamba 123, amma ƙoƙarin tantance 'xyz' ba zai yi nasara ba.
- A cikin aikin "ALTER TABLE ADD COLUMN", an ƙara duba sharuɗɗan wanzuwar layuka yayin ƙara ginshiƙai tare da cak dangane da kalmar "DUBI" ko tare da sharuɗɗan "NOT NULL".
- An aiwatar da kalmar "PRAGMA table_list" don nuna bayanai game da teburi da ra'ayoyi.
- Tsarin layin umarni yana aiwatar da umarnin ".connection", wanda ke ba ku damar tallafawa haɗin kai da yawa a lokaci guda zuwa bayanan bayanai.
- An ƙara ma'aunin "-lafiya", wanda ke hana umarnin CLI da maganganun SQL waɗanda ke ba ku damar yin aiki tare da fayilolin bayanai waɗanda suka bambanta da bayanan da aka kayyade akan layin umarni.
- CLI ta inganta aikin karanta maganganun SQL zuwa layi daya.
- Ƙara ayyuka sqlite3_autovacuum_pages(), sqlite3_changes64() da sqlite3_total_changes64().
- Mai tsara tsarin tambaya yana tabbatar da cewa ba a yi watsi da ORDER BY jumla a cikin tambayoyin da ra'ayoyi ba sai dai idan cire waɗannan sassan ba zai canza ma'anar tambayar ba.
- An canza jerin abubuwan haɓakawa (START, END, STEP), matakin farko wanda ("START") ya zama tilas. Don dawo da tsohon hali, yana yiwuwa a sake ginawa tare da zaɓin "-DZERO_ARGUMENT_GENERATE_SERIES".
- Rage yawan amfani da ƙwaƙwalwar ajiya don adana tsarin tsarin bayanai.
source: budenet.ru