Databases |

flowchart
    workspace1[Workspace]
    project1[Project]
    workspace1 --> project1
    project1 --> app1
    project1 --> worker1
    project1 --> db1
    project1 --> app2
    project1 --> worker2
    project1 --> db2
    subgraph prod [<br/><br/><br/><br/><b>Production</b> Environment<br/>]
        class prod cssClass
        app2[Application]
        worker2[Worker]
        db2[Database]
    end
    subgraph dev [<br/><br/><br/><br/><b>Development</b> Environment]
        app1[Application]
        worker1[Worker]
        db1[Database]
    end
    classDef highlight-app fill:#6de5df,color:#000;
    classDef highlight-worker fill:#214543,color:#fff;
    class app1,app2 highlight-app;
    class worker1,worker2 highlight-worker;
    click workspace1 "/docs/platform/workspaces"
    click project1 "/docs/platform/projects"
    click app1,app2 "/docs/platform/applications"
    click worker1,worker2 "/docs/platform/applications"
    %% click db1,db2 "/docs/platform/databases"

Creating Databases

Setting up a database in Stackblaze can be done in a couple of clicks! The steps on this page will show you how to add a Postgres database to your Stackblaze Project and connect it to an App.

From your Project’s Overview page, click the Add new button and select Postgres database from the options shown
Give the database a name
Choose a region – your data will live here
Configure the scaling settings

Connecting to the Database

Navigate to the Environment Variables tab of your Stackblaze Application
Stackblaze will automatically detect the database and show a banner allowing you to import database credentials. Click the “Import database credentials” button
In your code, access the credentials using process.env.DATABASE_URL

How you use the DATABASE_URL environment variable will differ depending on your chosen database client.

Node.js

Sequelize

Sequelize has a number of ways to specify connection details. Below are a couple of examples.

Firstly, directly specifying connection details:

const sequelize = new Sequelize(process.env.DATABASE_URL);

Or via the use of a config file:

{
  "local": {
    "use_env_variable": "DATABASE_URL",
    "logging": false
  },
  "development": {
    "use_env_variable": "DATABASE_URL",
    "logging": false
  },
  "production": {
    "use_env_variable": "DATABASE_URL",
    "logging": false
  }
}

...
const env = process.env.NODE_ENV || 'development';

const config = require(__dirname + '/../config/config.json')[env];
const db = {};

let sequelize;
if (config.use_env_variable) {
  sequelize = new Sequelize(process.env[config.use_env_variable], config);
} else {
  sequelize = new Sequelize(config.database, config.username, config.password, config);
}
...

Prisma

Configure your schema.prisma file as follows:

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

See Prisma’s documentation for more information.

Connecting from an External Client

Stackblaze databases can be accessed from a client like PGAdmin from your own machine. The connection details can be found in Stackblaze on the Connection Info tab of the database.

Databases