GitHub - Portabase/portabase: Portabase - Database backup & restore tool for PostgreSQL, MySQL/MariaDB, MongoDB, SQLite, Redis, Valkey (more engines coming soon 🚀)
github.com
Portabase - Database backup & restore tool for PostgreSQL, MySQL/MariaDB, MongoDB, SQLite, Redis, Valkey (more engines coming soon 🚀) - Portabase/portabase

Hi community,

I’m one of the maintainers of Portabase, and this is my first time sharing about it on Lemmy.

Portabase is an open-source platform for database backup and restore.

It’s designed to be simple, reliable, and lightweight, without exposing your databases to public networks. It works via a central server and edge agents (like Portainer), making it perfect for self-hosted or edge environments.

It currently supports 7 databases:

PostgreSQL, MariaDB, MySQL, SQLite, MongoDB, Redis and Valkey

Repository: https://github.com/Portabase/portabase

(we hit 500 stars recently!)

Key features:

  • Logical backups for PostgreSQL, MySQL, MariaDB, MongoDB, SQLite, Redis, Valkey
  • Multiple storage backends: local filesystem, S3, Cloudflare R2, Google Drive
  • Notifications via Discord, Telegram, Slack, webhooks, etc.
  • Cron-based scheduling with flexible retention strategies
  • Agent-based architecture for secure, edge-friendly deployments
  • Ready-to-use Docker Compose setup and Helm Chart

What’s coming next:

  • Increasing test coverage
  • Extending database support

I’d love to hear from you: which database would you like to see supported next in Portabase?

  • lemmy_get_my_coat@lemmy.worldEnglish
    2·
    2 months ago

    Is it possible for you to release a version on the unraid Community Apps catalog? https://unraid.net/community/apps

    I think it’s just a wiring into the dockerhub repo. Unraid can set up the container directly from dockerhub, but it has to guess at ports and variables, so it came out a bit janky when I tried doing that. Having it on CA proper would remove a barrier for entry getting it running on unraid.

      • lemmy_get_my_coat@lemmy.worldEnglish
        2·
        2 months ago

        Thanks for looking into it :)

        Unraid is a linux-based server OS for NAS that can run VMs, dockers, and other things - and the CA is the go-to for installing 99% of the plugins and dockers that one would typically use.

        I’ve not heard of those two you mentioned, but I’ve heard proxmox mentioned in the same context, so it could be considered similar to that?

        • KillianLarcher@lemmy.worldOPEnglish
          2·
          2 months ago

          Okay, yeah, I see. Unraid Community Apps is probably closer to something like Proxmox VE Scripts. Dokploy and Coolify are more like libraries of templates for Docker services.

  • abecede@lemmy.worldEnglish
    2·
    2 months ago

    Can you explain to me how the core backup process works? I browsed the git repo, but could not find it after about 10 minutes.

    For example PostgreSQL: does it just do a pg_dump of a whole database? Or table for table? What about incremental backups? Are these implemented? And if so, what’s the concept behind it?

    Otherwise I would not see any use for larger (dozens of gigabytes and more) databases.

    • KillianLarcher@lemmy.worldOPEnglish
      2·
      2 months ago

      Currently, the backup process is logical. Incremental backups are not implemented yet, as supporting them across multiple database systems (PostgreSQL, MariaDB, MongoDB, etc.) would require significant development effort.

      The system relies on the database’s native tools when possible, such as pg_dump for PostgreSQL or mongodump for MongoDB. Table-level backups are not currently supported, but could be introduced in the future if there is enough demand.

      • abecede@lemmy.worldEnglish
        1·
        2 months ago

        Thanks for the clarification. Now I know, that I’ll stick to my daily cronjob that just runs pg_dump via ssh to another machine. I get e-mail notifications with my simple shell script as well.