Building an Open Source Workspace with Next.js 16 and PostgreSQL: Meet Folio

Pratik Prasad — Wed, 04 Nov 2026 15:44:47 +0000

Every workday used to start the exact same way for me: opening four different browser tabs.
A kanban board for active sprint tasks.
An over-engineered Notion workspace for long-term project notes.
Google Calendar to figure out meeting slots and real working hours.
An AI chat window to help brainstorm or organize ideas.
Instead of actually working, I spent the first 30 minutes of my day doing meta-work—syncing notes between tools, updating statuses in multiple places, and suffering from constant context-switching fatigue.
Most modern productivity tools fall into one of two extremes:
• Enterprise monoliths (Jira, ClickUp): Slow, cluttered with hundreds of configuration menus, and built for management rather than personal flow.
• Blank-canvas wikis (Notion): Flexible, but require endless template tweaking and lack focused, high-speed execution interfaces.
I wanted something clean, opinionated, fast, and most importantly, 100% open source and privacy-conscious.
So I built Folio.
What is Folio?
Folio is a unified personal management studio designed around one philosophy: "One home for your everyday. Less switching, more doing."
Instead of isolating your workflow into silos, Folio brings your core daily operations into a single cohesive interface:
• Projects & Milestones: Track real execution roadmaps and deliverables without enterprise complexity.
• Dynamic Task Views: Seamlessly toggle between visual workflow boards and high-density, keyboard-friendly task lists.
• Native Google Calendar Integration: Your real-world schedule sits right alongside your to-dos, so you never overcommit your time.
• Idea Incubator: A scratchpad to capture fleeting ideas with a one-click action to promote them into active, roadmapped projects.
• Folio AI: An ambient, context-aware assistant to break down broad initiatives into concrete, actionable tasks.
The Tech Stack
I chose a modern, performance-first stack to keep the platform fast, responsive, and easy for other developers to self-host:
• Framework: Next.js 16 (App Router + Turbopack)
• Language: TypeScript (strict type checking across client & server)
• Styling: Tailwind CSS & Lucide Icons (clean, dark-mode-first aesthetic)
• Database & ORM: PostgreSQL & Drizzle ORM
• Deployment: Netlify
Why Drizzle ORM over Prisma?
When building a high-speed workspace, database latency matters. Drizzle gives two distinct benefits:
Lightweight serverless performance: Drizzle has negligible cold-start overhead compared to heavier query engines.
Schema transparency: Everything is typed directly in TypeScript schema definitions, making database migrations predictable and painless.
An Interesting Engineering Challenge: Edge vs. Node Runtimes
One of the biggest hurdles during development involved Next.js Edge Middleware vs. Database Drivers.
In Next.js, proxy or middleware routes often execute on Edge runtimes. If your authentication logic in middleware accidentally imports database models that rely on standard Node.js TCP drivers (like the "pg" library), the Edge bundler will crash because native Node socket bindings cannot run in lightweight Edge environments.
The solution was strict architectural separation:
• Middleware (proxy.ts): Only handles lightweight, zero-dependency cookie inspection and routing redirects.
• Server Components & API Routes: Handle session verification and full database queries within the standard Node.js runtime.
Keeping the Edge layers completely decoupled from the database layer dramatically improved routing speeds and deploy reliability.
Why Make It Open Source?
Productivity software holds your most sensitive data: personal schedules, proprietary ideas, upcoming project deadlines, and daily habits.
Walled-garden platforms can change their pricing, monetize your data, or shut down tomorrow. By making Folio 100% open source under the MIT License, anyone can:
• Inspect the database queries and authentication flow.
• Self-host an instance on their own infrastructure.
• Build custom integrations tailored to their exact workflow.
Try It Out & Contribute
Folio is live, free to use, and completely open source.
• Live Web App: https://folio-management-studio.netlify.app
• GitHub Repository: https://github.com/PratikPrasad1813/FOLIO
If you're an open-source contributor or developer looking to get involved:
• Drop a star on GitHub if you like the project!
• Feel free to submit an issue, propose new integrations (e.g., GitHub Issues sync, Notion import, Outlook Calendar), or open a PR.
I would love to hear your feedback: What is the biggest friction point in your current daily productivity stack? Let's discuss in the comments below!

DEV Community: Pratik Prasad

Building an Open Source Workspace with Next.js 16 and PostgreSQL: Meet Folio