Is there any plans to expose an endpoint to progra...
# help
n
Is there any plans to expose an endpoint to programatically create a new Postgres Database? I have a use case where every customer needs their own DB and supabase would fit our use-case perfectly if we could programatically create the databases when needed.
n
Hello @nicksrandall! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the
/title
command! We have solved your problem? Click the button below to archive it.
d
Every customer needs their own DB or table?
n
nicksrandall (2022-03-17)
n
Own db.
a
Wouldn't multi-tenancy in the same db work?
n
No, users can write custom data so each DB would have a different set of tables and a different schema
I could just namespace each table with the customer ID.
a
Did you try a
create database
call using
rpc
?
n
I have not tried that (yet). What I really want is the ability to create a whole "project" complete with a new DB and a Postgrest instance.
a
Could it be done at the infrastructure level? To provision a hosted environment using terraform (or any other infrastructure as code tool)
n
Yes, I could build all of this myself. I was hoping to pay supabase for this since they already have all the pieces and then I would have one less thing to manage.