Skip to content

Databases

How to manage databases in Sproobo

Sproobo provides managed database services for your applications. Deploy PostgreSQL, MySQL, Redis, and other databases with automatic backups and management.

Supported Databases

Database Types

  • PostgreSQL: Production-ready PostgreSQL database
  • MySQL: MySQL database with InnoDB engine
  • Redis: Redis cache and message broker
  • MongoDB: MongoDB NoSQL database (coming soon)

Database Features

Key Features

  • Automatic backups and restores
  • High availability with replication
  • Automatic scaling
  • Connection pooling
  • Performance monitoring
  • Secure connections with SSL

Getting Started

To deploy a database, navigate to Project → Databases and click "Create Database".

Sproobo databases page
Navigate to Databases to create and manage database instances.

Connecting to Databases

  1. 1

    Get Connection String

    After creating a database, go to Database → Settings → Connection to view the connection string.
  2. 2

    Add to Environment Variables

    Add the connection string as an environment variable in your deployment:
    • Key: DATABASE_URL
    • Value: [connection string from database settings]
    • Type: Secret (to encrypt the connection string)
  3. 3

    Use in Application

    Your application can now connect to the database using the connection string.

Database Backups

Sproobo automatically backs up databases:

Backup Features

  • Automatic Backups: Daily automatic backups
  • Retention: 30 days of backup history
  • Point-in-Time Recovery: Restore to any point in time
  • Manual Backups: Create backups on demand
  • Export: Export backups for offline storage

Next Steps

Now that you know about databases: