August 2025 was the heaviest month of shipping on Democracy.cc. 480+ changes deployed across every layer of the platform. Here's what moved the needle most.

30+ Tag Agenda Tagging System

Every agenda item can now be tagged with categories like "zoning," "budget," "infrastructure," or "public safety." I built a hierarchical tag system with 30+ tags covering the full range of city business. Users can filter agendas by tag to find issues they care about.

Voting Results Integration

Commission meeting outcomes now appear directly on agenda items. The system parses voting patterns from meeting records and displays who voted for what -- including who made the motion, who seconded, and the final tally. Commissioners get individual vote tracking across all meetings.

Blog Reading Analytics

A lightweight analytics system tracks which articles residents read, how far they scroll, and which agenda items drive the most engagement. No third-party scripts -- just a small sendBeacon call on meaningful scroll positions. The data helps prioritize which meeting types and topics to cover more deeply.

Performance: 11x Faster Sitemaps

The sitemap generator was querying every agenda item individually. After switching to bulk queries with eager loading, generation dropped from 22 seconds to 2 seconds. For a site with 2,200+ agenda items across 76 meetings, the sitemap was becoming a bottleneck on deploy -- now it's negligible.

Attachment Recovery

The scraper discovered 5,200+ PDF attachments (staff reports, resolutions, memoranda) that had been missed in earlier scrapes due to inconsistent HTML formatting in PrimeGov's output. A targeted re-scrape with improved parsing recovered all of them.

August was about filling gaps -- making the platform more searchable, more measurable, and more complete.