till/managarten
1
0
Fork 0
mirror of https://github.com/Memo-2023/mana-monorepo.git synced 2026-05-14 23:01:09 +02:00
Code Issues Projects Releases Packages Wiki Activity Actions 4
managarten/apps/uload/docs/DATABASE_SWITCHING.md
Wuesteon d36b321d9d style: auto-format codebase with Prettier 
Applied formatting to 1487+ files using pnpm format:write
  - TypeScript/JavaScript files
  - Svelte components
  - Astro pages
  - JSON configs
  - Markdown docs

  13 files still need manual review (Astro JSX comments)
2025-11-27 18:33:16 +01:00

2.7 KiB
Raw Permalink Blame History

Database Switching Guide

Overview

The application now supports automatic switching between development and production databases to prevent accidental changes to production data during local development.

Configuration

Development Mode

  • Database URL: http://localhost:8090
  • Config File: .env (for local development)
  • MCP Config: .mcp.development.json

Production Mode

  • Database URL: https://pb.ulo.ad
  • Config File: .env.production
  • MCP Config: .mcp.json

How to Use

Local Development

  1. Start the local PocketBase server:
npm run backend
# or
cd backend && ./pocketbase serve
  1. Start the development server:
npm run dev
  1. Or start both together:
npm run dev:all

The application will automatically connect to http://localhost:8090.

Production Build

For production builds, the application will use the production database:

npm run build
npm run preview

Switching Between Environments

To use local database:

  1. Ensure .env contains: PUBLIC_POCKETBASE_URL=http://localhost:8090
  2. Start local PocketBase: npm run backend
  3. Run development server: npm run dev

To use production database (NOT RECOMMENDED for development):

  1. Change .env to: PUBLIC_POCKETBASE_URL=https://pb.ulo.ad
  2. Restart development server: npm run dev

⚠️ WARNING: Only connect to production database when absolutely necessary. Always use local database for development and testing.

Verification

To verify which database is being used, check the browser console after starting the dev server. You should see:

PocketBase URL: http://localhost:8090
Environment: development
Is Production: false

Files Changed

  1. src/lib/pocketbase.ts: Removed hardcoded production URL, now uses environment variables
  2. src/hooks.server.ts: Added fallback logic for environment-based URL selection
  3. .env: Changed to use local database URL for development
  4. .mcp.development.json: New file for local MCP server configuration
  5. CLAUDE.md: Updated with database configuration documentation

Troubleshooting

Local PocketBase not starting

  • Check if port 8090 is already in use
  • Ensure PocketBase binary is executable: chmod +x backend/pocketbase
  • Check logs: cat pocketbase-dev.log

Still connecting to production

  • Clear browser cache and restart dev server
  • Verify .env file contains correct URL
  • Check console output for which URL is being used

MCP Server issues

  • For local development, use .mcp.development.json
  • For production, use .mcp.json
  • Restart Claude Code after changing MCP configuration