Backend API for the Transcript Parser application.

• Node.js 20+
• PostgreSQL 15+ (or use Docker)
• FFmpeg installed on your system
• Gemini API key

1. Install dependencies:

cd server
npm install

2. Create .env file from .env.example:

copy .env.example .env

3. Update .env with your credentials:

• DATABASE_URL: Your PostgreSQL connection string
• JWT_SECRET: A secure random string for JWT tokens
• GEMINI_API_KEY: Your Google Gemini API key

1. Create database:

# Using psql
createdb transcript_parser

# Or using Docker
docker run --name postgres -e POSTGRES_PASSWORD=postgres -e POSTGRES_DB=transcript_parser -p 5432:5432 -d postgres:15-alpine

2. Generate and run migrations:

npm run db:generate
npm run db:push

npm run dev

npm run build
npm start

• POST /api/auth/register - Register new user
• POST /api/auth/login - Login user
• GET /api/auth/me - Get current user (requires auth)

• POST /api/transcripts/upload - Upload video for transcription (requires auth)
• GET /api/transcripts - List all transcripts (requires auth)
• GET /api/transcripts/:id - Get transcript details (requires auth)
• DELETE /api/transcripts/:id - Delete transcript (requires auth)
• PATCH /api/transcripts/:id/entry/:entryId - Update transcript entry (requires auth)

Run with Docker Compose:

cd ..
docker-compose up

This will start:

• PostgreSQL database
• Backend API server
• Frontend application

The server requires FFmpeg for audio extraction from video files.

Download from https://ffmpeg.org/download.html

brew install ffmpeg

sudo apt-get install ffmpeg

server/
├── src/
│   ├── config/         # Configuration files
│   ├── controllers/    # Request handlers
│   ├── middleware/     # Express middleware
│   ├── models/         # Database schemas
│   ├── routes/         # API routes
│   ├── services/       # Business logic
│   └── index.ts        # Server entry point
├── uploads/            # Uploaded files
│   ├── videos/         # Video files
│   └── audio/          # Extracted audio
└── drizzle/            # Database migrations

• Ensure PostgreSQL is running
• Check DATABASE_URL format: postgresql://user:password@host:port/database

• Ensure FFmpeg is installed and in PATH
• Test with: ffmpeg -version

• Check UPLOAD_DIR exists and has write permissions
• Verify MAX_FILE_SIZE allows your file

MIT