Qafiyah | قافية

Open-source Arabic poetry DB and website with 944K+ verses by 932 poets from 10 eras. Built with Nextjs, Hono, and Supabase.

📑 Table of Contents

• 📋 Project Overview
• 🏗️ Architecture
• 💻 Tech Stack
• 📊 Data Statistics
• 🗄️ Data Schema
• 🚀 Development Setup
• 📚 Further Reading
• 🤝 Contributing
• 📄 License

📋 Project Overview

• Website: qafiyah.com
• API: api.qafiyah.com
• Twitter: x.com/qafiyahdotcom
• Database: latest_database_dumps

🔔 Note: You don’t need to scrape the site or API — our database dumps are open and regularly updated.

🏗️ Architecture

• Web: Nextjs app running on Cloudflare Pages (Edge)
• API: Hono-based Cloudflare Worker
• Bot: Twitter bot posting poems every 30 minutes
• Packages: Shared Zod schemas, ESLint configs, and TypeScript configs

💻 Tech Stack

Component	Technologies
Frontend	Nextjs, React Query, Tailwind CSS, Zustand
Backend	Hono, Cloudflare Workers,
Database	Supabase PostgreSQL with Drizzle ORM

📊 Data Statistics

• 📝 Total Verses: 944,844
• 📚 Total Poems: 85,342
• 🧑‍🎤 Unique Poets: 932
• 🕰️ Historical Eras: 10
• 🪶 Distinct Meters: 44
• 🎭 Rhyme Schemes: 47
• 🎨 Themes Covered: 27
• 🧾 Poem Types: 1

For latest data, use our DB dumps (updated with every change) instead of scraping.

🗄️ Data Schema

📚 poems

Column	Type	Nullable	Description
id	integer	NO	Primary key
title	text	NO	Poem title
meter_id	integer	NO	FK to meters(id)
theme_id	integer	NO	FK to themes(id)
poet_id	integer	NO	FK to poets(id)
slug	uuid	NO	Unique URL identifier
content	text	NO	Full poem content
rhyme_id	integer	YES	FK to rhymes(id)

🧑‍🎤 poets

Column	Type	Nullable	Description
id	integer	NO	Primary key
name	text	NO	Poet's name
slug	text	NO	URL identifier
era_id	integer	NO	FK to eras(id)
bio	text	YES	Biography (optional)

🕰️ eras

Column	Type	Nullable	Description
id	integer	NO	Primary key
name	text	NO	Era name
slug	text	NO	URL identifier

🪶 meters

Column	Type	Nullable	Description
id	integer	NO	Primary key
name	text	NO	Meter name
slug	text	NO	URL identifier

🎭 rhymes

Column	Type	Nullable	Description
id	integer	NO	Primary key
pattern	text	NO	Rhyme pattern
slug	uuid	NO	URL identifier

🎨 themes

Column	Type	Nullable	Description
id	integer	NO	Primary key
name	text	NO	Theme name
slug	uuid	NO	URL identifier

🚀 Development Setup

# 1. Create environment variables file for Cloudflare Worker
touch ./apps/api/.dev.vars

# 2. Set up your database connections
Add DATABASE_URL and SEARCH_DATABASE_URL to your .dev.vars file

# 3. Import database dump
Download and restore from https://github.com/alwalxed/qafiyah/tree/main/.db_dumps

# 4. Install dependencies
pnpm install

# 5. Start development server
pnpm dev

📚 Further Reading

Learn more about the search implementation in SEARCH.md.

🤝 Contributing

Contributions are welcomed via PRs. Feel free to help improve the project.

📄 License

This project is open source under the MIT License.