DATABASES Signal 142
Treat markdown files with frontmatter as queryable database records
↗
Illustration only Photo by Taylor Vick on Unsplash
Developers can query collections of markdown files as if they were database tables while keeping the files editable in any editor and under version control.
The pattern gives you the freedom of plain text with structured metadata, enabling filtering and sorting without locking into a proprietary CMS. It works well for up to roughly ten thousand files, beyond which a traditional database is needed. Adoption cost is low, just a tool to index frontmatter into SQLite or use existing apps like Obsidian.
Written by elseif from the cluster below · every claim links back to a sourceThe three things worth knowing
Each markdown file becomes a record, its frontmatter fields become columns, and directories act as tables.
The pattern provides queryability (filter, sort, aggregate) while preserving plain-text portability, version control, and editor freedom.
It is suited for up to roughly ten thousand files; larger collections need a conventional database.
THE CLUSTER