Options to Backup Softr Database

Ask the community
1

We’ve started using the built in Softr DB’s and its now our master for a bit of information. What options are there to export or automate a backup process? We host a local SQL db so I’m hoping we could automate a dump of the Softr DB to a local mirrored copy but open to other suggestions as well!

7 Likes
2

+1

3

+1

4

+100

5

@Logitone I might just use N8N to sync it to Supabase but it is tricky since of so many relationships and column labels that would change. But for me recently I had some data deleted and could not restore it easily even though it was the Softr Database and realized how important this feature is.

6

I know the Database feature is still new and developing but hopefully someone at Softr can speak to near-future plans in regards to backup options? @Jjenglert ?

1 Like
7

Thanks for your question. We already have technical backups on our side, but for the user side, we will be introducing history snapshots in the next two to three months.

3 Likes
8

Thanks JJ. Have there been any discussions around an export functions?

9

Yes, export will be coming as well. In the meantime, we can process it manually for those that need it.

10

Thanks for the fast response JJ. Nice to know that its on the roadmap!

1 Like
11

Anytime!

12

@Jjenglert any thoughts on options till then? Like right now I have n8n hitting the api to get all tables then each table getting all rows and dumping that into a simple supabase schema but even then I can recover data but the connection of relationships is tricky I guess.

I have a workflow and schema https://www.newsdailyai.studio/ here is anyone wants it btw top block of the workflows

13

What is your goal here? Like I said, we already have technical backups on our side in case anything happens.. Why do you need more than that at the moment?

14

+1

15

Giving this a bump. Is there an update on timings for this?

Also as a chronically indecisive builder I find myself wishing for a version history/”undo” button on an almost hourly basis? :rofl:

16

@nfpSpark working on snapshotting feature :slight_smile: no clear timeline yet but expect end of this Q.

2 Likes
17

Any updates on the timeline of version history & undo/redo?

1 Like
18

Any updates?

19

MVP suggestion:

Make it possible to send a .csv file for each database table as an email attachment through workflows

20

Hows this going? Need something now. Planning on leaving