Scale up as you grow — whether you're running one virtual machine or ten thousand.

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.

Greetings,
I’m learning how to use the DO App Platform. I saw some guides on how to deploy to the App Platform using the app.yaml file. I can attach it here without the sensitive info:
name: *************
services:
_#_ _Backend API Service_
- name: api
source_dir: /
github:
repo: *************
branch: main
run_command: npm run start:prod
build_command: npm ci && npx prisma generate && npx @nestjs/cli build
environment_slug: node-js
instance_count: 1
instance_size_slug: apps-s-1vcpu-1gb
envs:
- key: NODE_ENV
value: production
- key: PORT
value: "8080"
- key: DATABASE_URL
value: ${db.DATABASE_URL}
- key: JWT_SECRET
value: *************
health_check:
http_path: /health
http_port: 8080
routes:
- path: /api
static_sites:
_#_ _Frontend Angular Service_
- name: web
source_dir: /
github:
repo: *************
branch: develop
build_command: npm ci && npm run build
environment_slug: node-js
output_dir: *************
envs:
- key: NODE_ENV
value: production
index_document: index.html
catchall_document: index.html
_#_ _Managed PostgreSQL Database_
databases:
- name: db
engine: PG
version: "17"
production: false
As I understand, setting ‘databases.production’ to ‘false’ will create a dev database which has restricted permissions. I know that the user ‘db’ which is the same username as the instance will not have permissions to create other databases or other schemas. It will only have permissions on my own dev database created here in the public schema. The thing is: The ‘db’ user doesn’t have permissions to create tables on its own ‘db’ database. I’m not sure if I’m doing something wrong but I tested login to the database using the psql and the connection string but I cannot create tables:

Thank you in advance for your help!
3630316526124b4190e628cd69be1e
a6309a057c3f4cb38fb2e7feb67236
KFSys
a0aa4c11068a4e98bc3cde06ce6c8c
Kailey Ketchum
Matteo Scarpa
Matteo Scarpa
fullammo
1a3ca91ed97c49039b3e74fb7229fa
jamshed.latipov
Thomas Brocken
Vaishnavi Vundyala