Skip to content
User guide

Databases and services

Create a managed Postgres database, browse and query it, back it up and restore it, and run caches or database servers as services linked to your projects.

Create a database

  1. Resources > Databases > New database (or Create > New database, or New database on Home).

  2. Fill in Name (for example pricing), a Description ("Prices for the pricing service"), the Size allowance (MB) (empty takes your organisation's default; a full database turns read-only) and Backups.

  3. Click Create database.

Each database is an isolated Postgres schema with its own login. A project can also get its database automatically: when its code asks for one, REM CloudHub provisions it on deploy and hands over the connection settings as environment variables.

One database's page

Tab

What you do there

Tables

Click a table to see its first rows; New table, Add row

Query

Write SQL (select * from quotes limit 20) and Run query. Queries are read-only unless you tick Allow writes on a database you own

Diagram

How the tables connect: an arrow goes from a table to the tables that refer to it

Backups

Back up now, and restore a backup into the same or a new database. Restore asks you to type the database name first

Access

Who else may read or change it

Usage

Size against its allowance, over time

Logs

Queries and slow queries

A project's own schema is read-only to people: the app's migrations change it.

Services

A service is a cache, queue or database server running for your organisation from a template your platform publishes (for example Redis or a Postgres server of your own).

  1. Resources > Services > New service. Pick one template, then its Version, Size and Team; What will be created shows the result before anything happens.

  2. Review, then Create service.

On the service's page: Connection (the address and login; Reveal shows the password after you confirm your password and, if you use one, your authenticator code), Restart, Stop, Start, Settings, Backups (kept in the platform's file store; Back up now, Restore; a final backup is taken on delete) and Linked projects. Link project with a Variable prefix (such as CACHE) to tell two services apart: the project gets the connection settings as environment variables starting with that prefix.

Delete asks you to type the service name; Delete even if the final backup fails is a separate, explicit choice. A deleted service can be restored from the Deleted view.

Warehouse

Resources > Warehouse lists your data sources. By default these are REM CloudHub's managed databases. With the warehouse add-on, an organisation admin connects its own database or warehouse, presses Test (it checks the network path only, never signs in or queries), and makes a binding secret: the environment variable projects and jobs read to reach it.

Download: PDF · Word · Markdown

Databases and services | REM CloudHub docs · REM CloudHub