new 0.8 version for sqlite connection with '?mode=ro' not working, Error can't open database

[Pythonbeginer2014]

from contextlib import asynccontextmanager
from databases import Database


@asynccontextmanager
async def async_sqlite_conn(db_name):
    database = Database(f'sqlite+aiosqlite:///example.db?mode=ro', uri=True)
    try:
        await database.connect()
        yield database
    finally:
        await database.disconnect()

when call this function and query data, get error " can't open database"

Thanks ,

[Sebcio03]

Hi @Pythonbeginer2014,

I tried to reproduce your problem using python 3.12 with databases 0.8 and for me it works perfectly:

Try again but make sure you have write/read access to directory where you want to create file with database, remove file (it might be somehow corrupted)

If still this won't work can you please show us your exception logs, and pip freeze