KillianLarcher

joined 2 months ago
 

Hello all!

I’m one of the maintainers of Portabase, I share about it on Lemmy one month ago (https://lemmy.world/post/45042565) and I have some updates!

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

Database homogenous migration is now built-in!

Previously, migrating meant:

  • Download backup from the source DB
  • Upload & restore it into the target DB

Now: no download, no upload, everything happens directly through the GUI.

It works with all supported databases, and migrations can be done within the same organization.

We also added support for Microsoft SQL Server! It still needs broader community testing to help identify bugs or edge cases we may have missed.

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

We now support 9 databases:

  • PostgreSQL
  • MariaDB and MySQL
  • SQLite
  • MongoDB
  • Redis and Valkey
  • Firebird SQL
  • Microsoft SQL Server

What’s new since version 1.10:

  • Healthchecks for both the database and the agent (with optional notifications)
  • Homogeneous database migration
  • Support for Microsoft SQL Server

If you’re using Microsoft SQL Server (or any other supported database), we’d really appreciate your feedback. Feel free to open issues if you find any bugs.

[–] KillianLarcher@lemmy.world 1 points 1 month ago (1 children)

Hi, Portabase handles database backup and restoration. It does not manage the migration process, so it depends on the type of database and whether migration is handled automatically or not.

 

Hi community,

I’m one of the maintainers of Portabase, I shared it here for the first time two weeks ago and I have now some updates!

After an initial request from a community user in mid-January, and a few more along the way, we’ve finally added support for Firebird SQL. It seems to have a solid community behind it even though I hadn’t heard of it before.

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

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

So it now we support 8 databases: PostgreSQL, MariaDB, MySQL, SQLite, MongoDB, Redis, Valkey and Firebird SQL

What’s new in version 1.10:

  • Support for Firebird SQL (obviously)
  • Healthchecks for both the database and the agent (with optional notifications)
  • End-to-end tests to prevent regressions (coverage is still light, but we’re working on it)

What’s coming next:

  • Support for Microsoft SQL Server

If you’re using Firebird SQL (or any other supported database), we’d really appreciate your feedback. Feel free to open issues if you find any bugs.

[–] KillianLarcher@lemmy.world 1 points 1 month ago

Do you document the manual restore process for those?

No, we haven’t documented it yet, but that’s a good idea. I’ll add it to the backlog, and we’ll work on it soon!

[–] KillianLarcher@lemmy.world 1 points 2 months ago (2 children)

Hi,

  1. The agent need to be on the same network as your database. You can either include the agent in the same Docker Compose setup or create a Docker network to link them. I’m not sure what you mean by 'persist across restarts.' Can you clarify? However, it works perfectly fine with databases running in Docker.

  2. For Redis and Valkey, hot restores are unfortunately not supported. You need to stop the services and perform some manual operations. This limitation is why backups are mainly useful for disaster recovery rather than live rollback.

Feel free to ask any other questions or clarification if needed.

[–] KillianLarcher@lemmy.world 2 points 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.

[–] KillianLarcher@lemmy.world 3 points 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.

[–] KillianLarcher@lemmy.world 0 points 2 months ago (2 children)

I wasn’t aware of this. I’ll take a look! Is it similar to Dokploy or Coolify?

[–] KillianLarcher@lemmy.world 2 points 2 months 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.

[–] KillianLarcher@lemmy.world 4 points 2 months ago (3 children)

Hi @morethanevil@lemmy.fedifriends.social, We’ve received similar feedback from other users, so we are currently working on it. However, this requires changes to some internal processes, as the system was not initially designed this way. Thanks for the feedback!

 

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?