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.
Research Gap Analysis
Isolates open technical limitations in state-of-the-art literature to prevent duplicate research.
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.
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.
Python 3.12 backend running evaluation scoring, schema validation, and live query connectors to academic databases (OpenAlex, Crossref, Europe PMC).
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 CanvasThe 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:
Exports validated proposal summaries and literature tables into Notion workspace databases, and imports unstructured field notes into the problem bank.
Exports papers collected during validation into standard BibTeX and CSL-JSON formats for reference management in Overleaf or LaTeX.
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:
- • 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
- • 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.
