Abubuwan ci gaba na aikin WASM na Postgres, wanda ke haɓaka yanayi tare da PostgreSQL DBMS da ke gudana a cikin mai bincike, an buɗe su. An buɗe lambar da ke da alaƙa da aikin a ƙarƙashin lasisin MIT. Yana ba da kayan aiki don haɗa injin kama-da-wane da ke gudana a cikin mai bincike tare da yanayin Linux wanda aka cire, sabar PostgreSQL 14.5 da abubuwan amfani masu alaƙa (psql, pg_dump). Girman ginin ƙarshe shine kusan 30 MB.
An gina injin kama-da-wane ta amfani da rubutun ginawa kuma an ƙaddamar da shi a cikin mashigar bincike ta hanyar amfani da nau'in v86. An ba da harsashi na yanar gizo don yin hulɗa tare da abubuwan amfani na PostgreSQL daga mai lilo. Don samun dama ga uwar garken PostgreSQL da ke gudana a cikin mai lilo akan hanyar sadarwar da kuma aiwatar da buƙatun hanyar sadarwa daga na'ura mai kama-da-wane, ana amfani da wakili wanda ke tura zirga-zirga ta amfani da Websocket API.
Babban fasali na Postgres WASM:
- Ajiye da dawo da yanayin DBMS daga fayil ko tushen ma'ajin bincike bisa IndexedDB.
- Ƙaddamar da sauri daga fayil tare da ajiyar yanayin injin kama-da-wane ko cikakken ƙaddamarwa tare da sake yin kwaikwaya.
- Ability don rarraba daga 128 zuwa 1024 MB na ƙwaƙwalwar ajiya zuwa na'ura mai mahimmanci.
- Saita girman font na tashar yanar gizo.
- Taimako don loda fayiloli a cikin mahallin kama-da-wane, gami da ikon loda jujjuyawar bayanai.
- Taimako don zazzage fayiloli daga yanayin kama-da-wane.
- Ƙirƙirar hanyoyin sadarwa masu shigowa da masu fita, ƙirƙirar rami don tura kira zuwa tashar sadarwa ta 5432.
Daga cikin abubuwan da za a iya amfani da su na Postgres WASM shine ƙirƙirar zanga-zangar da tsarin horo, tsara aiki tare da bayanai a cikin yanayin layi, nazarin bayanai yayin yanayin layi, gwada ayyukan PostgresSQL da daidaitawa, ƙirƙirar yanayin haɓaka gida, shirya yankan wani takamaiman. Jihar DBMS don aikawa zuwa wasu masu haɓakawa ko sabis na tallafi, gwada kwafi na ma'ana daga DBMSs na waje.
source: budenet.ru