fastapi-dbbackup 0.1.0

Database-native backup tool for FastAPI and SQLAlchemy

fastapi-dbbackup

Database-native backup tool for FastAPI and SQLAlchemy. Similar to django-dbbackup.

Features

• Database Support: SQLite, PostgreSQL, MySQL.
• Storage Support: Local File System, AWS S3.
• Compression: Gzip compression supported.
• Restoration: Easy database restoration from backups.
• Retention: Automatic purging of old backups.
• CLI: Intuitive CLI with backup, restore, and list commands.

Installation

pip install fastapi-dbbackup

Configuration

The tool is configured via environment variables. It automatically loads variables from a .env file in your current directory or any parent directory.

Variable	Description	Default
DATABASE_URL	SQLAlchemy-style database URL (Required)	-
DBBACKUP_DIR	Local directory for backups	backups
DBBACKUP_STORAGE	Storage backend (local or s3)	local
DBBACKUP_COMPRESS	Whether to compress backups	true
DBBACKUP_RETENTION_DAYS	Number of days to keep backups (0 = forever)	0
DBBACKUP_MAX_BACKUPS	Maximum number of backups to keep (0 = unlimited)	0
DBBACKUP_S3_BUCKET	S3 bucket name (Required for S3)	-
DBBACKUP_S3_REGION	S3 region name	-
DBBACKUP_S3_PREFIX	S3 prefix/folder	""

Usage

Backup

fastapi-dbbackup backup

Restore

Restore the latest backup:

fastapi-dbbackup restore

Restore a specific backup:

fastapi-dbbackup restore default-20260131-120000.dump.gz

List Backups

fastapi-dbbackup list

Docker Usage

Yes! fastapi-dbbackup works great with Docker. However, because it uses native database tools for maximum reliability, you must ensure the appropriate CLI clients are installed in your container.

Example Dockerfile

FROM python:3.11-slim

# Install database clients (Postgres/MySQL)
RUN apt-get update && apt-get install -y \
    postgresql-client \
    default-mysql-client \
    sqlite3 \
    && rm -rf /var/lib/apt/lists/*

WORKDIR /app
COPY . .
RUN pip install fastapi-dbbackup

# Your command to run the app or a cron job
CMD ["fastapi-dbbackup", "backup"]

Tips for Docker:

• Storage: Use DBBACKUP_STORAGE=s3 to ensure your backups survive container restarts.
• Volumes: If using local storage, mount a volume to DBBACKUP_DIR (default: backups).
• Database URL: Ensure your DATABASE_URL uses the service name defined in your docker-compose.yml (e.g., postgres://user:pass@db:5432/dbname).

---

License