Back to Projects
Project CategoryMobile
Project Showcase
Fatawa (Android)
Android Q&A app powered by SQLite with 11,000+ entries and advanced search/bookmark features.
Java
Android Development
SQLite
Android SDK
+1 more
Project Overview
Fatawa is a Question/Answer mobile application built for Android. It leverages a local SQLite database with more than 11,000 records to provide instant search and offline access.
Development Process
Challenges
Managing and optimizing a large SQLite dataset for fast searching while keeping the app responsive on mid-range devices.
Solutions
Implemented efficient indexing for search queries, designed a clean activity-based navigation flow, and added bookmarking for user convenience.
Results & Impact
Delivered a feature-rich offline Android app that supports advanced search, bookmarking, font customization, and sharing of Q&A content.
Project Gallery
Tech Stack
Java
Android Development
SQLite
Android SDK
XML (UI design)
Key Features
- SQLite database with 11,000+ records
- Full-text search in questions and answers
- Bookmark questions & answers for later reading
- Open answers in separate activity view
- Adjust font size, copy to clipboard, and share Q&A
- Option to add new answers if not found
