Kwanan nan an sanar da shi ta hanyar sanarwa akan damar zuwa postgres-wasm kyauta, wanda shine sabar PostgreSQL wanda ke gudana a cikin burauza kuma yana ba da cikakken saitin fasali, gami da dagewar yanayi a cikin mai binciken, maidowa daga pg_dump, da kwafi mai ma'ana daga bayanan bayanan nesa.
postgres-wasm en aikin da aka saki a ƙarƙashin lasisin Buɗaɗɗen Tushen godiya wanda aka aika PostgreSQL zuwa WebAssembly. Wannan shine mafita da aka haɓaka godiya ga haɗin gwiwa tsakanin Supabase, mai ba da bayanan girgije, da Snaplet, kamfani na musamman a shirye-shiryen bayanai.
"A yau muna ƙaddamar da postgres-wasm tare da abokanmu a Snaplet," in ji Supabase Injiniya Mark Burggraf.
Ga wadanda basu sani ba postgres, ya kamata su san hakan yana ɗaya daga cikin mafi ci gaba tsarin sarrafa bayanan tushen tushen bayanai. Yana da wadataccen fasali, tare da nau'ikan bayanai masu ƙarfi, ƙididdigewa mai ƙarfi, da fa'idodin ginannun ayyuka da yawa waɗanda za a iya amfani da su don sauƙaƙe tarin bayanan da ba da damar masu haɓakawa su mai da hankali kan gina aikace-aikacen su. Postgres ya wuce bayanan alaƙa, ya zama amintaccen dandalin bayanan ku.
Game da Postgres-wasm
Supabase ba shine farkon wanda ya fara sanya Postgres yayi aiki a cikin mashigar yanar gizo ba; wannan taken yana zuwa ga ƙungiyar a Crunchy Data waɗanda suka raba abubuwan da suka ɗauka akan HN wata daya da ya wuce. A cikin sha'awarsu ta haɓaka sigar buɗaɗɗen sigar mallakar mallakar Crunchy Data, Supabase ta haɗe tare da Snaplet don gina Postgres-wasm.
Godiya ga Postgres-wasm, PostgreSQL na iya gudana kai tsaye ta hanyar burauza Don binciken gidan yanar gizo, an yi amfani da rarrabawar Linux na Buildroot, wanda ke da girman ragi sosai, da kuma nau'in v86 wanda ke ba da damar yin kwafin aikin tashar x86.
A bangaren WebAssembly, wannan an yi niyya ne don ba da damar gina manyan aikace-aikace akan shafukan yanar gizo, "amma ba ya yin zato na musamman na yanar gizo ko samar da ayyuka na musamman na yanar gizo, don haka ana iya amfani da shi a wasu wurare kuma. Yana da buɗaɗɗen ma'auni wanda ke nufin tallafawa kowane harshe akan kowane tsarin aiki, kuma a aikace duk shahararrun yarukan sun riga sun sami aƙalla matakin tallafi. Supabase yana amfani da v86 don gudanar da VM a cikin mai bincike.
Gudun Postgres a cikin mai bincike yana da kyau, amma haɗawa da shi tare da PgAdmin ya fi kyau. Abin takaici, masu binciken sun toshe hanyar shiga cibiyar sadarwar TCP ta VM. Don kauce wa wannan, Supabase yana zirga-zirga ta hanyar yanar gizo. Suna amfani da cokali mai yatsa na Websockproxy wanda ke bawa mai kwaikwayon damar sadarwa tare da Intanet ta hanyar canza bayanan da aka aika akan tashar yanar gizo zuwa fakitin TCP. Cokali mai yatsa na Websockproxy yana ƙara ikon rami uwar garken Postgres.
Siffofin Ciki wadanda suka yi fice daga aikin, an ambaci wadannan:
- Postgres 14.5, psql, pg_dump, da sauransu
- Ajiye kuma dawo da yanayi zuwa/daga fayil.
- Ajiye kuma mayar da Postgres zuwa/daga ma'ajiyar burauza (IndexedDB).
- Saurin taya daga fayil ɗin matsayi ko cikakken sake saitin kwaikwayi.
- Zaɓuɓɓukan daidaita ƙwaƙwalwar ajiya daga 128 MB zuwa 1024 MB.
- Saita girman font don tashar tashar.
- Loda fayiloli zuwa kwailin (ciki har da CSV da jujjuya bayanai).
- Zazzage fayilolin emulator.
- Haɗin cibiyar sadarwa mai fita daga mai kwaikwayon zuwa Intanet.
- Ramin hanyar sadarwa mai shigowa zuwa tashar tashar postgres 5432 a cikin kwaikwaiyo.
Gabaɗaya, duk aikin yana ƙunshe a cikin hoto guda ɗaya mai girman 12 MB wanda za'a gudanar da sabar PostgreSQL da shi.
Kamar yadda masu haɓakawa na Postgres-wasm suka yarda, aikin runtime ɗin ba ya da girma sosai, amma a cikin kansa an cimma burin yin amfani da PostgreSQL 14.5 daga cikakken mai bincike tare da layin umarni na psql.
Finalmente idan kuna sha'awar ƙarin sani game da shi, zaku iya bincika cikakkun bayanai a cikin bin hanyar haɗi.