.env.example

# 🔒 SECURITY NOTICE: Never commit .env to version control!
# Copy this file to .env and add your actual Supabase credentials
#
# The app works in three modes:
# - WITH Supabase credentials: Full cloud sync and authentication
# - WITHOUT credentials: Local storage only (no account needed)
# - WITH VITE_DATA_BACKEND=sql: Self-hosted SQL backend (see below)

# Your Supabase Project Settings
VITE_SUPABASE_URL=https://your-project-id.supabase.co
VITE_SUPABASE_ANON_KEY=your_anon_key_here

# AI features (report summaries) call the Gemini API server-side via the
# ai-proxy Supabase Edge Function, never directly from the client — there is
# no client-side AI API key to set here. Configure the proxy's key as a
# Supabase Function secret instead:
#   supabase secrets set GEMINI_API_KEY=your_gemini_api_key_here

# 📋 Setup Instructions:
# 1. Copy this file: cp .env.example .env
# 2. Go to your Supabase project dashboard
# 3. Navigate to Settings > API
# 4. Copy the Project URL and anon/public key
# 5. Replace the values above with your actual credentials
# 6. Save the file
# 7. Restart your development server

# 🔐 Where to find your credentials:
# Supabase Dashboard > Project Settings > API > Project URL & anon key

# 🐛 Development Options:
# Enable verbose database and auth call logging (development only)
# Set to 'true' to see detailed console logs for every database operation
# VITE_ENABLE_DB_LOGS=true

# 🗄️ Self-Hosted SQL Backend (optional, opt-in)
# Lets you run Timetraked against your own Postgres or MySQL database instead
# of Supabase or localStorage. Requires running the backend in server/
# (`pnpm run db:migrate`, `pnpm run db:seed`, `pnpm run server:start`).
# Leave VITE_DATA_BACKEND unset to keep using Supabase/localStorage as before.

# Frontend (safe to expose — read by the browser bundle):
# VITE_DATA_BACKEND=sql
# VITE_SQL_API_URL=http://localhost:4001/api

# Backend only (used by server/, never VITE_-prefixed, never sent to the browser):
# DB_CLIENT=pg          # "pg" (PostgreSQL) or "mysql2" (MySQL)
# DB_HOST=localhost
# DB_PORT=5432          # 3306 for MySQL
# DB_USER=timetraked
# DB_PASSWORD=your_db_password_here
# DB_NAME=timetraked
# DB_SSL=false          # set to true if your database requires SSL
# SQL_SERVER_PORT=4001  # port the server/ API listens on