pglite: investigate using it for unit testing, instead of (or in addition to) our current full postgresql "ephemeral" database

[williamstein]

See https://github.com/electric-sql/pglite

This could also be useful for unit testing, instead of running a full Postgresql server. Maybe. There are of course major advantages to just running real postgresql for unit testing, since it better reflects production.

Pglite could possibly be of interest as well for an even simpler and more lightweight version of cocalc. E.g., imagine cocalc-docker but without having to run a separate postgresql at all. This would be significantly easier to run outside of docker as an electron app (say).

[williamstein]

NOTE: this is a relatively non-actionable vague idea.

[williamstein]

Definitely do NOT use this (solely) for unit testing, because e.g., we need to be able to target a specific version of postgresql with github actions!