dineshchandran-chan pushed to refs/heads/main at dineshchandran-chan/BioLab

Commits on Apr 30, 2026

1. feat(backend): migrate TEM service from SQLite to PostgreSQL

   
   

   - Replace SQLite DATABASE_URL with PostgreSQL connection string built
     from PGHOST/PGPORT/PGDATABASE/PGUSER/PGPASSWORD env vars
   - Load .env from data root via python-dotenv at startup
   - Switch connect_args to pool_pre_ping=True for connection health checks
   - Use IF NOT EXISTS in ALTER TABLE statements (PostgreSQL supports it)
   - Add psycopg2-binary and python-dotenv to requirements.txt
   
   Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

   
   
   
   
   

   and
   claude

   committed

   Apr 30, 2026

   
   
   Configuration menu

   
   

   Browse the repository at this point in the history

2. 
   
   Configuration menu

   
   

   Browse the repository at this point in the history