BACK TO PROJECTS
KMSearchSQLiteObsidianFTS LIVE

SECONDBRAIN

Personal knowledge management system — Obsidian vault synced to SQLite with FTS5 full-text search, BM25 ranking, and BM25-style relevance scoring. 1,877 notes searchable in milliseconds.

BUILT WITH Node.jsSQLiteFTS5BM25ObsidianBash

WHAT IT DOES

KEY FEATURES

Incremental sync

SHA256-based change detection, only processes modified files

Full-text search

FTS5 with BM25 ranking across all 1,877 notes

Frontmatter parsing

Extracts tags, dates, aliases, and custom fields

Wiki-link graph

Tracks [[links]] and #tags across the vault

Context tree

Structured knowledge tree for AI context injection

Domain folders

5 pillars: AI & Tools, Personal & Goals, Technology, Art & Creative, Operations

CASE STUDY

ABOUT THE PROJECT

Dual-system personal knowledge base combining Obsidian's markdown-first editing with SQLite's search speed.

Tech stack: Node.js scripts (sync.mjs, query.mjs), SQLite FTS5, Obsidian vault. No Electron, no DuckDB — lightweight and fast.

This is the memory system behind this conversation — all knowledge is instantly queryable.

PROJECT DETAILS

Status LIVE
Category KM, Search, SQLite, Obsidian, FTS
Stack 6 technologies

ARCHITECTURE HIGHLIGHT

Offline-first with RxDB — works without internet, syncs via Server-Sent Events when back online.

BY THE NUMBERS

  • 117 Svelte components
  • 5 role-based dashboards
  • Multi-location support
  • PWA — iOS & Android

PREVIEW

SCREENSHOTS

POS Transaction Screen

screenshot coming soon

Owner KPI Dashboard

screenshot coming soon

Kitchen Display System

screenshot coming soon

Floor Plan Editor

screenshot coming soon

LET'S WORK TOGETHER

HAVE A PROJECT IN MIND?

Looking to build something real — from prototype to production.

GET IN TOUCH →