Release 2

Main Achievements

The second major release brings together a variety of frontend and backend improvements, focusing on enhancing data management, user experience, and system stability. Key highlights include:

• Refined Data Pipeline: Database operations were improved with PostgreSQL persistence, pgSTAC integration, and automated data fetching/saving.
• Enhanced Frontend Control: The loading bar was refactored, alongside new functionality to reset the map, update settings, and load dataset polygons.
• Better CI/CD & Maintenance: Continuous integration pipelines were refined to separate e2e tests, with multiple fixes for production environments and SonarQube coverage.
• Expanded API Endpoints: New endpoints to retrieve collections and reset them in the database support a more dynamic user experience.

What's Changed

• #0 - fix(backend): Updating nx files for backend by @im-samwong in #141
• #136 feat(Backend) - Fetch And Save to DB the Hirondelle's Endpoint Collections by @XavierGuertin in #142
• fix README.MD by @XavierGuertin in #143
• #136 - fix: Fixed SonarQube's coverage report by adding tests by @XavierGuertin in #144
• #111 - feat(PostgreSQL/GeoServer): Connect PostGIS with GeoServer by @PFratt in #140
• #145 - fix: [Bug] ERROR: duplicate key value violates unique constraint: "collections_id_key" by @XavierGuertin in #146
• #149 - feature: [Backend] Create Endpoint to Retrieve a List of Collections from the Database by @XavierGuertin in #150
• #102 - fix(frontend): Refactor loading bar by @justncheng in #148
• #84 - feature(frontend & backend): Add endpoint to reset collections and update frontend with reset button by @XavierGuertin in #156
• #151 - chore(readme): Added my information by @eo2000 in #152
• #0 - chore(ci): Separating e2e tests into a different pipeline by @im-samwong in #157
• #133 - feat(Fullstack): Created metadata endpoints and implemented them on the frontend by @LiamDaigle in #155
• #0 - chore(proj): Update README.md & Maintenance by @im-samwong in #159
• #120 - feat(frontend): Saving the settings by @eo2000 in #153
• #0 - fix(ci): Fixed connection between frontend and backend on prod by @im-samwong in #160
• #120 - fix(frontend): localStorage bug fix by @eo2000 in #162
• #135 - feat(frontend & backend): Map Reset by @PFratt in #161
• #147 - feat(frontend, backend, test) - Loading dataset polygon onto map by @lo-vil in #164

---

Velocity and Contractor Estimate

Velocity Calculation

• Closed Tasks with Story Points:

  • #0 (nx fix) → 1
  • #136 (fetch/save collections) → 3
  • #0 (README fix) → 0
  • #136 (SonarQube fix) → 0
  • #111 (Connect PostGIS/GeoServer) → 5
  • #145 (duplicate key bug) → 1
  • #149 (retrieve collections) → 3
  • #102 (loading bar refactor) → 3
  • #84 (reset collections) → 5
  • #151 (README update) → 0
  • #0 (e2e pipeline separation) → 1
  • #133 (metadata endpoints) → 5
  • #0 (general maintenance) → 1
  • #120 (saving settings) → 3
  • #0 (fix prod connection) → 3
  • #120 (localStorage bug) → 3
  • #135 (map reset) → 2
  • #147 (load dataset polygon) → 3

  Total Story Points:
  42

Contractor Estimate

• Estimated Hours:

  • 42 points × ~3 hours/point = 126 hours

• Estimated Cost:

  • 126 hours × 35.50 CAD/hour = 4,473.00 CAD
  • Contractor Estimate for Release 2: $4,473.00 CAD

---

Full Changelog: iteration7...release2