I would also love to use it this way in Go. Currently we dump SQLite compatible schema to use for SQLite powered integration tests even though we use postgres when live. It allows us to have zero dependency sub-second integration tests using a real database. Being able to use postgres would be even better, allowing us to test functionality requiring PG specific functionality like full text search.
FlyingSnake|1 year ago
We have different options like embedded-postgres or integreSQL, but none match the simplicity of PGLite. I hope this wish comes true soon.
https://github.com/fergusstrange/embedded-postgres/tree/mast...
https://github.com/allaboutapps/integresql
koeng|1 year ago
koeng|1 year ago