Hardware Specification
Summary
Development environment: Windows 11, Apache 2.4, NVM, and PHP 8.2 Staging and production environments hosted externally (Cloudways and Digital Ocean) All PostgreSQL databases are hosted externally at Digital Ocean
Environments
Development
The Development environment is a split architecture with a local environment using Apache (localhost) connected to remote databases hosted on Digital Ocean specifically for the development environment. Hosting: Local Database Hosting: Digital Ocean
Staging
Web Hosting: Cloudways Database Hosting: Digital Ocean
Production
Hosting: Digital Ocean Database Hosting: Digital Ocean
Databases
Database | Cluster | Description | Environment |
|---|---|---|---|
portal_core_db_dev | db-project-portal-dev-cluster | Primary Database for development version of the project portal for use in Staging (staging.eprusa.io) | Staging |
portal_spatial_dev_db | db-project-portal-dev-cluster | Spatial database for development version of the project portal | Development and Staging |
portal_core_db_dev_local | db-project-portal-dev-cluster | Primary Database for development version of the project portal for use in Local Staging (localhost:5001) | Development |
Clusters
Production Cluster
Parameter | Value |
|---|---|
Cluster | db-project-portal-cluster |
Host | db-project-portal-cluster-do-user-15737090-0.c.db.ondigitalocean.com |
Username | doadmin |
Password | |
Port | 25060 |
Database (Default) | defaultdb |
Vendor | PostgreSQL 16.x |
Development Cluster
Parameter | Value |
|---|---|
Cluster | db-project-portal-dev-cluster |
Host | db-project-portal-dev-cluster-do-user-15737090-0.b.db.ondigitalocean.com |
Username | doadmin |
Password | |
Port | 25060 |
Database (Default) | defaultdb |
Vendor | PostgreSQL 16.x |
Testing
For testing purposes, feature and unit tests in the local development environment are run against a SQLite database cloned from the production schema. See the .env.testing configuration file.