7H3XXX/sika-backend

The African Job Board's backend # African Job Board API African Job Board is a comprehensive platform designed to connect African job seekers with cross-border employment opportunities, enabling companies across the continent and beyond to discover, recruit, and collaborate with top talent. The platform streamlines the job search and hiring process, supports diverse industries, and fosters economic growth by bridging the gap between skilled professionals and organizations in need of their expertise. In addition to its robust feature set, African Job Board is built using a modern technology stack. The backend leverages NestJS, a progressive Node.js framework known for its scalability and maintainability. PostgreSQL serves as the primary database, providing reliable and efficient data storage. Database interactions are managed using Drizzle, a type-safe ORM that simplifies querying and schema management, ensuring seamless integration between the application and the database. ## Database Setup and Migrations This project uses Drizzle Kit for managing database migrations with PostgreSQL. To streamline local development, the project includes a `docker-compose.yaml` file that provisions a PostgreSQL database container. ### Prerequisites - **Docker Desktop:** Install Docker Desktop for your operating system. - Download Docker Desktop - Docker Desktop Installation Guide - **Node.js and pnpm:** Ensure you have Node.js and pnpm installed. ### Environment Configuration 1. **Environment Variables:** The project contains a `.env.example` file listing all required environment variables, including database connection settings. - Copy `.env.example` to `.env`: ```bash cp .env.example .env ``` - Edit `.env` as needed to match your local or remote database configuration. 2. **Docker Compose Configuration:** The `docker-compose.yaml` file uses variables from your `.env` file (see the `# DATABASE Configs` section) to configure the PostgreSQL container. ### Starting the Database From the project root dir …