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 aiwatar bambance-bambancen umarnin ANALYZE, wanda ke ba ku damar samun ta tare da tarin ƙididdiga na ɓangarori a cikin manyan ma'ajin bayanai, ba tare da cikakken binciken fihirisa ba. Iyaka akan adadin bayanan lokacin da aka saita fihirisa ɗaya ta amfani da sabon umarnin"".
- An ƙara sabon tebur mai kama-da-wane"", wanda ke ba da bayani game da maganganun da aka riga aka shirya ().
- Ƙara VFS Layer , wanda ke ƙara ƙididdiga na 8-byte zuwa ƙarshen kowane shafi na bayanai da ke cikin ma'ajin bayanai da kuma bincika su a duk lokacin da aka karanta su daga bayanan. Layin yana ba ku damar gano lalacewar bayanan bayanai sakamakon bazuwar ɓarna na raguwa a cikin na'urorin ajiya.
- An ƙara sabon aikin SQL , mayar da darajar Y idan magana X gaskiya ce, ko Z in ba haka ba.
- SAKA da KYAUTA maganganun yanzu koyaushe nau'ikan ginshiƙan daskarewa () kafin auna yanayin da ke cikin toshe .
- An ƙara iyaka akan adadin sigogi daga 999 zuwa 32766.
- Ƙara tsawo tare da aiwatar da rarrabuwar kawuna wanda ke yin la'akari da lambobi a cikin rubutu don warware wannan rubutun a cikin tsari na lambobi.
- A cikin layin umarni, an ƙara zaɓuɓɓukan "-csv", "-ascii" da "-skip" zuwa umarnin ".import". Umurnin ".dump" yana ba da damar amfani da samfuran LIKE da yawa tare da haɗawar fitarwa na duk teburin da ke daidai da ƙayyadadden abin rufe fuska. An ƙara umarnin ".oom" don gina gyara kuskure. Ƙara zaɓin "--bom" zuwa ".excel", ".fitarwa" da ". sau ɗaya" umarni. Ƙara zaɓin "--schema" zuwa umurnin ".filectrl".
- Maganar ESCAPE da aka kayyade tare da ma'aikacin LIKE yanzu ya soke katunan daji, daidai da halayyar PostgreSQL.
Bugu da ƙari, za mu iya lura da haɓakar sabon DBMS , wanda ke haɓaka bambance-bambancen SQLite da aka inganta don aiwatarwa .
Baya ga lambar harsashi daga SQLite, aikin yana amfani da parser daga PostgreSQL da ɓangaren Lissafin Kwanan wata daga , nasa aiwatar da ayyukan taga (dangane da Segment Tree Aggregation algorithm), injin aiwatar da binciken vectorized (bisa ga Hyper-Pipeling Query Execution algorithm), tushen laburare na yau da kullun , nasa mai inganta tambaya da tsarin MVCC don gudanar da aiwatar da ayyukan yi lokaci guda (Multi-Version Concurrency Control).
Lambar aikin ƙarƙashin lasisin MIT. Ci gaba har yanzu yana kan mataki sakewa na gwaji.
source: budenet.ru