However that's not true. pglite runs as a single process inside the browser leveraging postgres single user mode.

pgembed gives you the illusion of being an embedded database, but really its running a managed multi-process postgres behind the scenes.

vpg is trying to mimic what pglite does. It's mostly written in C with the top level glue code written in vlang and exposed via python using a custom bindgen implementation.