Cloud Databases
RocketRide Cloud runs PostgreSQL databases for its built-in database nodes, so a
pipeline can keep data without a database of its own. The
rocketride_sql,
rocketride_vector and
rocketride_graph nodes use them. This page covers
what an app or pipeline owner gets: which database holds the data, the limits,
what happens to the data when people, teams, organizations or apps go away, and
what the backups cover. How each node reads and writes is on its own page.
One database per organization
Every organization has one database, shared by all of its members. Each team also has its own database, and each member has a personal database in every organization they belong to. A node's Database setting picks one of the three and defaults to the organization's.
- A database is created empty on the first run that needs it. Every database
comes with pgvector and Apache AGE installed and a graph named
rocketride. - A run uses the databases of the organization it runs in. An app from the store starts its pipelines as the person using it, in that person's organization, so each organization that uses an app keeps that app's data in its own databases, not in the publisher's. A deployed pipeline runs in the organization it was deployed from, whoever calls it.
- There is no database or schema per app. Every app and pipeline that uses the
same database can read, change and drop the same tables in the
publicschema, so give your tables names that will not collide with another app's, for example with a prefix.
Limits
These limits apply to each database on RocketRide Cloud today:
| Limit | Value |
|---|---|
| Transactions at once | Up to 6. A transaction that cannot get one waits up to 60 seconds, then fails. |
| Idle open transaction | Closed after 10 minutes. |
| Session state | Connections are pooled per transaction, so SET, temporary tables, LISTEN and session advisory locks do not carry over to the next transaction. Use SET LOCAL. |
Each node adds its own query timeouts and row caps; see its page. For example, the SQL node runs the queries it writes for a question read-only, with a 60-second limit.
There is no quota per database on storage, tables, rows or queries per minute. All databases run on one shared PostgreSQL cluster, so its disk, memory and connections are shared by every organization.
When data is removed
Removing an app does not touch any database. Removing a member, a team or an organization retains its databases first and deletes them later.
| Event | Databases affected |
|---|---|
| An app is removed from a desktop, or its subscription ends | None. The tables the app created stay where they are; drop them yourself when you no longer need them. |
| A member leaves an organization or is removed from it | That member's personal database in the organization |
| A team is deleted | The team's database |
| An organization is deleted | The organization's database, every team database and every member's personal database in it |
A retained database is closed: its login is disabled, its open connections are cut, and a run that needs it fails at start. Its data is kept for 30 days.
- A member who rejoins the organization within those 30 days gets their personal database back as it was. Once the cleanup has deleted it, they start with an empty one.
- A deleted team or organization cannot be brought back from the product.
- After 30 days a daily cleanup takes a final copy of the database (a
pg_dump) and then deletes it. A database whose copy fails is not deleted. The final copy is held by RocketRide and is not offered for download.
Backups
-
Changes are archived continuously, and a full backup is taken every day. Backups cover the last 30 days; older ones become eligible for deletion.
-
Live data is held on a primary and two replicas; a commit is on at least one replica before it is acknowledged.
-
Backups are configured for point-in-time recovery of the whole cluster, never of one database. There is no restore of one organization's, team's or member's database, and no self-service restore. Within the 30-day retention above, the only way back is a removed member rejoining, which returns their personal database; a deleted team or organization cannot be brought back.
-
After a member, team or organization is removed, its data remains in separate places, each with its own clock:
- The database itself: deleted by the daily cleanup once 30 days have passed, later if its final copy fails.
- Backups that hold it: eligible for deletion 30 days after the database is deleted, later while a backup is still needed for recovery.
- Backup files pruned after that: eligible for deletion 35 days later; the storage removes them some time after that.
- The final copy taken before deletion: no expiry is set today.
These are the earliest points at which each copy can be deleted, not dates by which it is gone.
Export
There is no export today. RocketRide offers no download or dump of a database,
and the databases accept connections only from inside RocketRide Cloud, so a
SQL client or pg_dump on your machine cannot reach them.
To take data out, read it through a pipeline and write it where you need it:
- SQL: with direct query execution on, run
SELECTstatements through the node'sexecutetool orclient.database.query()in the TypeScript or Python SDK. A query returning more rows than the node's execute row limit fails, so page through a table. - Vector: with Expose as tools on,
list_documentslists the stored documents andgetpages through one document's chunks.getreads at most 10,000 chunks of a document, so a larger one comes back markedtruncated, and a document in the trash is refused until it is restored. - Graph: with direct execution on, run a
MATCH ... RETURNquery throughexecute, in pages that stay under the node's execute row limit.
Related
rocketride_sql,rocketride_vector,rocketride_graph: the nodes that use these databases, and which database each run may use.- Cloud: connect a client to RocketRide Cloud.
- Security: what a running pipeline can see.