Skip to main content

PostgreSQL

Primary data store for AppServer and applications.

Overview​

PostgreSQL stores:

  • Application metadata
  • User data
  • Settings (encrypted)
  • Activity logs
  • Event history

Schema​

TODO: Document database schema:

  • appserver schema - Core tables
  • Application schemas - Per-app tables

Connection​

See Database Configuration

Migrations​

TODO: Document migration strategy

Performance​

TODO: Document performance tuning:

  • Indexing strategy
  • Query optimization
  • Connection pooling
  • Vacuum and maintenance

Backup​

TODO: Document backup procedures

Monitoring​

TODO: Document monitoring metrics