Database Configuration

SQLite (Development)

1. Modify demo-app/Cargo.toml

[dependencies]
runique = { version = "1.1.53", features = ["orm", "sqlite"] }

2. Update .env

DATABASE_URL=sqlite:runique.db?mode=rwc

3. Restart

cargo run -p demo-app

SQLite by default, PostgreSQL recommended for production.

1. Install PostgreSQL

macOS:

brew install postgresql
brew services start postgresql

Linux (Debian/Ubuntu):

sudo apt-get install postgresql postgresql-contrib
sudo systemctl start postgresql

Windows:

• Download the installer
• Follow the installation wizard

2. Create the User and Database

-- Connect as admin
psql -U postgres

-- Create the user
CREATE USER runique_user WITH PASSWORD 'secure_password';

-- Create the database
CREATE DATABASE runique OWNER runique_user;

-- Grant permissions
GRANT ALL PRIVILEGES ON DATABASE runique TO runique_user;
GRANT ALL PRIVILEGES ON SCHEMA public TO runique_user;

3. Configure .env

IP_SERVER=127.0.0.1
PORT=3000
DEBUG=true
SECRET_KEY=your-secret-key-change-in-production
ALLOWED_HOSTS=localhost,127.0.0.1

DB_ENGINE=postgres
DB_USER=runique_user
DB_PASSWORD=secure_password
DB_HOST=localhost
DB_PORT=5432
DB_NAME=runique
DATABASE_URL=postgres://runique_user:secure_password@localhost:5432/runique

4. Verify the Connection

psql -U runique_user -d runique -h localhost

After applying migrations, create the first admin account:

runique create-superuser

The CLI guides through an interactive wizard: hash algorithm, username, email, password, then a confirmation step before creation.