Selfhosted

61923 readers

383 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

Be civil.
No spam.
Posts are to be related to self-hosting.
Don't duplicate the full text of your blog or readme if you're providing a link.
Submission headline should match the article title.
No trolling.
Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details. Tags [CBH] or [AIP] are required, see the links in Rule 8 for details.
AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post, and find example disclosures here.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago

MODERATORS

curbstickle@anarchist.nexus

curbstickle_lw@lemmy.world

Portabase v1.10 - database backup/restore tool, now supporting Firebird SQL (github.com)

submitted 5 months ago* (last edited 5 months ago) by KillianLarcher@lemmy.world 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.

top 7 comments

sorted by: hot top controversial new old

[–] aegg@europe.pub 2 points 5 months ago (1 children)

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

[–] KillianLarcher@lemmy.world 1 points 5 months ago

Thanks! PostgreSQL is well supported (it was the first database implemented). Feel free to open an issue on GitHub if you want to suggest any improvements.

[–] amateurcrastinator@lemmy.world 2 points 5 months ago

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

[–] Cyber@feddit.uk 1 points 5 months ago (1 children)

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

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

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

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

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