Skip to main content

3 posts tagged with "schema-design"

View All Tags

Building a Tag-Driven Metadata System for Political Domain Classification

· 2 min read
JavaScript Dev

Overview

As my civic-tech platform evolved, the complexity of classification increased: I needed to track ministry types, cabinet roles, party types (left, regional, royalist), election kinds, and more. Rather than hardcoding categories, I built a tag-driven metadata system.

This post explains the design and use cases for tag-based classification across multiple resources.


Building a Fully Multilingual Platform (English + Nepali)

· 3 min read
JavaScript Dev

Overview

Supporting multiple languages isn’t just about translating strings—it’s about designing your entire platform to speak more than one language from day one. For a civic-tech system targeting Nepali audiences as well as English-speaking researchers and diaspora users, bilingual support was non-negotiable.

In this article, I’ll explain how I implemented multilingual support across:

  • Database models and schema
  • API structure
  • React frontend rendering
  • SEO and routing strategy
  • Dynamic content like polls, charts, and tooltips

The Challenge: Making Multilingual the Default

How I Structured My Database for Real-World Relationships

· 3 min read
samundrak
JavaScript Dev

Overview

Designing a database schema that reflects real-world complexity is one of the most important architectural decisions in any data platform. In this post, I share how I modeled complex relationships using Prisma ORM with a focus on extensibility, multilingual support, and practical backend integration.

The system supports elections, leaders, parties, governments, scandals, polls, and more—each with overlapping relationships, dynamic behavior, and historical timelines.