Meri Panchayat: Public Issue Reporting Portal

A localized civic grievance reporting portal engineered to bridge the divide between citizens and panchayat administrators, featuring passwordless Email OTP verification, granular role-based access control, and a custom Kannada translation engine.

Open Live Portal north_east GitHub Repository code

— ARCHITECTURE MVC via Python / Flask

— SECURITY Email OTP & RBAC

— LOCALIZATION English & Kannada (i18n)

— DATA STORE SQLite / Relational Schema

— PORTAL INTERFACE Live E-Gov Portal

Meri Panchayat civic issue reporting portal interface

Citizen grievance intake, ticket lifecycle & panchayat triage Visit north_east

— PROBLEM & SOLUTION

warning The Challenge

In regional communities, citizens encounter friction reporting urgent municipal breakdowns. Physical registers lose complaints, lack accountability, and existing platforms mandate complex passwords while isolating Kannada-speaking citizens.

verified Technical Resolution

Passwordless 6-digit Email OTP workflow with rate limiting eliminates credential fatigue for rural users, while a custom JSON-backed i18n engine enables instantaneous client/server English & Kannada language switching.

— SYSTEM ARCHITECTURE

Flask Application Factory

Modular blueprint routing separating citizen submission, public tracking, and administrative resolution pipelines.

Granular RBAC

Secure session validation enforcing role-isolated permissions across citizens, field supervisors, and panchayat administrators.

Thread-Safe SQLite

Context-managed database connections with transactional integrity preventing race conditions during concurrent reports.

— KEY CAPABILITIES

track_changes

Complaint Lifecycle Tracking

Unique tracking IDs with real-time status transitions: Submitted → In Review → Work Dispatched → Resolved.

admin_panel_settings

Role-Based Access Control

Strict session isolation separating citizen grievance submission views from administrative triage dashboards.

query_stats

Administrative Analytics

Built-in aggregation metrics tracking resolution velocity, category-wise breakdown, and open municipal backlog.

— TECHNOLOGIES EMPLOYED

Python Flask SQLite Email OTP SMTP RBAC HTML5 / CSS3 Tailwind CSS Kannada i18n

End-to-end regression verified with simulated grievance sweeps and automated payload sanitization tests.

— ENGINEERING CHALLENGES & RESOLUTIONS

security Challenge: Session Security & Rural Accessibility

Rural users frequently abandon complex multi-character password setups, leaving accounts vulnerable or unused.

Resolution: Built a lightweight, passwordless 6-digit OTP verification mechanism over SMTP with 5-minute expiries and brute-force attempt limits.

translate Challenge: Multi-Language Usability Without Overhead

Translating dynamic database content and static template strings without bloated external runtime dependencies.

Resolution: Engineered an efficient dictionary-based Kannada localization layer in pure Python and JavaScript, toggling UI strings with zero page reload latency.

arrow_back Previous: AgroChain grid_view Back to All Projects Next Case Study: Smart Recipe Generator arrow_forward