Exporting a database from the cloud to create a template for other cloud users

Hi there,

We are hoping to build an equivalent template on Baserow which we have released via Airtable called AirRegister. It’s a share register for co-operatives to manage their members and investments.

We are building it on the cloud version of Baserow and are hoping to have a mechanism to share it with other organisations that will likely use the cloud version of Baserow. I know there is not currently a ‘Template Marketplace’ but wondered if there is an interim process to export / share the database and make it available to other users.

Thanks,

Simon

Hello @Commonly, welcome to the Baserow community! :wave:

@HiramFromTheChi and @frederikdc, could you help Simon here?

1 Like

Hey Simon @Commonly :wave:

This is a great use case. Unfortunately, not having a dedicated template marketplace makes our process for sharing and duplicating templates kinda tricky at the moment.

I’ve tried to solve this problem myself in the past (with a personal use case), and here’s what I came up with:

  1. Create an export of every table inside the database. (I usually like working with the JSON format in cases like these.)
  2. Create a compressed (.zip) file of all the tables.
  3. Share the exported tables with your users.
  4. Draft and share documentation of each field and the field types that exist so that the users can recreate the template exactly.

Needless to say, this process is not as streamlined as it could be, but it’s what we can work with at the moment until we have duplicate template functionality and a marketplace to go along with it. :slight_smile:

If you want to see how this would work on a practical level, I actually have a real-life product that I built called Reddit Account Manager. Here’s the documentation for the process:

You can also check out the original doc here, which has all the details. I know it may be tricky to see everything on this tall screenshot.

If you find a more streamlined way of doing this in the process, let me know! I’m sure the community would like to learn.

1 Like

Hi Simon @Commonly

A more streamlined approach would be the use of the Baserow API with an automation service like N8N - which is also open source. This allows you to automatically create a new application (database) after your user has authenticated.

Once you have created the new database, you can use the API endpoints to create tables, fields, views and import data.

I can try to prepare a demo if this approach looks like a solution to you

2 Likes
1 Like

Thank you @frederikdc - this looks like a great approach. I’ll work through your guide and get in touch if I have any questions.

1 Like

Frederik’s solution seems to be more streamlined, so I’d go with that. :slight_smile:

@frederikdc Q for you: does this require the recipient (the person who wants to clone the database) to also have n8n, or no?

I use my own n8n workspace at the moment which can takes 5000 executions a month. So, non-professional users can use that one.

Hi there, I was just wondering if there was any update on being able to submit and share templates as this would help our use case massively!

Hey @Commonly, we haven’t built an easy way to add new templates yet, but we plan to have a community templates marketplace in the future. Also, when we add the feature to share a whole database, it’ll simplify the process a lot.

Could you tell us about the template you want to share?

We have developed a share register template for co-ops in the UK on Airtable www.air-register.co.uk and would like to replicate it on Baserow but we need the ability to easily share the template (application and database) with other co-ops / users.

Do you have a timeframe for the share database feature?

Hey @Commonly, nice! I’ll check with the team to see which quarter we can expect the shared database feature to be released.

Hi @olgatrykush,

I wondered if you had any update on timings for the release of database / template sharing?

Hey @Commonly, not yet! I’ll keep you posted :raised_hands: