Justin Edmund
974781b685
Complete Svelte 5 runes migration and fix remaining ESLint errors: **Svelte 5 Migration (40 errors):** - Add $state() and $state.raw() for reactive variables and DOM refs - Replace deprecated on:event directives with onevent syntax - Fix closure capture issues in derived values - Replace svelte:self with direct component imports - Fix state initialization and reactivity issues **TypeScript/ESLint (8 errors):** - Replace explicit any types with proper types (Prisma.MediaWhereInput, unknown) - Remove unused imports and rename unused variables with underscore prefix - Convert require() to ES6 import syntax **Other Fixes (13 errors):** - Disable custom element props warnings for form components - Fix self-closing textarea tags - Add aria-labels to icon-only buttons - Add keyboard handlers for interactive elements - Refactor map popup to use Svelte component instead of HTML strings Files modified: 28 components, 2 scripts, 1 utility New file: MapPopup.svelte for geolocation popup content |
||
|---|---|---|
| .. | ||
| analyze-image-colors.ts | ||
| backup-db.sh | ||
| check-photo-colors.ts | ||
| cloudinary-cleanup.ts | ||
| debug-photos.md | ||
| find-image-colors.ts | ||
| init-db.sh | ||
| init-db.ts | ||
| list-backups.sh | ||
| migrate-alttext-to-description.sql | ||
| migrate-photos-to-media.ts | ||
| railway-build.sh | ||
| README.md | ||
| reanalyze-colors.ts | ||
| restore-db.sh | ||
| setup-local.sh | ||
| test-media-sharing.ts | ||
Database Backup Scripts
This directory contains scripts for backing up and restoring the PostgreSQL database.
Prerequisites
- PostgreSQL client tools (
pg_dump,psql) must be installed - Environment variables must be set in
.envor.env.local:DATABASE_URL- Local database connection stringREMOTE_DATABASE_URLorDATABASE_URL_PRODUCTION- Remote database connection string
Available Commands
Backup Commands
# Backup local database
npm run db:backup:local
# Backup remote database
npm run db:backup:remote
# Sync remote database to local (backs up both, then restores remote to local)
npm run db:backup:sync
# List all backups
npm run db:backups
Restore Commands
# Restore a specific backup (interactive - will show available backups)
npm run db:restore
# Restore to local database (default)
npm run db:restore ./backups/backup_file.sql.gz
# Restore to remote database (requires extra confirmation)
npm run db:restore ./backups/backup_file.sql.gz remote
Direct Script Usage
You can also run the scripts directly:
# Backup operations
./scripts/backup-db.sh local
./scripts/backup-db.sh remote
./scripts/backup-db.sh sync
# Restore operations
./scripts/restore-db.sh <backup-file> [local|remote]
# List backups
./scripts/list-backups.sh [all|local|remote|recent]
Backup Storage
All backups are stored in the ./backups/ directory with timestamps:
- Local backups:
local_YYYYMMDD_HHMMSS.sql.gz - Remote backups:
remote_YYYYMMDD_HHMMSS.sql.gz
Safety Features
- Automatic Backups: The sync operation creates backups of both databases before syncing
- Confirmation Prompts: Destructive operations require confirmation
- Extra Protection for Remote: Restoring to remote requires typing "RESTORE REMOTE"
- Compressed Storage: Backups are automatically compressed with gzip
- Timestamp Naming: All backups include timestamps to prevent overwrites
Common Use Cases
Daily Local Development
# Start your day by syncing the remote database to local
npm run db:backup:sync
Before Deploying Changes
# Backup remote database before deploying schema changes
npm run db:backup:remote
Restore from Accident
# List recent backups
npm run db:backups
# Restore a specific backup
npm run db:restore ./backups/local_20240615_143022.sql.gz
Environment Variables
You can set these in .env.local (git-ignored) for local overrides:
# Required for local operations
DATABASE_URL="postgresql://user:password@localhost:5432/dbname"
# Required for remote operations (one of these)
REMOTE_DATABASE_URL="postgresql://user:password@remote-host:5432/dbname"
DATABASE_URL_PRODUCTION="postgresql://user:password@remote-host:5432/dbname"
Troubleshooting
"pg_dump: command not found"
Install PostgreSQL client tools:
# macOS
brew install postgresql
# Ubuntu/Debian
sudo apt-get install postgresql-client
# Arch Linux
sudo pacman -S postgresql
"FATAL: password authentication failed"
Check that your database URLs are correct and include the password.
Backup seems stuck
Large databases may take time. The scripts show progress. For very large databases, consider using pg_dump directly with custom options.