Project DB Migration to SQLite

This project was converted from MySQL (aiomysql) to SQLite using

and SQLAlchemy async engine.

• Default database file:
  ./database.sqlite3
  (relative to project root).
• To override, set
  DATABASE_URL
  in
  .env
  (example:
  sqlite+aiosqlite:///./database.sqlite3
  ).

Quick steps to initialize the DB:

1. Install dependencies (using Poetry):

2. Create tables (runs
   app.database.models.async_main
   ):

3. Reset DB: remove
   database.sqlite3
   file and run step 2 again.

Notes:

• If you previously had MySQL credentials in
  .env
  , they were replaced with the SQLite URL. If you want to keep MySQL in some environments, set
  DATABASE_URL
  accordingly in that environment.
• The project uses SQLAlchemy ORM; most existing queries continue to work without changes.