Provide a way to set specific versions of pglite lib

[eremeevfd]

Hello and thank you very much for a great lib!

I have an idea/proposition to maybe allow settings pglite versions in package.json, because it doesn't look very convenient to have hardcoded versions in the lib code.

This code can be found here: https://github.com/wey-gu/py-pglite/blob/main/src/py_pglite/manager.py#L69

        if not package_json.exists():
            package_content = {
                "name": "py-pglite-env",
                "version": __version__,
                "description": "PGlite test environment for py-pglite",
                "scripts": {"start": "node pglite_manager.js"},
                "dependencies": {
                    "@electric-sql/pglite": "^0.3.11",
                    "@electric-sql/pglite-socket": "^0.0.16",
                },
            }

[nileshtrivedi]

pglite-socket directly provides a CLI tool to run pglite over TCP socket. Shouldn't py-pglite be using that directly now? 🤔

# for a UNIX socket
pglite-server --path=/tmp/pglite.sock
# for a TCP socket
pglite-server

Then psql can connect to this with psql "sslmode=disable host=localhost password=dummy"

Here are all the options it supports:

pglite-server --help
PGlite Socket Server
Usage: pglite-server [options]

Options:
  -d, --db=PATH       Database path (default: memory://)
  -p, --port=PORT     Port to listen on (default: 5432)
  -h, --host=HOST     Host to bind to (default: 127.0.0.1)
  -u, --path=UNIX     Unix socket to bind to (default: undefined). Takes precedence over host:port
  -v, --debug=LEVEL   Debug level 0-5 (default: 0)
  -r, --run=COMMAND   Command to run after server starts
  --include-database-url  Include DATABASE_URL in subprocess environment
  --shutdown-timeout=MS   Timeout for graceful subprocess shutdown in ms (default: 5000)

[eremeevfd]

@nileshtrivedi probably! but is it related to the original issue? my point was to be able to choose pglite version instead of using the hardcoded one