Move a database to a different group?

I might be missing something really obvious but I can’t find anything in the UI that allows me to move a database to a different group.

I searched this forum as well for “relocate database” and “move database” and don’t seem to see anything.

If the operation is unclear, here is more clarity: I just have one group for personal databases and one for work databases and the work group I share with the team and the person I don’t. I now have, however, one personal database I want to share with the team so I want to move it into the team group.

Thanks for any direction on this!

1 Like

Hey @bfranklin :wave:

Perhaps not the ideal solution you were looking for in terms of a one-click migration, but something you could do in the meantime until this feature ships is to export the tables that you want to move out of the current group and import them into the database that lives inside your work group.

Hope this helps!

Thanks @hiram. I guess this hasn’t been roadmapped yet? Glad I wrote it then to see if others find themselves in the same bind I’m in.

Sure thing @bfranklin—I can’t speak to the ETA of specific features, but the dev team constantly works to incorporate and deliver everyone’s suggestions.

There’s quite a lot! :sweat_smile:

I’m sure you’re not alone in your request, and there may be others that interest you as well. GitLab is typically the best place to keep tabs on this.

2 Likes

To sidestep the need to wait on this to be added, one can manually change the assignments of databases to groups directly inside the postgres database. I used TablePlus GUI editor to do this and then the table to edit is called “core_application” where you’ll find all your databases listed and assigned to groups. It looks like there is also a “core_group” table. There is also an “order” table in “core_application” which allows for the manual reordering of databases inside a group. By default right now, all databases are assigned an order of “1” and if you alter these then they are ordered from smallest to greatest number.

Doing this manually has always to be accompanied with a warning. Maybe you can make a tutorial/guide so users who want to manually do this have the least chance of an error.

1 Like

Agreed @Peter … definitely edit database at your own risk. The minor changes I outline above worked for my needs of moving a database to a new group and reordering databases within a group but it’s possible could lead to something unexpected in the future so I made note of the changes to remember and if I run into trouble down the line I can revert back.

1 Like

Bump, looking for the same.

All the formulas need to be rewritten as well then :frowning:

I would also love to be able to do this easily. I just spent a decent amount of time setting up a database before I realized that it needs to be in a different group.

I’ve created an issue for this on the backlog (Move databases/application to another group (#1359) · Issues · Bram Wiepjes / baserow · GitLab). It is possible to to move the database to another group by making a small change directly in the PostgreSQL database. Are you using the hosted or self-hosted version?

Self hosted version.

Beside that, would it be possible to also re-order groups?

You should be able to re-order groups via drag and drop. Does it not work for you?