# sqlalchemy.exc.ArgumentError: The asyncio extension requires an async driver to be used. The 'sqlite' driver is not async.

- **ID:** `python/sqlalchemy-missing-async-driver`
- **Domain:** python
- **Category:** config_error
- **Verification:** ai_generated
- **Fix Rate:** 80%

## Root Cause

Using SQLAlchemy's async extension with a synchronous database driver, such as sqlite3 or psycopg2.

## Version Compatibility

| Version | Status | Introduced | Deprecated |
|---------|--------|------------|------------|
| 1.4.x | active | — | — |
| 2.0.x | active | — | — |

## Workarounds

1. **** (95% success)
   ```
   Use create_async_engine with an async driver: from sqlalchemy.ext.asyncio import create_async_engine; engine = create_async_engine('postgresql+asyncpg://user:pass@localhost/db')
   ```
2. **** (90% success)
   ```
   For SQLite, use aiosqlite: engine = create_async_engine('sqlite+aiosqlite:///foo.db')
   ```

## Dead Ends

- **** — create_engine doesn't accept an async parameter; you must use create_async_engine. (90% fail)
- **** — The driver must be installed separately; otherwise ImportError occurs. (80% fail)