PGlite is an embeddable PostgreSQL database that runs locally in WebAssembly, weighing under 3MB when compressed. It features dynamic extension loading including pgvector support, built-in data synchronization, and live query capabilities, allowing full Postgres functionality directly in web browsers.