Completely new to retool, and thinking of migrating my saas from Adalo to Retool, I was wondering how would one migrate the database, given that Adalo database has different multiple collections, and these collections have connections between them that must be kept intact to retrieve all the info as it is right now, what is the best way to do so? and if anyone did it successfully without issues,
If you would like to use a different database, like your own PostgreSQL db hosted elsewhere, you may need to use Adalo's API to query your db from Retool using a REST API Resource and sending this data to the new database the same way (GET data from Adalo and POST to your database).
Retool has a 100MB query size limit on Cloud. If your collections are heavier than this, you may need to use pagination to migrate your data by chunks. You could also create a Workflow to automate this process.