Configuration

Configure Stabilize ORM for your database

Database Configuration

Create a configuration file to connect to your database:

config/database.tstypescript

import { DBType, type DBConfig } from "stabilize-orm";

const dbConfig: DBConfig = {
  type: DBType.Postgres, // or DBType.MySQL, DBType.SQLite
  connectionString: process.env.DATABASE_URL,
  retryAttempts: 3,
  retryDelay: 1000,
};

export default dbConfig;

PostgreSQL Configuration

config/database.tstypescript

const dbConfig: DBConfig = {
  type: DBType.Postgres,
  connectionString: "postgresql://user:password@localhost:5432/mydb",
  retryAttempts: 3,
  retryDelay: 1000,
};

MySQL Configuration

config/database.tstypescript

const dbConfig: DBConfig = {
  type: DBType.MySQL,
  connectionString: "mysql://user:password@localhost:3306/mydb",
  retryAttempts: 3,
  retryDelay: 1000,
};

SQLite Configuration

config/database.tstypescript

const dbConfig: DBConfig = {
  type: DBType.SQLite,
  connectionString: "myadb.db",
  retryAttempts: 3,
  retryDelay: 1000,
};

Environment Variables

It's recommended to use environment variables for sensitive data:

.envdotenv

DATABASE_URL=postgresql://user:password@localhost:5432/mydb