👀 Views: 23 💬 Answers: 1 📅 Created: 2025-06-26

fastapi asyncio postgresql python

I'm attempting to set up I'm relatively new to this, so bear with me. I tried several approaches but none seem to work... I'm building an asynchronous API using FastAPI with PostgreSQL and I'm working with an scenario when trying to retrieve data from the database. The API is set up correctly, and I'm using `asyncpg` to handle asynchronous connections. However, when I attempt to execute a query, I get the following behavior message: ``` TypeError: 'coroutine' object is not subscriptable ``` Here’s a simplified version of my code: ```python from fastapi import FastAPI from asyncpg import create_pool from typing import List app = FastAPI() DATABASE_URL = "postgresql://user:password@localhost/dbname" async def get_db_pool(): return await create_pool(DATABASE_URL) @app.get("/items/", response_model=List[str]) async def read_items(): pool = await get_db_pool() async with pool.acquire() as connection: items = await connection.fetch("SELECT name FROM items") return [item['name'] for item in items] # This line causes the behavior ``` The behavior occurs on the line where I try to return the names from the fetched items. I suspect it's related to how I'm handling the result of the `fetch` method. I've tried using `await connection.fetchrow()` instead, but that doesn't fit my use case since I need all items, not just one. I've also checked the version of `asyncpg` and it's up-to-date. Could anyone guide to understand why I'm seeing this behavior and how to properly extract the item names from the result? Any guidance on best practices for using FastAPI with asynchronous database calls would also be appreciated. My development environment is macOS. This is part of a larger service I'm building. Any help would be greatly appreciated!