This might be another dumb question but when in development, would one of those hosted databases + 1 prisma server be enough for multiple prisma projects?

yes, we store different services isolated from each other in the a single database

thanks! Also in production?

yes, backend/dev is separate from backend/prod. We store them in separate schemas

so in production you also use one database for multiple projects, separated in environments?

yes, that is same model we use with our demo servers

oke thanks!

each service's data is stored in different database in the same database server

and that database could be clustered , replicated and horizontally scalling

yeah I think that is what digital ocean provides now as well

they are actually late to the game haha

yup