| ▲ | tln 6 hours ago | |
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). | ||
| ▲ | TheTaytay 6 hours ago | parent [-] | |
Thank you for the details. This makes a lot of sense! | ||