Could you please provide way you set dbpool?

ok I'm setting my asyngpg pool as you noticed in the dbpool key of the app state (pool, not connection)

it's happening in the lifespan of the app, here's some overview of my lifespan, the app and the get_connection deendency:

@asynccontextmanager
async def lifespan(
    app_settings: AppSettings,
    _app: Litestar,
) -> AsyncGenerator[None, None]:
    dbpool = await create_pool_b(
        app_settings.db_url,
)
    _app.state.dbpool = dbpool
    try:
        yield
    finally:
        dbpool.terminate()
        await dbpool.close()

async def get_connection(state: State) -> AsyncGenerator[BuildPgConnection, None]:
    pool: BuildPgPool = state.dbpool
    async with pool.acquire() as conn:
        try:
            yield conn
        except Exception as e:
            logger.exception(e)
            raise e

app = Litestar(
        lifespan=[partial(lifespan, app_settings)],
        dependencies={
            "conn": Provide(get_connection),
            "app_settings": Provide(lambda: app_settings, sync_to_thread=False),
 
        },
    )

    return app

I think the asyncpg_plugin does the same for you, just the key might be different so you'll have to adapt,

well I checked asyncpg_plugin and connection_dependency_key defaults to db_connection so you should get it via connection.app.state.get("db_connection") it's surprising it returns None unless you changed that

Finally got it! Would it be good to express this case in docs? When you are using app in production, you'd like to have some pre-request checks, so I think it should be mentioned (that you can share deps using app.state not something else)?

Finally got it! Would it be good to express this case in docs? When you are using app in production, you'd like to have some pre-request checks, so I think it should be mentioned (that you can share deps using app.state not something else)?

that would be a good addition yes, fancy doing a PR for this ?

Sure, I'd like to open it; won't you mind if I'll mention you in reviewers?

appreciated !