<divalign="center">

<h1align="center">Postgres WASM</h1>

<palign="center">APostgresQL server instance running in a virtual machine running in the browser<br />

<palign="center">APostgreSQL server instance running in a virtual machine running in the browser<br />

<i>by Supabase&amp; Snaplet</i></p>

<imgalign="center"src="https://user-images.githubusercontent.com/90199159/192729860-730e89a9-2489-4a95-a814-25eaaebebb7d.png"alt="Snaplet, Supabase and friends"width="480">

<br /><br />

This repo is split into three packages that build up the environment for runningPostgresQL in the browser.

This repo is split into three packages that build up the environment for runningPostgreSQL in the browser.

-[runtime](/packages/runtime): The v86 emulator that starts the`buildroot` image

-[Buildroot](/packages/buildroot): Scripts to build the CPU and memory snapshot run by v86.

If you want to install the proxy server on your own server, here's the easiest way to get started:

1. Start with an Ubuntu 20.04 server instance. This is the only configuration that's currently tested. Ubuntu 22.04 will not work, as it uses`OpenSSL 3.0` which is not compatible with the docker image's versons of`OpenSSL` and`nginx`.

2. Make sure Docker is installed. (see install_docker.sh for installing Docker on Ubuntu 20.04 amd64)

3. Make sure the DNS for your domain points to this new server. (Use an`A` record.)

4. Copy the`install.sh` file to the server.

5. Modify the first two lines of`install.sh` to set your`PROXY_DOMAIN` and`PROXY_DOMAIN_SUPPORT_EMAIL`.

6. Execute the`install.sh` script on the server.

A websocket ethernet switch built using Tornado in Python

export PROXY_DOMAIN="my_proxy.domain.com"

export PROXY_DOMAIN_SUPPORT_EMAIL="support@my_proxy.domain.com"

docker rm -f relay&& docker run --privileged --network host --name relay burggraf/pg_browser_websockproxy:1.0.5&

sleep 120# give time for initial start

crontab -l| { cat;echo"@reboot sleep 5 && docker rm -f relay && docker run --privileged --network host --name relay burggraf/pg_browser_websockproxy:1.0.5"; }| crontab -

apt install -y certbot

apt install -y cron

certbot certonly -d$PROXY_DOMAIN --standalone -n --agree-tos --email$PROXY_DOMAIN_SUPPORT_EMAIL

docker cp -L /etc/letsencrypt/live/$PROXY_DOMAIN/fullchain.pem relay:/root/fullchain.pem

docker cp -L /etc/letsencrypt/live/$PROXY_DOMAIN/privkey.pem relay:/root/privkey.pem

dockerexec -it relay nginx# start nginx

crontab -l| { cat;echo"0 1 * * * certbot renew --standalone"; }| crontab -

crontab -l| { cat;echo"0 2 * * * docker cp -L /etc/letsencrypt/live/$PROXY_DOMAIN/fullchain.pem relay:/root/fullchain.pem"; }| crontab -

crontab -l| { cat;echo"0 2 * * * docker cp -L /etc/letsencrypt/live/$PROXY_DOMAIN/privkey.pem relay:/root/privkey.pem"; }| crontab -

sudo apt install apt-transport-https ca-certificates curl software-properties-common

curl -fsSL https://download.docker.com/linux/ubuntu/gpg| sudo apt-key add -

sudo add-apt-repository"deb [arch=amd64] https://download.docker.com/linux/ubuntu focal stable"

apt-cache policy docker-ce

sudo apt install -y docker-ce

sudo systemctl status docker