Maniphest T1847

Set up PostgreSQL database
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	ieli
	May 2 2023, 08:33

Tags

Referenced Files

None

Subscribers

Chenani-MohamedAmine

Description

PostgreSQL 16 configured in docker-compose.yml with persistent volume. Connection via POSTGRES_CONNECTION_STRING env var. Database pool in backend/config/db.js. Schema in database/init.sql (6 tables: service, incident, incident_update, incident_service, maintenance, maintenance_service, subscriber, metric).

Commit: 759d175 (Phase 1), bd4a46b (Phase 2 expansion)

Revisions and Commits

rSP ServPulse
	D3182	rSP7ecfd3cfa5a9 Remove unwanted files
	D3182	rSP92b5588340e3 Correct markdown syntax
	D3182	rSP2b0989489d62 Remove unwanted comments
	D3182	rSP82443759b2fc Update license to BSD-2
	D3182	rSP9f1887646923 Add code conventions
	D3182	rSP6fc8014af426 Update main file header
	D3182	rSP398a92cd7f95 Implement basic MVC architecture
	D3182	rSP6d6a4c084148 Add DB run command & link to DB diagram
	D3182	rSP051db3fca8b7 Add test data population queries
	D3182	rSP41e9d42057c8 Implement basic MVC architecture
	D3182	rSPfee8475026e2 Add SQL file for table creation
	D3182	rSPb6bcb614b8ab Create .env.dist to provide an env file template

Related Objects

Mentioned Here: rSP759d1756c5c5: Phase 1: Repository cleanup, Docker Compose setup, and environment config
rSPbd4a46beabca: Phase 2: Backend refactor with full CRUD API, expanded schema, and JWT auth

Event Timeline

ieli created this task.May 2 2023, 08:33

Herald added a subscriber: dereckson. · View Herald TranscriptMay 2 2023, 08:33

ieli triaged this task as High priority.May 2 2023, 08:59

ieli added a revision: D3182: Implement basic MVC architecture.Jun 6 2023, 05:53

ieli added a commit: rSPb6bcb614b8ab: Create .env.dist to provide an env file template.Jun 14 2023, 06:03

ieli added a commit: rSP41e9d42057c8: Implement basic MVC architecture.

ieli added a commit: rSPfee8475026e2: Add SQL file for table creation.

ieli added a commit: rSP051db3fca8b7: Add test data population queries.

ieli added a commit: rSP6d6a4c084148: Add DB run command & link to DB diagram.

ieli added a commit: rSP398a92cd7f95: Implement basic MVC architecture.

ieli added a commit: rSP6fc8014af426: Update main file header.

ieli added a commit: rSP9f1887646923: Add code conventions.

ieli added a commit: rSP82443759b2fc: Update license to BSD-2.

ieli added a commit: rSP92b5588340e3: Correct markdown syntax.

ieli added a commit: rSP2b0989489d62: Remove unwanted comments.

ieli added a commit: rSP7ecfd3cfa5a9: Remove unwanted files.

dereckson moved this task from Backlog to Queries on the DBA board.Oct 12 2025, 10:39

ieli closed this task as Resolved.Mon, Feb 16, 14:27

ieli claimed this task.

ieli updated the task description. (Show Details)

ieli added a subscriber: Chenani-MohamedAmine.