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?

  • morethanevil@lemmy.fedifriends.socialEnglish
    3·
    1 day ago

    I tried it a few versions ago, but why could I not configure the agents via the web UI? Why a editing manually a json or toml per database? Is this possible now? Connect the agent one time with the dashboard and do the rest via UI? This is a feature I really want

      • tripping335@piefed.socialEnglish
        3·
        21 hours ago

        Personally, I think going local file config first was the right decision, depending on what the target audience is. For homelab users with one or two databases it may seem like extra work. For professionals or advanced users who like, or even need, to automate using tools like Ansible etc this makes it easier to deploy on larger scale. You can of course allow users to update settings after the fact through the UI while keeping the json file. I have dropped projects in the past due to the exact issue that its only configurable to the UI that makes bulk operations or automation hard or impossible.

        I’m currently using shell scripts (pg_dump) and crontabs to back up my databases, so thanks, will check it out!

        • KillianLarcher@lemmy.worldOPEnglish
          3·
          20 hours ago

          Thanks for sharing your use case. To be transparent, we didn’t consider automation when we created the local file config, but it’s indeed the perfect use case for this mode of operation. In any case, we’ll keep the current behaviour to avoid breaking changes. This will be introduced as an additional feature.

      • morethanevil@lemmy.fedifriends.socialEnglish
        5·
        1 day ago

        Okay, will keep an eye on the release notes and give it another try if this is implemented! Anyway it is great that remote backup is supported this is a feature other tools like Databasus don’t have.

        • KillianLarcher@lemmy.worldOPEnglish
          2·
          1 day ago

          I’ll keep you updated on this. And yes, remote backups are one of our key differences compared to other systems: the agent-based architecture enables operations across multiple networks without requiring SSH tunnels or exposing databases publicly.