Active Development · Phase EPersonal Engineering Project · 2026 – Present

CONVERA: Evidence-Driven Project Validation System

A validation engine that helps student developers and researchers turn unstructured notes, interview quotes, and academic literature into structured, decision-ready software proposals before writing code.

View Repository·Next.js 15.2 · FastAPI · Python 3.12 · SQLite WAL
CONVERA Brandmark and Typography System Identity
Official CONVERA brandmark and research typography lockup.
RoleSolo Developer
TimelineSep 2026 – Present (274 commits)
Storage & Schema38 SQLite WAL Tables
Test Suite338 Tests (100% Pass)

01The Problem: Jumping to Code Before Proving the Need

In university computing classes and student startup hackathons, teams come up with ideas quickly. They collect notes, chat messages, links to papers, and interview quotes across scattered group chats and shared documents.

Moving from that initial excitement to a solidly justified software proposal is usually where projects struggle:

  • Arguing Without Real Evidence: Teams debate feature lists based on personal opinions rather than verified interviews or actual gaps in existing literature.
  • Writing Code Too Early: Students frequently spend weeks building a full-stack web app before confirming whether anyone actually needs it, or whether an open-source solution already handles the use case.
  • Unverified AI Answers: Relying on standard chatbots to summarize research papers often leads to fabricated citations and unverified claims being accepted as facts.

02Dual Validation Workflows

CONVERA structures project evaluation into two distinct pathways depending on whether the team is building a startup product or an academic research thesis:

CONVERA System Architecture & Methodology Engine

Interactive visualization of CONVERA's dual validation tracks and “LLM Last” intelligence doctrine.

Stage 3

Research Gap Analysis

Gate 2: Scholarly Gap
Core Focus:

Isolates open technical limitations in state-of-the-art literature to prevent duplicate research.

Key Deliverable:Isolated research gap statement backed by contrastive literature table.
Primary Tables:
gap_analysessota_benchmarks
38 SQLite Tables (WAL)·338 Offline Passing Tests
FastAPI 0.115 · Next.js 15.2 · Python 3.12

The Research Track follows the Design Science Research (DSR) framework (March & Smith, 1995), categorizing technical contributions into Constructs, Models, Methods, and Instantiations, while aligning proposals with CHED computing guidelines.

03Decoupled Architecture with 38 Relational Tables

Evaluating long requirement documents, running literature searches, and checking rubric rules are computationally heavy tasks that should not freeze the user interface.

Next.js 15.2 UI

React 19 App Router client with a step-by-step pipeline view, keyboard command palette (Ctrl+K), and responsive forms for recording interview notes and paper citations.

FastAPI Engine

Python 3.12 backend running evaluation scoring, schema validation, and live query connectors to academic databases (OpenAlex, Crossref, Europe PMC).

38 SQLite WAL Tables

Relational schema in Write-Ahead Logging mode with full-text search (FTS5 BM25) for indexed papers, state checkpoints, and export audit logs.

04Interactive Evidence Graph & Requirements Lineage

To prevent features from being added on a whim, CONVERA connects every proposed requirement back through an evidence graph:

KNOWLEDGE TRACEABILITY CHAIN:
  1. Published Literature & Field Interviews (DOIs, User Quotes)
     └── 2. Specific Problem Claims (Friction, Frequency, Cost)
           └── 3. Testable Assumptions & Validation Checks
                 └── 4. Technical Specifications & Software Requirements
                       └── 5. Final Proposal Canvas

The web interface includes an interactive SVG graph with layered columns, smooth curved connectors, pan/zoom navigation, and clear edge indicators showing whether evidence supports, refutes, or extends an assumption.

05Connecting to Researcher Tools: Notion, Zotero, and GitHub

Research outputs are only useful if they can easily flow into the tools teams already use:

Notion Integration

Exports validated proposal summaries and literature tables into Notion workspace databases, and imports unstructured field notes into the problem bank.

Zotero Citation Bundles

Exports papers collected during validation into standard BibTeX and CSL-JSON formats for reference management in Overleaf or LaTeX.

GitHub Issue Exports

Turns validated software requirements directly into structured GitHub Issue templates and milestone roadmaps for development.

To keep the codebase maintainable and avoid bloated dependencies, these integrations were built directly with Python's standard httpx library rather than bundling heavy third-party vendor SDKs. Every sync action records a SHA-256 payload hash in SQLite (ecosystem_sync_records) so exports remain verifiable.

06Deterministic Scoring & Keeping Humans in Control

CONVERA deliberately avoids asking an AI chatbot to decide whether an idea is good. Instead, it uses clear math for ranking:

DETERMINISTIC CANDIDATE SCORING:

Score = 0.40 * Rubric + 0.35 * Evidence + 0.25 * Impact - Assumptions_Risk

Ties broken strictly: Total Score → Evidence Depth → Sized Impact → Unique ID

Key engineering decisions enforced in the code:

  • Zero AI Approval Weight: AI suggestions are strictly advisory. In code, AI confidence ratings carry zero weight in gate passage. Only human developers and mentors can mark a validation phase as passed.
  • Protected Ranking Invariant: A post-processing check ensures that narrative summaries generated by language models can never change the mathematically calculated rankings.
  • Offline Fallbacks: If external AI APIs time out or hit rate limits, the system provides offline mock responses flagged with is_evidentiary = False, ensuring test data never pollutes actual research findings.

07Working Code Today vs. Future Roadmap

To maintain honesty about project scope, here is what is fully functional in the repository today versus what is planned:

Working in Codebase Today (338 Tests Passing)
  • • Next.js 15.2 + FastAPI decoupled architecture
  • • 38 SQLite WAL tables with FTS5 search
  • • Dual-track dynamic pipeline stepper (7 & 8 phases)
  • • OpenAlex, Crossref & Europe PMC academic search adapters
  • • Interactive evidence graph with contradiction detection
  • • Session checkpointing and resume with state hashing
  • • Notion, Zotero & GitHub export integrations
  • • IEEE 830 requirement and proposal document generators
Future Ideas & Planned Improvements
  • • Local vector embeddings for semantic document search (pending demonstrated scale need)
  • • Specialized two-stage search reranking
  • • Columnar analytical database (DuckDB) for multi-project trend summaries
  • • Real-time collaborative multi-user editing

08Engineering Takeaways

Building CONVERA taught me three practical lessons about designing data-heavy validation software:

  • Rules in Code, Not in Prompts: Enforcing validation steps through relational database states and explicit transition logic proved far more reliable and reproducible than trying to instruct an LLM with long system prompts.
  • SQLite for Fast Local Development: Using SQLite WAL with 38 normalized tables gave instant test spin-up times (338 tests run in seconds), zero server configuration, and clean test isolation.
  • Resisting Dependency Bloat: Solving problems with simple deterministic math, database queries, and existing standard libraries before reaching for heavy AI frameworks kept the codebase fast, testable, and easy to maintain.