Asyncpg Expecte list, got dict error

[mastrobardo]

Hello all, i'm stuck with the error in the title when connecting to Nile via asyncPg . I can't wrap my head around it. Anybody ot same errors?

A little script to replicate

` import asyncpg
import asyncio
import os
from dotenv import load_dotenv

load_dotenv()

async def fetch_tenants():
db_url = os.getenv("DB_URL")

if not db_url:
    raise ValueError("Database URL not provided")

conn = None
try:
    conn = await asyncpg.connect(db_url,
                                 statement_cache_size=0,
                                 command_timeout=60)
    print("Database connection established.")

    query = "SELECT * FROM tenants"
    result = await conn.fetch(query)
    
    print(f"Result type: {type(result)}")
    print(f"Result length: {len(result)}")

    if not result:
        print("No records found.")
    else:
        for row in result:
            print(dict(row))

except Exception as e:
    print(f"Error executing query: {e}")

finally:
    if conn:
        await conn.close()
        print("Database connection closed.")

if name == "main":
asyncio.run(fetch_tenants())

`

[mastrobardo]

this is really a Nile error. Replicating on local, same exact query, will NOT crash the app. I was happy about having a managed postgres, butthe time i already spent on this abslutely is not worth.

[gwenshap]

Thanks for reporting the issue, and extra thanks for the short and clear script that reproduces the problem. We are working on a fix and will keep you posted.

Meanwhile, if you are open to giving psycopg3 a go - it is also async and well tested with Nile.

[mastrobardo]

Psycopg3 works well, thanks. I'd add this bit of info in the tutorials!