Portabase 1.14: Open source database backup/restore tool

https://github.com/Portabase/portabase

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.

50 points · 9 comments · view on lemmy.world

9 Comments

OpenAltFinder@lemmy.world · 3 pts · 113d (6 replies)

I was actually looking for a nice self-hosted too like this. I've also added Portabase to OpenAltFinder so that others can find it too.

KillianLarcher@lemmy.world · 1 pts · 108d

Thanks for adding Portabase to OpenAltFinder! I missed your message earlier, but I appreciate it.

Alfredolin@sopuli.xyz · 1 pts · 113d (4 replies)

Ente as altrrnative to Google Authenticator? I think their's a mistake there.

OpenAltFinder@lemmy.world · 2 pts · 113d (3 replies)

Ente Auth is an alternative to other 2FA tools tho. It's just that it's part of the whole Ente suite.

Alfredolin@sopuli.xyz · 1 pts · 113d

Whut? Did not know that. Nice.

non_burglar@lemmy.world · 1 pts · 113d (1 reply)

Ente auth is not self-hosted.

OpenAltFinder@lemmy.world · 1 pts · 112d

I know that, but it's part of the self-hostable Ente suite. I might remove it as a 2FA alternative, as it seems to confuse people.

clifmo@programming.dev · 2 pts · 109d (1 reply)

Nice to see the flurry of activity on this young project. I Considering deploying to my swarm to handle restore only. I have a bare metal db VM using cron to dump dbs, and autorestic handles retention with deduplication. This works well for me since my homelab is generally pretty quiet.

Two things I'd like/want to see: deduplication either via supporting Restic as a backup backend and swarm-style SECRET_FILE support (I forked and may PR this one)

KillianLarcher@lemmy.world · 1 pts · 108d

Thanks for the feedback! Feel free to open issues for these ideas. A PR for SECRET_FILE support would be very welcome.