SQLite injin bayanai ne mara nauyi
The saki sabon sigar mashahurin DBMS “SQLite 3.40”, DBMS mai sauƙi wanda aka tsara azaman ɗakin karatu na plugin.
SQLite injin bayanai ne mai nauyi mai nauyi wanda ake samu ta harshen SQL. Ba kamar sabobin bayanai na gargajiya ba, irin su MySQL ko PostgreSQL, fifikonsa ba shine sake fasalin tsarin sabar abokin ciniki da aka saba ba, amma don haɗa kai tsaye cikin shirye-shirye. A zahiri, ana adana duk bayanan (bayani, teburi, fihirisa, da bayanai) a cikin fayil mai zaman kansa na dandamali.
Godiya ga matsanancin hasken sa, SQLite yana ɗaya daga cikin injunan bayanai da aka fi amfani da su a duniya. Ana amfani da shi a cikin shirye-shiryen masu amfani da yawa kuma yana shahara sosai a cikin tsarin da aka saka, gami da mafi yawan wayoyin hannu na zamani.
Babban sabon fasali na SQLite 3.40
A cikin wannan sabon sigar da aka gabatar, an yi nuni da cewa a ikon gwaji don tara SQLite cikin lambar WebAssembly Matsakaici wanda za'a iya gudanar da shi a cikin mai binciken gidan yanar gizo kuma ya dace da tsara ayyukan bayanai daga aikace-aikacen yanar gizo a cikin yaren JavaScript.
Masu haɓaka gidan yanar gizo suna da babban matakin abin da ya dace don aiki tare da bayanai a cikin salon sql.js ko Node.js, suna haɗa ƙaramin C API da API dangane da tsarin Ma'aikacin Yanar gizo wanda ke ba ku damar ƙirƙirar masu sarrafa asynchronous. cewa suna gudana akan zaren daban-daban. Bayanan da aikace-aikacen yanar gizo ke adanawa a cikin nau'in WASM na SQLite za a iya adana su a gefen abokin ciniki ta amfani da OPFS (Asali-System FileSystem) ko taga.localStorage API.
Wani canjin da ya fito a cikin wannan sabon sigar shine ingantaccen aikin mai tsara tambaya, Bugu da kari, an cire hane-hane lokacin amfani da fihirisa tare da allunan sama da ginshiƙai 63 (a baya ba a yi amfani da ƙididdiga don ayyuka tare da ginshiƙai waɗanda adadinsu ya wuce 63).
SQLite 3.40 kuma yana gabatar da a ingantattun kimar da aka yi amfani da su a cikin maganganu, Hakanan an dakatar da loda manyan igiyoyi da tsummoki daga diski lokacin sarrafa masu sarrafa NOT NULL da IS NULL. Abubuwan da aka keɓe daga ra'ayoyin waɗanda ake yin cikakken bincike sau ɗaya kawai.
An ƙara ƙarin bincike don aiwatar da sigar "PRAGMA Integrity_check". Misali, teburi ba tare da sifa STRICT ba bai kamata ya ƙunshi ƙimar lambobi a cikin ginshiƙan rubutu da ƙimar kirtani tare da lambobi a cikin ginshiƙan lamba ba.
Baya ga wannan, an kuma yi nuni da cewa an kara fadada farfadowa, wanda aka ƙera don dawo da bayanai daga fayilolin da aka lalace. Ƙididdigar layin umarni yana amfani da umarnin ".recover" don maidowa.
Na sauran canje-canje wanda ya fice daga wannan sabon sigar:
- A cikin codebase, maimakon nau'in "char *", ana amfani da nau'in sqlite3_filename daban don wakiltar sunayen fayil.
- Ƙara aikin ciki sqlite3_value_encoding().
- An ƙara yanayin SQLITE_DBCONFIG_DEFENSIVE don hana canza sigar tsarin ajiya.
- Hakanan an ƙara don duba daidaiton tsarin layuka a cikin tebur tare da alamar "BA TARE DA ROWID".
- Kalmar "VACUUM INTO" tana ɗaukar saitunan "PRAGMA synchronous" cikin lissafi.
- Ƙara zaɓin mai haɗawa SQLITE_MAX_ALLOCATION_SIZE, wanda ke ba ku damar iyakance girman tubalan lokacin rarraba ƙwaƙwalwar ajiya.
- Algorithm don ƙirƙirar lambobin pseudorandom da aka gina a cikin SQLite an fitar da shi daga amfani da sifar rafin RC4 zuwa Chacha20.
- An ba da izinin amfani da fihirisa masu suna iri ɗaya a cikin tsarin bayanai daban-daban.
- An inganta haɓaka aiki don rage nauyin CPU da kusan 1% yayin aiki na yau da kullun.
A ƙarshe, idan kuna sha'awar ƙarin sani game da shi Ya kamata ku sani cewa ana rarraba lambar SQLite a cikin jama'a, wato, ana iya amfani da shi ba tare da ƙuntatawa ba kuma kyauta ga 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.
Kuna iya duba ƙarin cikakkun bayanai game da wannan sabon sakin a mahada mai zuwa.