Horumarka mashruuca Postgres WASM, kaas oo horumariya bay'ad leh PostgreSQL DBMS oo ku dhex socda browserka, ayaa la furay. Koodhka la xidhiidha mashruuca waxa uu ku furan yahay shatiga MIT. Waxay bixisaa qalab lagu ururiyo mashiinka farsamada ee ku shaqeeya browserka leh jawi Linux ah oo hoos loo dhigay, server PostgreSQL 14.5 iyo adeegyada la xidhiidha (psql, pg_dump). Cabbirka ugu dambeeya ee dhismuhu waa ilaa 30 MB.
Mashiinka casriga ah waxaa lagu dhisay iyadoo la adeegsanayo qoraallada dhista waxaana lagu bilaabay browserka iyadoo la adeegsanayo v86 emulator. qolof shabakadeed ayaa la bixiyaa si ay ula falgalaan adeegyada PostgreSQL ee browserka. Si aad u gasho server-ka PostgreSQL ee ku dhex shaqeeya shabakada shabakada oo aad u qabato codsiyada shabakada mashiinka farsamada, wakiil ayaa la isticmaalaa kaas oo gudbiya taraafikada iyadoo la isticmaalayo Websocket API.
Tilmaamaha ugu muhiimsan ee Postgres WASM:
- Kaydinta iyo soo celinta gobolka DBMS faylka ama kaydinta ku salaysan browserka ee ku salaysan IndexedDB.
- Si deg deg ah uga soo dejiso fayl leh xaalada badbaadsan ee mashiinka farsamada ama bilaabida buuxda oo dib loo bilaabo emulator-ka.
- Awoodda lagu qoondeeyo 128 ilaa 1024 MB ee xusuusta mashiinka farsamada.
- Dejinta cabbirka farta ee terminalka shabakadda.
- Taageerada gelinta faylasha deegaan toos ah, oo ay ku jirto awoodda lagu shubo qashinka kaydka.
- Taageerada soo dejinta faylalka jawiga casriga ah.
- Sameynta isku xirka shabakadaha soo galaya iyo kuwa baxaya, abuurista tunnel loogu gudbiyo wicitaanada dekeda shabakada 5432.
Meelaha suurtogalka ah ee codsiga Postgres WASM waxaa ka mid ah abuurista bandhigyo iyo nidaamyo tababaro, habeynta shaqada xogta qaabka offline, falanqaynta xogta inta lagu jiro qaabka offline, tijaabinta shaqada PostgresSQL iyo qaabeynta, abuurista jawi horumariye maxalli ah, diyaarinta qaybo gaar ah. Gobolka DBMS ee loogu diro kuwa kale horumariyayaal ama adeega taageerada, tijaabinta ku celcelinta macquulka ah ee DBMS-yada dibadda.
Source: opennet.ru