Uses DuckDB Node - NOT WASM because of speed and server-side separation.
Why I think it's the perfect project for this stack, and what I found interesting about these technologies: 1. Tanstack Start provides really easy separation of the server, made it easier to use the node version. I often found issues that the DuckDB node APIs were ending up in the client bundle, but tanstack start just removed those concerns with one line 2. Convex: Realtime, Notifications, Live-updates, and refetches were very simple to implement + has components like Agent, Presence, R2, that came in handy. Firebase CANNOT do something like updating charts or tables live-time, but Convex really shines in these environments 3. Cloudflare: R2 goes super well with Convex and makes it very simple to access files / db stores 4. Firecrawl: Awesome for data verification and creating insightful tables
Non-technical teams spend hours on repetitive data work: uploading spreadsheets, writing queries, waiting for results, losing track of how insights were discovered. Traditional tools (Julius AI, ChatGPT) work but aren't built for real-time collaboration or repr...