Remix.run Logo
TheDataMaverick 8 hours ago

Amazing work! It makes setting up CI so much easier.

lame_lexem 7 hours ago | parent [-]

huh. could you tell how you use it in ci?

tln 6 hours ago | parent [-]

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!