aris/apps/aelis-backend/.env.example

# PostgreSQL connection string
DATABASE_URL=postgresql://user:password@localhost:5432/aris

# BetterAuth secret (min 32 chars, generate with: openssl rand -base64 32)
BETTER_AUTH_SECRET=

# Encryption key for source credentials at rest (32 bytes, generate with: openssl rand -base64 32)
CREDENTIALS_ENCRYPTION_KEY=

# Base URL of the backend
BETTER_AUTH_URL=http://localhost:3000

# OpenRouter (LLM feed enhancement)
OPENROUTER_API_KEY=
# Optional: override the default model (default: openai/gpt-4.1-mini)
# OPENROUTER_MODEL=openai/gpt-4.1-mini

# Apple WeatherKit credentials
WEATHERKIT_PRIVATE_KEY=
WEATHERKIT_KEY_ID=
WEATHERKIT_TEAM_ID=
WEATHERKIT_SERVICE_ID=
feat(backend): add BetterAuth email/password authentication - Add PostgreSQL connection (src/db.ts) - Configure BetterAuth with email/password (src/auth/index.ts) - Add session middleware for route protection (src/auth/session-middleware.ts) - Add registerAuthHandlers for mounting auth routes (src/auth/http.ts) - Rename index.ts to server.ts - Add .env.example with required environment variables Co-authored-by: Ona <no-reply@ona.com> 2026-01-25 16:21:00 +00:00			`# PostgreSQL connection string`
			`DATABASE_URL=postgresql://user:password@localhost:5432/aris`

			`# BetterAuth secret (min 32 chars, generate with: openssl rand -base64 32)`
			`BETTER_AUTH_SECRET=`

feat(backend): add DB persistence layer (#79) * feat(backend): add DB persistence layer Replace raw pg Pool with Drizzle ORM backed by Bun.sql. Add per-user source configuration table (user_sources). Migrate Better Auth to drizzle-adapter. Add AES-256-GCM credential encryption. Co-authored-by: Ona <no-reply@ona.com> * fix(backend): set updatedAt explicitly in all mutations onConflictDoUpdate bypasses Drizzle's $onUpdate hook. Set updatedAt explicitly in all mutation methods. Co-authored-by: Ona <no-reply@ona.com> * fix(backend): add composite index on user_sources Add (user_id, enabled) index for the enabled() query path. Co-authored-by: Ona <no-reply@ona.com> --------- Co-authored-by: Ona <no-reply@ona.com> 2026-03-16 01:30:02 +00:00			`# Encryption key for source credentials at rest (32 bytes, generate with: openssl rand -base64 32)`
			`CREDENTIALS_ENCRYPTION_KEY=`

feat(backend): add BetterAuth email/password authentication - Add PostgreSQL connection (src/db.ts) - Configure BetterAuth with email/password (src/auth/index.ts) - Add session middleware for route protection (src/auth/session-middleware.ts) - Add registerAuthHandlers for mounting auth routes (src/auth/http.ts) - Rename index.ts to server.ts - Add .env.example with required environment variables Co-authored-by: Ona <no-reply@ona.com> 2026-01-25 16:21:00 +00:00			`# Base URL of the backend`
			`BETTER_AUTH_URL=http://localhost:3000`
feat(backend): add WeatherService Manage per-user WeatherSource instances via FeedSourceProvider, following the same pattern as LocationService. Wire into FeedEngineService so weather data is included in the feed. Co-authored-by: Ona <no-reply@ona.com> 2026-02-13 19:16:33 +00:00
feat(backend): add LLM-powered feed enhancement (#58) * feat(backend): add LLM-powered feed enhancement Add enhancement harness that fills feed item slots and generates synthetic items via OpenRouter. - LLM client with 30s timeout, reusable SDK instance - Prompt builder with mini calendar and week overview - arktype schema validation + JSON Schema for structured output - Pure merge function with clock injection - Defensive fallback in feed endpoint on enhancement failure - Skips LLM call when no unfilled slots or no API key Co-authored-by: Ona <no-reply@ona.com> * refactor: move feed enhancement into UserSession Move enhancement logic from HTTP handler into UserSession so the transport layer has no knowledge of enhancement. UserSession.feed() handles refresh, enhancement, and caching in one place. - UserSession subscribes to engine updates and re-enhances eagerly - Enhancement cache tracks source identity to prevent stale results - UserSessionManager accepts config object with optional enhancer - HTTP handler simplified to just call session.feed() Co-authored-by: Ona <no-reply@ona.com> * test: add schema sync tests for arktype/JSON Schema drift Validates reference payloads against both the arktype schema (parseEnhancementResult) and the OpenRouter JSON Schema structure. Catches field additions/removals or type changes in either schema. Co-authored-by: Ona <no-reply@ona.com> * refactor: rename arktype schemas to match types Co-authored-by: Ona <no-reply@ona.com> --------- Co-authored-by: Ona <no-reply@ona.com> 2026-03-05 02:01:30 +00:00			`# OpenRouter (LLM feed enhancement)`
			`OPENROUTER_API_KEY=`
			`# Optional: override the default model (default: openai/gpt-4.1-mini)`
			`# OPENROUTER_MODEL=openai/gpt-4.1-mini`

feat(backend): add WeatherService Manage per-user WeatherSource instances via FeedSourceProvider, following the same pattern as LocationService. Wire into FeedEngineService so weather data is included in the feed. Co-authored-by: Ona <no-reply@ona.com> 2026-02-13 19:16:33 +00:00			`# Apple WeatherKit credentials`
			`WEATHERKIT_PRIVATE_KEY=`
			`WEATHERKIT_KEY_ID=`
			`WEATHERKIT_TEAM_ID=`
			`WEATHERKIT_SERVICE_ID=`