BuildCanada / BuildCanada/CanadaSpends

Create a schema for public accounts data that is transferable across jurisdictions.

Open
#101 0 comments 0 reactions 0 assignees View on GitHub
enhancement Platform Public Accounts
Dominant language
TypeScript
Stars
84
Forks
35
Avg merge
5h 30m
Merged PRs (30d)
4

Description

Currently for the federal government, data was manually added to individual webpages.

We need there to be a common schema that we can map public accounts data to.

The data schema needs to support:
- Public accounts data
- Ministry data (what ministries/departments exist - as broken down by the government)
- Minsters over time

We also need to pick a datastore (I'd recommend postgres) and a job runner (maybe https://bullmq.io/ or pg-boss, pg-boss would require less infrastructure)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by turning the listed requirements into a schema for public accounts data, ministries and departments, and ministers over time. Then compare PostgreSQL with the proposed job runners BullMQ and pg-boss, documenting the selected datastore, runner, and transfer format as the definition of done.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, typescript
Domain
backend, data-engineering, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.