Iko kusimukira kwePostgres WASM purojekiti, iyo inovandudza nharaunda nePostgreSQL DBMS, inoshanda mukati mebrowser, yakavhurika. Iyo kodhi yakabatana neprojekiti yakavhurika sosi pasi peMIT rezinesi. A toolkit inokurudzirwa kuvaka muchina chaiwo unoshanda mubrowser ine yakabviswa-pasi Linux nharaunda, iyo PostgreSQL 14.5 server uye zvine hukama zvinoshandiswa (psql, pg_dump). Saizi yegungano rekupedzisira inenge 30 MB.
Kuzadzwa kwemuchina chaiwo unogadzirwa uchishandisa buildroot zvinyorwa uye kwakatangwa mubrowser uchishandisa v86 emulator. Iyo webhu shell inopihwa yekudyidzana nePostgreSQL zvishandiso kubva kubrowser. Kuti uwane iyo PostgreSQL server inomhanya mubrowser pamusoro petiweki uye kuita zvikumbiro zvenetiweki kubva kumuchina chaiwo, proxy inoshandiswa inoendesa mberi traffic uchishandisa iyo Websocket API.
Zvinhu zvakakosha zvePostgres WASM:
- Kuchengetedza uye kudzoreredza mamiriro eDBMS kubva pafaira kana browser chengetedzo yakavakirwa paIndexedDB.
- Kurumidza kuvhurwa kubva kufaira ine yakachengetwa mamiriro eiyo chaiyo muchina kana kuvhurwa kwakazara ne emulator restart.
- Iko kugona kugovera kubva ku128 kusvika ku1024MB yendangariro kumuchina chaiwo.
- Webhu terminal font size set.
- Tsigiro yekurodha mafaera kune chaiyo nharaunda, kusanganisira kugona kurodha dhatabhesi.
- Tsigiro yekurodha mafaera kubva kunharaunda chaiyo.
- Kugadzira inopinda uye inobuda network yekubatanidza, kugadzira mugero wekuendesa zvikumbiro kune network port 5432.
Pakati pezvinogona kushandiswa zvePostgres WASM ndiko kugadzirwa kwedemo uye masisitimu ekudzidzisa, kuronga basa nedata muoffline mode, kuongorora data uchiri pamhepo, kuyedza PostgresSQL mashandiro uye zvigadziriso, kugadzira nharaunda yekuvandudza nharaunda, kugadzira zvimedu zveimwe nyika. iyo DBMS yekutumira kune vamwe vagadziri kana timu yetsigiro, yekuyedza kudzokorora zvine musoro kubva kunze kweDBMS.
Source: opennet.ru