Lisan Roots

The problem

Each classical source uses a different data shape and root-indexing convention. A dictionary app is only as good as its underlying schema — get that wrong and you either lose fidelity to each source or make search unusable.

The approach

Designed a unified SQLite schema with FTS5 full-text search that can represent all three sources — plus KhorsiCorpus and 10dict — without collapsing what makes each one distinct, then built the React Native UI on top of that schema.

Highlights

• Unified SQLite schema reconciling five distinct classical and corpus data sources
• FTS5 full-text search across root-based Arabic entries
• Data sourcing and normalization pass across Lane's, Al-Qamus, and Arramooz
• Native UI designed for root-based browsing, not just keyword search

Stack

Outcome

Architecture and schema design complete; UI implementation in progress.