Postgres-wasm
lastmod 2023-08-07created 2023-08-071 edits
A PostgreSQL server that runs in the browser
Features
- Fully featured. Can also restore from pg_dump and do logical replication from a remote DB
- At about 30mb, it is not suited for general use
- Rather for running demos, testing features, development, creating and sharing snapshots for testing, etc.
Open-source components (3 Repos)
- Virtual Machine(VM) : builds an embeddable VM with Buildroot
- Web Application : runs the VM in the browser with v86
- Network Proxy : proxies traffic over WebSockets for PgAdmin connections. Uses Websockproxy
Features of the demo version hosted by SupaBase
- Postgres 14.5, psql, pg_dump, etc.
- Save/Restore from files
- Save & Restore Postgres state to browser IndexedDB
- Start from a State file, or fully reboot the emulator
- Memory configurable from 128MB to 1024MB
- Font settings for the terminal
- Upload files to the emulator (DB dumps, CSV, etc.)
- Download files from the emulator
- Access the external internet from the emulator
- Route incoming network traffic to Postgres port 5432 inside the emulator