Uphuhliso lweprojekthi ye-Postgres WASM, ephuhlisa imo engqongileyo kunye ne-PostgreSQL DBMS esebenza ngaphakathi kwesikhangeli, ivuliwe. Ikhowudi ehambelana neprojekthi ivuliwe phantsi kwelayisenisi ye-MIT. Ibonelela ngezixhobo zokudibanisa umatshini wenyani osebenza kwisikhangeli esinendawo yeLinux ehluthiweyo, iseva ye-PostgreSQL 14.5 kunye nezixhobo ezinxulumeneyo (psql, pg_dump). Ubungakanani bokugqibela bokwakha bumalunga ne-30 MB.
Umatshini wenyani wakhiwe kusetyenziswa izikripthi ze-buildroot kwaye ziqaliswe kwisikhangeli kusetyenziswa i-emulator ye-v86. Iqokobhe lewebhu linikezelwe ukusebenzisana ne-PostgreSQL eziluncedo ukusuka kwisikhangeli. Ukufikelela kwiseva yePostgreSQL esebenza kwisikhangeli kwinethiwekhi kwaye wenze izicelo zenethiwekhi kumatshini obonakalayo, kusetyenziswa iproksi ehambisa itrafikhi kusetyenziswa iWebsocket API.
Iimpawu eziphambili zePostgres WASM:
- Ukugcina nokubuyisela imeko ye-DBMS kwifayile okanye kwi-browser-based storage esekelwe kwi-IndexedDB.
- Ukuqaliswa ngokukhawuleza kwifayile enemo egciniweyo yomatshini wenyani okanye uphehlelelo olupheleleyo ngokuqalisa ngokutsha i-emulator.
- Ukukwazi ukwaba ukusuka kwi-128 ukuya kwi-1024 MB yememori kumatshini wenyani.
- Ukucwangcisa ubungakanani befonti yetheminali yewebhu.
- Inkxaso yokulayisha iifayile kwindawo ebonakalayo, kuquka ukukwazi ukulayisha i-database dumps.
- Inkxaso yokukhuphela iifayile kwindawo yenyani.
- Ukuseka imidibaniso yenethiwekhi engenayo naphumayo, ukwenza itonela yokuthumela iifowuni kwi-network port 5432.
Phakathi kwemimandla enokwenzeka yokusetyenziswa kwe-Postgres WASM kukudalwa kweenkqubo zokubonisa kunye noqeqesho, ukulungelelanisa umsebenzi kunye nedatha kwimodi engaxhunyiwe kwi-intanethi, ukuhlalutya idatha ngelixa ukwimo engaxhunyiwe kwi-intanethi, ukuvavanya ukusebenza kwe-PostgresSQL kunye noqwalaselo, ukudala indawo yokuphuhlisa indawo, ukulungiselela iziqwenga zendlela ethile. I-DBMS karhulumente yokuthumela kwabanye abaphuhlisi okanye inkonzo yenkxaso, ukuvavanya ukuphindaphinda okunengqiqo ukusuka kwi-DBMS yangaphandle.
umthombo: opennet.ru