<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Yao Long</title>
    <description>The latest articles on DEV Community by Yao Long (@yaolongkeji).</description>
    <link>https://dev.to/yaolongkeji</link>
    <image>
      <url>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%2F4097570%2Fe1fdc4d5-8e9b-4c4e-9e65-bd89dc008576.png</url>
      <title>DEV Community: Yao Long</title>
      <link>https://dev.to/yaolongkeji</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/yaolongkeji"/>
    <language>en</language>
    <item>
      <title>I Built a Developer's Second Brain in Notion — Free Template (5 Databases)</title>
      <dc:creator>Yao Long</dc:creator>
      <pubDate>Thu, 27 Aug 2026 18:46:58 +0000</pubDate>
      <link>https://dev.to/yaolongkeji/i-built-a-developers-second-brain-in-notion-free-template-5-databases-1gnb</link>
      <guid>https://dev.to/yaolongkeji/i-built-a-developers-second-brain-in-notion-free-template-5-databases-1gnb</guid>
      <description>&lt;p&gt;As developers, we consume an overwhelming amount of information every day — tutorials, docs, Stack Overflow answers, YouTube videos, code snippets, Reddit threads... But where does all that knowledge go?&lt;/p&gt;

&lt;p&gt;Most of it disappears. We read it, maybe bookmark it, and then forget where we put it.&lt;/p&gt;

&lt;p&gt;I built &lt;strong&gt;Dev Knowledge Hub&lt;/strong&gt; — a complete developer's second brain in Notion. It's a free template with 5 interconnected databases designed specifically for developers.&lt;/p&gt;

&lt;h2&gt;
  
  
  What's Inside (Free Version — 5 Databases)
&lt;/h2&gt;

&lt;h3&gt;
  
  
  1. Knowledge Base — Your core knowledge management system
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;Track topics by category (Frontend, Backend, DevOps, Database, AI, Mobile)&lt;/li&gt;
&lt;li&gt;Tag with language/tool (JavaScript, Python, Rust, React, Docker, K8s...)&lt;/li&gt;
&lt;li&gt;Track mastery level: Learning → Reviewing → Mastered&lt;/li&gt;
&lt;li&gt;Link reference URLs and related code snippets&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  2. Code Snippets — Stop searching for that snippet you saw 3 months ago
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;Organize by language and category (Algorithm, Utility, Component, Hook, API, Pattern)&lt;/li&gt;
&lt;li&gt;Store code with descriptions and source links&lt;/li&gt;
&lt;li&gt;Mark favorites for quick access&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  3. Resources — Curate your learning material
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;Track articles, videos, courses, books, podcasts, tools&lt;/li&gt;
&lt;li&gt;Rate with 1-5 stars&lt;/li&gt;
&lt;li&gt;Track reading status: To-Read → Reading → Read → Archived&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  4. Bookmarks — Tame your chaotic bookmark bar
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;Categorize: Documentation, Tutorial, Tool, Inspiration, Reference, Repository&lt;/li&gt;
&lt;li&gt;Add descriptions so you remember WHY you bookmarked it&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  5. Quick Notes — Capture ideas before they're gone
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;Categories: Idea, Question, Bug, Tip, Reminder, Misc&lt;/li&gt;
&lt;li&gt;Track status: Active → Resolved → Archived&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  All 5 Databases Are Interconnected
&lt;/h2&gt;

&lt;p&gt;Knowledge Base links to Code Snippets. Resources link to Knowledge Base. Everything is cross-referenced so you can navigate your entire knowledge graph seamlessly.&lt;/p&gt;

&lt;h2&gt;
  
  
  How to Use It
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Click the link below to open the template&lt;/li&gt;
&lt;li&gt;Click "Duplicate" in the top right corner&lt;/li&gt;
&lt;li&gt;Start adding your knowledge!&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;strong&gt;Free Template Link:&lt;/strong&gt; &lt;a href="https://app.notion.com/p/Dev-Knowledge-Hub-3c93b3af224f809e9555c17d8c7a2c4c?source=copy_link" rel="noopener noreferrer"&gt;Dev Knowledge Hub — Free&lt;/a&gt;&lt;/p&gt;




&lt;h2&gt;
  
  
  Want More? Meet the Pro Version
&lt;/h2&gt;

&lt;p&gt;The free version covers the essentials. But if you're serious about leveling up your developer workflow, the &lt;strong&gt;Pro version&lt;/strong&gt; adds 5 more databases for a complete developer productivity system:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Learning Path&lt;/strong&gt; — Track your learning journeys (e.g., "React Mastery") with start/target dates, progress tracking, and auto-calculated days elapsed/remaining&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Projects&lt;/strong&gt; — Manage side projects and work projects with tech stack tags, priority levels, and linked tasks&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Tasks&lt;/strong&gt; — Break down projects into actionable tasks with priority, estimated time, and type tags&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Interview Prep&lt;/strong&gt; — Prepare for technical interviews with categories (Algorithm, System Design, Behavioral...), difficulty levels, and mastery tracking&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Daily Log&lt;/strong&gt; — Reflect on your daily progress: what you did, what you learned, challenges, blockers, mood tracking, and plans for tomorrow&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;All Pro databases are interconnected with the free databases — Knowledge Base links to Interview Prep and Learning Path. Projects link to Tasks and Daily Log. It's a complete second brain.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Pro Version ($29):&lt;/strong&gt; &lt;a href="https://www.creem.io/payment/prod_66bn10vAPT2hnWj7YR01oP" rel="noopener noreferrer"&gt;Dev Knowledge Hub — Pro&lt;/a&gt;&lt;/p&gt;




&lt;p&gt;I built this because I was tired of losing knowledge across dozens of browser tabs, scattered notes apps, and forgotten bookmarks. If it helps you too, I'd love to hear about it!&lt;/p&gt;

&lt;p&gt;Drop a comment if you have any questions or suggestions for improvements. 🚀&lt;/p&gt;

</description>
      <category>webdev</category>
      <category>beginners</category>
      <category>productivity</category>
      <category>showdev</category>
    </item>
    <item>
      <title>I built a complete freelance business dashboard in Notion — 7 interconnected databases with rollups and formulas</title>
      <dc:creator>Yao Long</dc:creator>
      <pubDate>Thu, 27 Aug 2026 13:45:25 +0000</pubDate>
      <link>https://dev.to/yaolongkeji/i-built-a-complete-freelance-business-dashboard-in-notion-7-interconnected-databases-with-rollups-27e5</link>
      <guid>https://dev.to/yaolongkeji/i-built-a-complete-freelance-business-dashboard-in-notion-7-interconnected-databases-with-rollups-27e5</guid>
      <description>&lt;p&gt;As a solo developer doing freelance work on the side, I was constantly juggling tools: clients in a spreadsheet, projects in Trello, time tracking in a separate app, invoices in Word docs, and goals... somewhere in my head.&lt;/p&gt;

&lt;p&gt;So I built everything into a single Notion workspace. Not just standalone databases — I wanted them to actually &lt;strong&gt;talk to each other&lt;/strong&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  What I built: Freelance OS
&lt;/h2&gt;

&lt;p&gt;7 interconnected databases, each with relation, rollup, and formula properties:&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;1. Clients&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Track status (Lead / Active / Completed / Archived), type, source&lt;/li&gt;
&lt;li&gt;Total Revenue auto-calculated via rollup from Projects → Budget&lt;/li&gt;
&lt;li&gt;Reverse relations from Projects and Finance&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;2. Projects&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Linked to Clients (bidirectional relation)&lt;/li&gt;
&lt;li&gt;Priority, status, budget, estimated hours, progress&lt;/li&gt;
&lt;li&gt;Actual Hours auto-calculated via rollup from Time Entries → Duration&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;3. Finance&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Income and expenses linked to specific projects AND clients&lt;/li&gt;
&lt;li&gt;Type (Income/Expense), category, currency, payment method, status&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;4. Time Entries&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Linked to Projects (bidirectional)&lt;/li&gt;
&lt;li&gt;Billable checkbox toggle&lt;/li&gt;
&lt;li&gt;Auto-calculates amount: &lt;code&gt;if(prop("Billable"), prop("Duration (hrs)") * prop("Rate"), 0)&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;Rolls up into project's Actual Hours&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;5. Invoices&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Issue date, due date, payment status, paid date&lt;/li&gt;
&lt;li&gt;Linked to both Clients and Projects&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;6. Goals&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Quarterly targets with deadline and status&lt;/li&gt;
&lt;li&gt;Progress auto-calculated: &lt;code&gt;round(prop("Current") / prop("Target") * 100) / 100&lt;/code&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;7. Tasks&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Linked to Projects (bidirectional)&lt;/li&gt;
&lt;li&gt;Client auto-pulled via rollup from Project → Client&lt;/li&gt;
&lt;li&gt;Priority, tags, due date, estimated time&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  The relation map
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Clients ←──→ Projects ←──→ Tasks
   ↑              ↑
   │              ↓
   │         Time Entries
   ↓              ↓
Finance ←──→ Invoices
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Every entry you make ripples across the workspace. Log a time entry → the project's actual hours update → the client page shows the updated project. Record a payment → it's linked to both the project and the client. Add a task → the client name auto-fills from the project relation.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why Notion instead of separate SaaS tools?
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;No monthly subscriptions&lt;/strong&gt; — Notion is free for personal use&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;100% customizable&lt;/strong&gt; — every property, view, and formula is yours to change&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Single source of truth&lt;/strong&gt; — no more copy-pasting between 5 apps&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Your data stays yours&lt;/strong&gt; — export anytime&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Who it's for
&lt;/h2&gt;

&lt;p&gt;Freelancers, solo founders, consultants, designers, developers, writers — anyone running a one-person business who wants to stop juggling tools.&lt;/p&gt;

&lt;h2&gt;
  
  
  Pricing
&lt;/h2&gt;

&lt;p&gt;$49 one-time. Not a subscription. You duplicate it into your own Notion workspace and it's yours forever.&lt;/p&gt;

&lt;p&gt;After purchase, you'll receive a private link to duplicate the entire template.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Preview the template here:&lt;/strong&gt; &lt;a href="https://app.notion.com/p/Freelance-OS-The-Complete-Solo-Business-Dashboard-3c93b3af224f80f6a593de20161be8b4" rel="noopener noreferrer"&gt;https://app.notion.com/p/Freelance-OS-The-Complete-Solo-Business-Dashboard-3c93b3af224f80f6a593de20161be8b4&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Get it here:&lt;/strong&gt; &lt;a href="https://www.creem.io/payment/prod_6rmvfybzKiSLHRk3Yq2GZL" rel="noopener noreferrer"&gt;https://www.creem.io/payment/prod_6rmvfybzKiSLHRk3Yq2GZL&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Happy to answer any questions about the setup, formulas, or how I structured the relations!&lt;/p&gt;

</description>
      <category>showdev</category>
      <category>productivity</category>
      <category>beginners</category>
      <category>freelance</category>
    </item>
  </channel>
</rss>
