database

Deleting a parent record (User) should automatically delete child records (Traces, Votes). Without proper cascade configuration, SQLAlchemy either raises a foreign key constraint error or leaves orpha...

Need to run Alembic migrations that work on both PostgreSQL and SQLite. SQLite doesn't support ALTER TABLE for column renames or type changes, causing migration failures in test environments.