News for hackers. Stuff that matters.
Re:PGlite – Embeddable Postgres by tln on Thursday December 04, 2025 @10:16AM (#46148570)
I'm using it for a service that has DB dependencies. Instead of using SQLite in tests and PG in production, or spinning up a Postgres container, you use Postgres via pglite.

In my case, the focus is on DX ie faster tests. I load shared database from `pglite-schema.tgz` (~1040ms) instead of running migrations from a fresh DB and then use transaction rollback isolation (~10ms per test).

This is a lot faster and more convenient than spinning up a container. Test runs are 5x faster.

I'm hoping to get this working on a python service soon as well (with py-pglite).

Re:PGlite – Embeddable Postgres by TheTaytay on Thursday December 04, 2025 @10:52AM (#46148952)
Thank you for the details. This makes a lot of sense!