51
Portabase v1.10 - database backup/restore tool, now supporting Firebird SQL (github.com)
submitted 4 months ago* by to c/selfhosted@lemmy.world
7 comments fedilink hide all child comments
 

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.

all 7 comments

sorted by: hot top controversial new old
[–] 2 points 4 months ago (1 child)

Looks very interesting, will try this out. pg_dump and restore stresses me out

  • permalink
  • fedilink
  • source
  • hideshow 2 child comments
    •
    • [–] 2 points 4 months ago

    I want to use it to backup my overleaf instance and mongodb that it uses

  • permalink
  • fedilink
  • source
    •
    [–] 1 point 4 months ago (1 child)

    I had a quick look at the docs... so, can I backup my DB version X and restore it to DB version Y?

  • permalink
  • fedilink
  • source
  • hideshow 2 child comments
    •
  • [–] [S] 3 points 4 months ago (1 child)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 2 points 4 months ago (1 child)

    So to jump on this question because I am also interested: I can use this to create a backup of database version x and migrate to y and the backup again. Or if migrating goes bad restore x from backup

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] [S] 1 point 4 months ago

    Yes, this is one of the common use cases.

    You can back up version X and perform the migration to version Y. If anything goes wrong during the migration, you can simply restore version X from the initial backup (you will, of course, need to downgrade to the original database version before restoring).

  • permalink
  • fedilink
  • source
  • parent