Backend

Hono-based API server with LastLogin authentication and SQLite database.

• index.ts - Main HTTP handler with LastLogin wrapper
• database/ - Database migrations and query functions
• routes/ - API route handlers

• All API routes require authentication via LastLogin
• User email is extracted from X-LastLogin-Email header

• GET /api/conversations - Get user's conversations
• GET /api/conversations/:id - Get specific conversation with messages
• POST /api/conversations - Create new conversation
• DELETE /api/conversations/:id - Delete conversation

• POST /api/chat - Send message and get ChatGPT response

• chat_users_v1 - User accounts
• chat_conversations_v1 - Conversation metadata
• chat_messages_v1 - Individual messages

• Automatic user creation on first login
• Conversation history storage
• ChatGPT integration via OpenAI API
• Secure user isolation (users can only access their own data)