The latest articles on DEV Community by Omer faruk Isil (@bywyd). https://dev.to/bywyd https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3862202%2Fd34e07b3-04ee-4eba-92cd-268a4e82dc09.jpg https://dev.to/bywyd en Omer faruk Isil Mon, 06 Apr 2026 13:23:26 +0000 https://dev.to/bywyd/i-built-an-intelligence-database-because-resident-evil-made-me-obsessed-with-classified-files-as-a-112c https://dev.to/bywyd/i-built-an-intelligence-database-because-resident-evil-made-me-obsessed-with-classified-files-as-a-112c <p>When Resident Evil Requiem came out I found myself thinking less about the gameplay and more about a specific detail, the intelligence databases, the dossiers, the classified file aesthetic. That fixation has been with me since childhood. I wanted that to exist as a real tool.</p> <p>So instead of waiting for it, I built it.</p> <h2> What it is </h2> <p>ARCHIVES is a lore database app with a classified intelligence terminal aesthetic. It's not a freeform wiki. Every entity has a type, typed relationships, and a rich set of structured records, infection histories, mutation stages, consciousness transfer logs, intelligence assessments, affiliation histories, death and revival records.</p> <p>The frontend is a Multiple Document Interface workbench. Dossiers, relationship graphs, interactive maps, and search results all open as draggable resizable windows inside a single workspace. No page navigation. Everything coexists.</p> <h2> Some things I found genuinely interesting to build </h2> <h3> The MDI window system </h3> <p>Most SPAs route between pages. I wanted everything open simultaneously like an actual workstation. Each window has position, size, z-index, minimized and maximized state, all managed with Zustand. Clicking an entity link inside a dossier opens that entity in a new window rather than navigating away. React 19 with the Babel Compiler plugin for automatic memoization helped significantly with re-render performance once you have several windows open at once.</p> <h3> The natural language search parser </h3> <p>Beyond keyword search, I built a query parser that tokenizes intent and maps action words to specific relation types and record tables. Searching "who infected" hits infection records. "Who killed" hits death records filtered by killer entity. "Allies of" resolves to affiliation and relation type slugs. There are 50+ mapped action verbs supplemented at runtime by whatever relation types exist in the database. Results include a ranked entity list, a connection subgraph, and a generated intelligence briefing.</p> <p><a href="https://github.com/bywyd/archives" rel="noopener noreferrer">Github Repo</a><br> <a href="https://archives.fenasal.com/archives/resident-evil" rel="noopener noreferrer">Live Demo</a></p> laravel react opensource webdev