{"library":"py-pglite","title":"py-pglite","description":"Python testing library for PGlite - an in-memory PostgreSQL for tests. Provides a lightweight, in-process PostgreSQL via WebAssembly (pglite-manager). Current version 0.5.3, requires Python >=3.10. Active development with monthly releases.","language":"python","status":"active","last_verified":"Fri May 01","install":{"commands":["pip install py-pglite"],"cli":null},"imports":["from pglite import PGlite","import pglite"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import pglite\n\n# Start an in-memory PostgreSQL instance\ndb = pglite.PGlite()\n\n# Get a psycopg2 connection string\nconn_str = db.get_connection_string()\nprint(conn_str)\n\n# Connect using psycopg2\nimport psycopg2\nconn = psycopg2.connect(conn_str)\ncur = conn.cursor()\ncur.execute(\"SELECT version();\")\nprint(cur.fetchone()[0])\ncur.close()\nconn.close()","lang":"python","description":"Basic usage: spin up ephemeral PostgreSQL and run a query.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}