Projects using SQLiteProjects using SQLiteAI-powered language flashcard app for iOS. Users describe any theme ("Coffee and tea", "Driving exam") and the app instantly generates a custom deck via Google Gemini. Features a progressive 3-level vocabulary system (beginner → intermediate → advanced) with mastery-based unlocking, SM-2/FSRS spaced repetition with Again/Hard/Good/Easy ratings, offline-first SQLite storage, bilingual audio examples, smart daily reminders, and a freemium model (RevenueCat) gating unlimited decks and advanced levels.
Built with React Native (Expo), TypeScript, SQLite, Supabase, Google Gemini, RevenueCat. Designed and built a Clause Bank Builder for a 22-staff Malaysian conveyancing law firm as the foundation of their legal document automation system.
The problem was not just generating documents. The firm needed a way to organise its legal knowledge first: approved wording, reusable clauses, transaction scenarios, placeholders, trigger rules, exclusions and version history.
The tool gives the team a simple Windows interface to add, edit, browse and review clauses without touching code. Each clause can be categorised, marked as active or draft, linked to usage conditions, and exported for backup. This creates a structured legal knowledge base that can feed future SPA generators, tenancy agreements, letter templates, matter workflows and Microsoft 365/SharePoint automation.
The aim was to keep the system practical for a real law office: offline, maintainable, plain-English, and easy for non-technical staff to understand.
