- Replace SQLite with PostgreSQL using Neon as provider
- Add environment-based database URL configuration
- Create separate test database setup with DATABASE_URL_TEST
- Reset migration history and generate fresh PostgreSQL schema
- Add comprehensive migration documentation
- Include database unit tests for connection validation
chore: add @vitest/coverage-v8 dependency to package.json
chore: update pnpm-lock.yaml with new dependencies and versions
test: enhance env.test.ts to validate environment variable handling and defaults
- Replace Jest imports and mocks with Vitest equivalents in setup and unit tests.
- Adjust test cases to use async imports and reset modules with Vitest.
- Add Vitest configuration file for test environment setup and coverage reporting.
feat: enhance server initialization with environment validation and import processing scheduler
test: add Jest setup for unit tests and mock console methods
test: implement unit tests for environment management and validation
test: create unit tests for transcript fetcher functionality
