Multiple internal databases or database table isolation

💬 Feature Requests
1

I was trying this solution out to see if it would work for my needs, but as far as I can see (and some old forum posts as well), there's only a singular internal database available. Is there any option for multiple internal databases (e.g. per app) or some table isolation feature that ties tables to apps? Being limited to a single internal database really reduces the usefulness of this tool from my perspective.

2

Hi @nehpets and welcome to Retool!

You are correct, Retool only offers one Retool database. As far as a table isolation feature, I can think of 2 things for you:

  1. Use schemas. Creating a schema is simple enough CREATE SCHEMA app1, CREATE SCHEMA app2 then use them in queries. Be sure to use fully qualified names when referencing tables schema.table. If using Retool queries or GUI table editors, make sure to reference the full path, since Retool’s default schema is usually public..

  2. Get a free Neon account and set up as many databases as you want. This is what Retool uses under the hood. It's really simple to add a resource per db and then use one per app. In Neon even with the free version you will have much more control.

Hope this helps!

1 Like
3

Agreed with @Shawn_Optipath's recommendations :sunglasses:

Your feature request aligns with how we are thinking about improvements to Retool Database, though. We have a project in progress to implement multiple internal databases. I don't have a timeline for shipping this feature yet, but I'll follow up here if I hear anything.