SQLite injini yakareruka dhatabhesi
The kuburitswa kweiyo vhezheni itsva yeakakurumbira DBMS "SQLite 3.40", DBMS yakareruka yakagadzirwa seraibhurari yeplugin.
SQLite iine huremu relational database injini inowanikwa kuburikidza nemutauro weSQL. Kusiyana nemasevhisi echinyakare edhatabhesi, akadai seMySQL kana PostgreSQL, hunhu hwayo hausi kuburitsa yakajairwa mutengi-server schema, asi kubatanidza zvakananga muzvirongwa. Muchokwadi, iyo dhatabhesi yese (zvirevo, matafura, indexes, uye data) inochengetwa mupuratifomu-yakazvimirira faira.
Nekuda kwekureruka kwayo kwakanyanya, SQLite ndeimwe yeanonyanya kushandiswa dhatabhesi injini munyika. Inoshandiswa muzvirongwa zvakawanda zvevatengi uye zvakare inozivikanwa zvakanyanya mumasisitimu akaiswa, kusanganisira mazhinji emazuva ano mafoni.
Main nyowani maficha eSQLite 3.40
Muiyi vhezheni itsva inoratidzwa, zvinoratidzwa kuti a kuyedza kugona kuunganidza SQLite muWebAssembly kodhi Yepakati iyo inogona kumhanya muwebhu browser uye inokodzera kuronga basa redhatabhesi kubva pawebhu maapplication mumutauro weJavaScript.
Vagadziri veWebhu vane chimiro chepamusoro-chepamusoro chechinhu chekushanda nedata muchimiro chesql.js kana Node.js, kubatanidza yakaderera-level C API uye API yakavakirwa paWebhu Worker mechanism inobvumidza iwe kugadzira asynchronous controllers. kuti vanomhanya neshinda dzakasiyana. Iyo data inochengetwa nemaapplication ewebhu muWASM vhezheni yeSQLite inogona kuchengetwa kudivi revatengi uchishandisa OPFS (Origin-Private FileSystem) kana iyo window.localStorage API.
Imwe shanduko inomira pachena mune iyi vhezheni itsva ndeye yakagadziridzwa query planner performance, Pamusoro pezvo, zvirambidzo pakushandisa indexes ane matafura anopfuura makumi matanhatu nematatu makoramu zvakabviswa (kare indexing haina kushandiswa pakushanda nemakoramu ayo ordinal nhamba yaipfuura 63).
SQLite 3.40 inotanga zvakare a yakavandudzwa indexing yezvinokosha zvinoshandiswa mukutaura, Zvakare yakamira kurodha tambo dzakakura uye mabhurobhu kubva kudiski paunenge uchigadzira iyo NOT NULL uye IS NULL vanoshanda. Materialization isingabatanidzwe kubva pakuona iyo yakazara scan inoitwa kamwe chete.
Mamwe macheki akawedzerwa pakuitwa kwe "PRAGMA Integrity_check" parameter. Semuyenzaniso, matafura asina STRICT hunhu haafanire kuve nenhamba dzenhamba mumakoramu ezvinyorwa uye tambo values ine manhamba mumakoramu enhamba.
Mukuwedzera kune izvi, zvinoratidzwa zvakare kuti Recovery extension yakawedzerwa, yakagadzirirwa kudzoreredza data kubva kune yakakuvadzwa database mafaira. Mutsara wekuraira unoshandisa ".recover" murairo kudzorera.
Yeimwe shanduko izvo zvinoratidzika kubva pane iyi nyowani vhezheni:
- Mune iyo codebase, pachinzvimbo che "char *" mhando, yakaparadzana sqlite3_filename mhando inoshandiswa kumiririra mazita emafaira.
- Yakawedzera basa remukati sqlite3_value_encoding().
- Yakawedzera SQLITE_DBCONFIG_DEFENSIVE maitiro kudzivirira kuchinja schema vhezheni yekuchengetera.
- Yakawedzerwawo kutarisa kurongeka kwemitsara mumatafura ne "WITHOUT ROWID" chiratidzo.
- Izwi rekuti "VACUUM INTO" rinotora zvigadziriso "PRAGMA synchronous" muaccount.
- Yakawedzera compiler sarudzo SQLITE_MAX_ALLOCATION_SIZE, iyo inokutendera iwe kudzikamisa saizi yezvivharo paunenge uchigovera ndangariro.
- Iyo algorithm yekugadzira nhamba dzepseudorandom dzakavakwa muSQLite yakatakurwa kubva pakushandisa RC4 rukova cipher kuenda kuChacha20.
- Inotenderwa kushandisa indexes ine zita rimwechete mune akasiyana data schemas.
- Performance optimizations yakaitwa kudzikisa CPU mutoro neanenge 1% panguva yakajairika chiitiko.
Pakupedzisira, kana iwe uchifarira kuziva zvakawanda nezvazvo Iwe unofanirwa kuziva kuti iyo SQLite kodhi yakagoverwa munharaunda yeruzhinji, ndiko kuti, inogona kushandiswa pasina zvirambidzo uye yemahara kune chero chinangwa.
Rutsigiro rwemari rwevagadziri veSQLite rwunopihwa nemubatanidzwa wakagadzirwa, unosanganisira makambani akadai seAdobe, Oracle, Mozilla, Bentley, uye Bloomberg.
Unogona kutarisa rumwe ruzivo nezve kuburitswa kutsva uku chinotevera chinongedzo.