The latest articles on DEV Community by Pranav Gupta (@pranav1044). https://dev.to/pranav1044 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4074080%2Fe1158238-14a7-457a-b255-bcabc39e9d62.jpg https://dev.to/pranav1044 en Pranav Gupta Wed, 12 Aug 2026 17:02:28 +0000 https://dev.to/pranav1044/building-a-police-link-analysis-tool-in-4-weeks-hackathon-time-1hk https://dev.to/pranav1044/building-a-police-link-analysis-tool-in-4-weeks-hackathon-time-1hk <p>Hey Dev community! </p> <p>I’m jumping into a hackathon sprint with a 4-week deadline (final submission: Sept 8).</p> <p>Here's the problem I'm tackling: When police try to connect the dots between suspects, bank statements, and burner phone logs, they're usually stuck manually digging through messy, disconnected spreadsheets.</p> <p>I’m building an end-to-end tool to solve this—turning siloed data into an interactive visual web that automatically finds hidden links between entities.</p> <p>Keeping the stack simple so I don't get stuck in setup hell: Python, SQLite, NetworkX, Streamlit, Pyvis, and Gemini API.</p> <p>The Plan <br> I'll be posting raw weekly progress, UI snapshots, and the inevitable debugging headaches here.</p> <p>No fluff—just pure building in public. Let's see if I can pull this off before Sept 8!</p> <p>Drop a comment if you've built anything with NetworkX or Pyvis before—would love any tips! </p> python hackathon buildinpublic ai