Comment by solarkraft
6 days ago
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 :(
Try pgserver https://github.com/orm011/pgserver It uses real Postgres rather than WASM
Pgserver is not maintained. Had to fork it as pgembed, compile recent versions and bundle BM25 and vector extensions.
Thank you for the fork! Back in November I made a PR to pgserver for postgres 18, but your version with vector extensions is even better!