mirror of
https://github.com/Dvorinka/Trackeep.git
synced 2026-06-03 20:12:58 +00:00
Tomas Dvorak
18aa702174
🚀 Features Implemented: ✅ Full-stack application with SolidJS frontend + Go backend ✅ User authentication with JWT tokens ✅ Bookmark management with tags and search ✅ Task management with status and priority tracking ✅ File upload and management system ✅ Notes with rich text editing and organization ✅ Advanced search and filtering across all content types ✅ Export/import functionality for data portability 🏗️ Architecture: - Frontend: SolidJS + TypeScript + UnoCSS + TanStack Query - Backend: Go + Gin + GORM + PostgreSQL/SQLite - Deployment: Docker + Docker Compose + CI/CD pipeline - Monitoring: Structured logging + metrics collection + health checks 📦 Production Ready: ✅ Multi-stage Docker builds for frontend and backend ✅ Production docker-compose with Redis and backup services ✅ GitHub Actions CI/CD pipeline with security scanning ✅ Comprehensive logging and monitoring system ✅ Automated backup and recovery strategies ✅ Complete API documentation and user guide 📚 Documentation: - Complete API documentation with examples - Comprehensive user guide with troubleshooting - Deployment and configuration instructions - Security best practices and performance optimization 🎯 Project Status: 100% COMPLETE (69/69 tasks) Trackeep is now a production-ready, self-hosted productivity platform!
58 lines
1.7 KiB
Bash
Executable File
58 lines
1.7 KiB
Bash
Executable File
#!/bin/bash
|
|
|
|
# Backup script for Trackeep PostgreSQL database
|
|
# This script is designed to run as a cron job
|
|
|
|
set -e
|
|
|
|
# Configuration
|
|
DB_NAME="${POSTGRES_DB:-trackeep}"
|
|
DB_USER="${POSTGRES_USER:-trackeep}"
|
|
DB_HOST="${POSTGRES_HOST:-postgres}"
|
|
BACKUP_DIR="${BACKUP_PATH:-/backups}"
|
|
RETENTION_DAYS="${BACKUP_RETENTION_DAYS:-30}"
|
|
TIMESTAMP=$(date +"%Y%m%d_%H%M%S")
|
|
BACKUP_FILE="$BACKUP_DIR/trackeep_backup_$TIMESTAMP.sql"
|
|
|
|
# Create backup directory if it doesn't exist
|
|
mkdir -p "$BACKUP_DIR"
|
|
|
|
# Log function
|
|
log() {
|
|
echo "[$(date '+%Y-%m-%d %H:%M:%S')] $1" >> "$BACKUP_DIR/backup.log"
|
|
}
|
|
|
|
log "Starting database backup"
|
|
|
|
# Create the backup
|
|
if PGPASSWORD="$POSTGRES_PASSWORD" pg_dump -h "$DB_HOST" -U "$DB_USER" -d "$DB_NAME" > "$BACKUP_FILE"; then
|
|
log "Backup created successfully: $BACKUP_FILE"
|
|
|
|
# Compress the backup
|
|
if gzip "$BACKUP_FILE"; then
|
|
BACKUP_FILE="$BACKUP_FILE.gz"
|
|
log "Backup compressed successfully: $BACKUP_FILE"
|
|
else
|
|
log "Warning: Failed to compress backup file"
|
|
fi
|
|
|
|
# Calculate backup size
|
|
BACKUP_SIZE=$(du -h "$BACKUP_FILE" | cut -f1)
|
|
log "Backup size: $BACKUP_SIZE"
|
|
|
|
else
|
|
log "ERROR: Failed to create database backup"
|
|
exit 1
|
|
fi
|
|
|
|
# Clean up old backups
|
|
log "Cleaning up backups older than $RETENTION_DAYS days"
|
|
find "$BACKUP_DIR" -name "trackeep_backup_*.sql.gz" -type f -mtime +$RETENTION_DAYS -delete
|
|
find "$BACKUP_DIR" -name "trackeep_backup_*.sql" -type f -mtime +$RETENTION_DAYS -delete
|
|
|
|
# Count remaining backups
|
|
BACKUP_COUNT=$(find "$BACKUP_DIR" -name "trackeep_backup_*.sql*" -type f | wc -l)
|
|
log "Cleanup complete. $BACKUP_COUNT backups retained"
|
|
|
|
log "Backup process completed successfully"
|