Skip to main content

2 posts tagged with "civic-tech"

View All Tags

Implementing Full-Text Search for Bilingual Political Data

· 2 min read
JavaScript Dev

Overview

Search is a critical part of political platforms—especially when users are trying to find leaders, elections, or scandals across decades of data. I implemented a full-text search engine that:

  • Supports both English and Nepali
  • Works across multiple models
  • Handles fuzzy and partial input

This article details how I designed and deployed this system using PostgreSQL, Prisma, and language-aware search logic.

Attaching Polls to Any Resource: A Flexible, Polymorphic System

· 2 min read
JavaScript Dev

Overview

Civic platforms are incomplete without community voice. I designed a system to attach polls to any resource—leaders, parties, elections, or governments—and record structured public responses.

This post covers how I built a polymorphic poll engine that is:

  • Type-safe
  • Localized
  • Flexible in format (radio/checkbox)
  • Easily integrated across the frontend

Schema Structure