mattermost-community/focalboard

Update the dockerfile to deploy Postgres instead of SQLite

Open

#1,958 opened on Dec 9, 2021

View on GitHub
 (0 comments) (0 reactions) (0 assignees)TypeScript (2,542 forks)user submission
EnhancementHelp WantedUp for grabs

Repository metrics

Stars
 (26,187 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

Summary

As the server gets more sophisticated, we recommend / require multi-user environments to use Postgres instead of SQLite. E.g. there are bugs like https://github.com/mattermost/focalboard/issues/1841 which are caused by concurrency issues on SQLite.

As a result, we should default Personal Server installations to Postgres instead of SQLite.

Contributor guide

Research direction
Examine the current Dockerfile and docker compose configuration for the Personal Server. Identify the steps needed to replace SQLite with PostgreSQL, including environment variables, initialization scripts, and any code changes required for database migration.
Tech stack
typescript
Domain
backenddevops
Issue type
Refactor
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
DockerPostgreSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50