Skip to main content

​
Overview

Zanode provides managed PostgreSQL databases running in the same South African data center as your application. Zero latency between your app and database.

​
Create a database

1

Go to your project

Navigate to your project in the dashboard.
2

Click Databases

Select the Databases tab.
3

Create database

Click Create Database and choose a name.
Your database is ready within seconds.

​
Connection string

Once created, your connection string is automatically added to your environment variables: 
DATABASE_URL=postgres://user:password@host:5432/database
The connection string is encrypted at rest and only available to your application.

​
Connecting from your app

​
Node.js (pg)

import pg from 'pg';

const pool = new pg.Pool({
  connectionString: process.env.DATABASE_URL
});

const result = await pool.query('SELECT NOW()');

​
Prisma

// prisma/schema.prisma
datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

​
Drizzle

import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';

const client = postgres(process.env.DATABASE_URL!);
export const db = drizzle(client);

​
Backups

Databases are backed up automatically every day at 2:00 AM. You can also trigger manual backups and restore from the dashboard.

​
Managing backups

1

Go to Databases

Navigate to your project → Databases tab.
2

Click Manage backups

On your database card, click Manage backups.
From the backup modal you can:
  • View backup schedule — See when automatic backups run
  • Trigger manual backup — Click “Backup now” to create an immediate backup
  • Restore from backup — Select a backup file and click “Restore”
Restoring a backup replaces all current data. This cannot be undone.

​
Limits

PlanStorageConnections
Free1 GB10
Pro10 GB50
Team50 GB100