Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database Schema Migration #783

Open
3 of 4 tasks
zainfathoni opened this issue Aug 30, 2021 · 0 comments
Open
3 of 4 tasks

Database Schema Migration #783

zainfathoni opened this issue Aug 30, 2021 · 0 comments
Assignees
Labels
enhancement New feature or request epic A master issue thread which contains other smaller issues hacktoberfest Issues for Hacktoberfest high-priority Issue with high priority refactor Refactoring existing feature ux User Experience

Comments

@zainfathoni
Copy link
Member

zainfathoni commented Aug 30, 2021

Overview

Problem Statement

The current workflow of our database management system is too complicated and has a significant bottleneck in the manual update process. This situation hinders us from scaling up our database updater volunteers.

Screenshot 2021-08-30 at 22 02 13

Solution

Therefore, we came up with a more scalable database management system.

Screenshot 2021-08-30 at 22 03 10

Implications to the Website

  1. The main Google Sheets file needs to be moved into another file
  2. There are additional columns to operate with
  3. Tanggal Verifikasi is not to be shown on the website anymore. Only the Terakhir Update field is shown.
  4. Tanggal Verfikasi only impacts the ✅ checkmark status on the website.

More Context

Three weeks ago, we initiated a discussion on this Slack thread where we defined the problem statements and the potential solutions here: Penyesuaian Workflow dan Database Relawan.

Screenshot 2021-08-30 at 21 51 15

Two weeks ago, the new database schema was ready to implement, but I couldn't afford to spend enough focus on this issue because we had to focus on kawalcovid19/silacak#8 for a few weeks.

Screenshot 2021-08-30 at 21 52 30

Since we have deprioritised kawalcovid19/silacak#8 for now, we can resume our focus on this issue.

Current Tasks

These are the tasks we need to do to migrate the content gracefully. Please always refer to these documents to understand the expected result of the new database schema:

  1. Struktur Informasi Baru Database WBW.
  2. [Database Utama] WargaBantuWarga
@zainfathoni zainfathoni added enhancement New feature or request epic A master issue thread which contains other smaller issues ux User Experience refactor Refactoring existing feature high-priority Issue with high priority labels Aug 30, 2021
@zainfathoni zainfathoni added this to the Further Optimizations milestone Aug 30, 2021
@zainfathoni zainfathoni self-assigned this Aug 30, 2021
@resir014 resir014 pinned this issue Aug 31, 2021
@zainfathoni zainfathoni added the hacktoberfest Issues for Hacktoberfest label Oct 13, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request epic A master issue thread which contains other smaller issues hacktoberfest Issues for Hacktoberfest high-priority Issue with high priority refactor Refactoring existing feature ux User Experience
Projects
None yet
Development

No branches or pull requests

1 participant