py-pglite

I like the idea of PGLite! Unfortunately, when I tried to use it with https://github.com/wey-gu/py-pglite to speed up tests, I got stuck on it not being able to handle cell contents above a few thousand characters, which was a deal breaker for my project :(

For unit testing, I still use TestContainers which spins a full Postgres in Docker. But new alternatives like this make py-pglite (https://github.com/wey-gu/py-pglite) possible which is Python unit testing with PGlite. Even so, for Python unit testing I'm more confident in something like pgserver (https://github.com/orm011/pgserver) which offers the full, real Postgres in a lightweight pip package. Note: my take is specifically for unit testing, not other use cases!

This seems great but: > The library automatically manages PGlite npm dependencies. I'm sorry what? Please don't do this. There is no way you can do this in a way that: (a) is compatible with every pre-existing in-repo NodeJS setup (b) plays nicely with all SCA automation configurations (Dependabot, etc.) --- Edit: After closer inspection there's a config[0] to disable this which defaults to True, but no documentation on how to manage required Node deps when setting that value to false. I would strongly suggest the authors default this to False with accompanying docs in the README Overall though I do like the simplicity & readability of the codebase - it makes these gotchas really easy to find & verify even without docs - will definitely be using this. [1] https://github.com/wey-gu/py-pglite/blob/b821cf2cfeb2e4bc58b...

Roadmap of v1 https://github.com/wey-gu/py-pglite/issues/4