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
Resources > Databases > New database (or Create > New database, or New database on Home).
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.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 ( |
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).
Resources > Services > New service. Pick one template, then its Version, Size and Team; What will be created shows the result before anything happens.
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.