llms.txt
Compare with other sites' llms.txt files →# Simon Späti's Website (ssp.sh)
> This website consists of my top-ranked Data Engineering Blog at ssp.sh/blog/*, and a large Second Brain at ssp.sh/brain/* including 1000+ interlinked notes. A huge chunk of it is the Data Engineering Vault, with dedicated notes to data engineering, and there is an online book on Patterns of Data Engineering. My name is Simon Späti, a data engineer, author and educator.
The blog is connected with the second brain in an interactive graph. On each blog post, or second brain note, you'll see the relation to connected articles and vice versa, and the book chapters are interconnected the same way. Blog posts live at `/blog/<slug>`, brain notes at `/brain/<slug>`, book chapters on dedp.online.
Everything here is written manually by me. I don't use AI for writing, see the AI Usage page below for the full stance, and the Copyright Policy for how the content may be used.
## Main Sections
- [Data Engineering Blog](https://www.ssp.sh/posts): 100+ deep dives on the open-source data ecosystem, covering data modeling, ETL, orchestration, architecture, Python, DuckDB, Iceberg and lakehouse, plus writing, PKM and deep life topics
- [Second Brain](https://www.ssp.sh/brain): Public knowledge vault of 1000+ notes, modeled as a digital Zettelkasten and Digital Garden, crafted, curated, connected, compounded
- [Data Engineering Vault](https://www.ssp.sh/brain/data-engineering): 1000+ interconnected data engineering terms and concepts, a connected glossary you explore organically
- [Patterns of Data Engineering (book)](https://www.ssp.sh/book): Timeless practices from convergent evolution, written online as I go, free initial chapters at [dedp.online](https://www.dedp.online/)
- [Search](https://www.ssp.sh/search): One full-text search across blog, Second Brain and Data Engineering Vault (also `Ctrl+K` or `/` anywhere on the site)
- [Explore](https://www.ssp.sh/explore): Browse all articles by year, tag and category
## Second Brain, Maps of Content
- [Personal Knowledge Management](https://www.ssp.sh/brain/personal-knowledge-management-pkm): Second Brain, Obsidian, Zettelkasten, permanent notes, smart note-taking, PKM workflows
- [Deep Life](https://www.ssp.sh/brain/deep-life): Digital minimalism, deep work, stoicism, journaling, pathless path, dumb phone
- [Writing](https://www.ssp.sh/brain/writing) & [Reading](https://www.ssp.sh/brain/reading): Writing is thinking, creative writing, markdown, plaintext files, types of content online
- [Productivity](https://www.ssp.sh/brain/productivity): GTD, deep work, no meetings (async), focus, creativity vs productivity, ultradian rhythm
- [Neovim](https://www.ssp.sh/brain/neovim): Vim motions and language, Neovim setup, querying databases in Vim, dotfiles, TUIs, Unix philosophy
- [Digital Garden](https://www.ssp.sh/brain/digital-garden): Public second brains with Quartz, SSGs, open-source Obsidian Publish alternatives, future of blogging
- [Programming](https://www.ssp.sh/brain/programming): Python, Rust, SQL, functional data engineering, Docker, Kubernetes
## Featured Writing
- [Data Modeling, The Unsung Hero of Data Engineering](https://www.ssp.sh/blog/data-modeling-for-data-engineering-architecture-pattern-tools-future/): Architecture patterns, tools and the future of data modeling
- [Why Semantic Layers Matter, and How to Build One with DuckDB](https://www.ssp.sh/blog/semantic-layer-duckdb): Building a semantic layer on an open data stack
- [Data Modeling Guide for Real-Time Analytics with ClickHouse](https://www.ssp.sh/blog/practical-data-modeling-clickhouse): Practical modeling guide for real-time analytics
- [The Rise of the Declarative Data Stack](https://www.ssp.sh/blog/rise-of-declarative-data-stack/): Declarative approach to building data infrastructure
- [Vector Technologies for AI](https://www.ssp.sh/blog/vector-technologies-ai-data-stack/): Vector technologies used in the AI data stack
- [Why I Still Blog, and Why the Future of Blogging Is Connected](https://www.ssp.sh/blog/why-i-still-blog/): On interlinked blogging, second brains and long-term writing
- [My Obsidian Note-Taking Workflow](https://www.ssp.sh/blog/obsidian-note-taking-workflow): How the notes behind this site are made
- [Why Vim Is More than Just an Editor](https://www.ssp.sh/blog/why-using-neovim-data-engineer-and-writer-2023/): Vim language, motions and modes explained
- [Finding Flow](https://www.ssp.sh/blog/finding-flow): Escaping digital distractions through deep work and slow living
- [Hacker News Front Page Hits](https://www.ssp.sh/hackernews): Articles and notes that reached the HN front page
## Newsletter & Community
- [Newsletter](https://www.ssp.sh/brain/newsletter): Me writing to you about what's on my mind, mostly experiences from data engineering and technical writing, with behind-the-scenes of my Obsidian and Neovim workflow. Sent every now and then, no schedule
- [Subscribe](https://subscribe.ssp.sh): Signup page, or from the terminal via `curl sub.ssp.sh/your@email.com` (`curl sub.ssp.sh/why` explains why)
- [Graph Explorer](https://explore.ssp.sh): Semantic search and hidden connections across the Second Brain
- [Reddit Community](https://reddit.com/r/dataengineeringvault/): r/dataengineeringvault
- [Reddit Posts](https://www.ssp.sh/reddit): Top posts on r/dataengineering and related data communities
## About & Policies
- [About and Now](https://www.ssp.sh/about): Who I am, what I'm focused on at this point in my life, and the history of this website since 2004
- [AI Usage](https://www.ssp.sh/ai): How I use (and don't use) AI on this website, all writing is done manually
- [Copyright Policy](https://www.ssp.sh/copyright-policy): Terms for using content from ssp.sh and its subdomains
- [Impressum & Privacy](https://www.ssp.sh/impressum-privacy): Legal notice and privacy information
## Full Index
The lists above are curated. For every page, use the sitemaps and feeds:
- [Sitemap Index](https://www.ssp.sh/sitemap-index.xml): Points to both sitemaps below
- [Blog Sitemap](https://www.ssp.sh/sitemap.xml): All blog posts and pages
- [Second Brain Sitemap](https://www.ssp.sh/brain/sitemap.xml): All second brain notes, including the Data Engineering Vault
- [Blog RSS Feed](https://www.ssp.sh/index.xml): New articles
- [Second Brain RSS Feed](https://www.ssp.sh/brain/index.xml): Recently created and updated notes
Every blog post and second brain note is also published as raw Markdown. Append `index.md` to any page URL to get the source text without site navigation, for example:
- [https://www.ssp.sh/blog/finding-flow/index.md](https://www.ssp.sh/blog/finding-flow/index.md): Markdown version of a blog post
- [https://www.ssp.sh/brain/deep-life/index.md](https://www.ssp.sh/brain/deep-life/index.md): Markdown version of a second brain note
The Markdown is the original source, so second brain notes keep their `[[wikilinks]]` and callouts in Obsidian syntax.
## Optional
- [SSP Data GmbH, Services](https://www.ssp.sh/services): Technical writing for open-source data companies and book sponsorships
- [The Craft of Data Engineering Writing](https://www.ssp.sh/craft): Blending technical expertise with storytelling to create impactful, evergreen content
- [Show Your Workflow](https://www.ssp.sh/show-your-workflow): Interview essays on how writers write, their workflows, note-taking and storytelling, distilled through my lens
- [Book Recommendations and Notes](https://www.ssp.sh/books): Books I read and recommended over the years, collected from my newsletter and now pages, starting in 2018
- [Writer's Room](https://www.ssp.sh/writers-room): Behind the scenes of my creative process, including rough and unfinished ideas
- [Memories](https://www.ssp.sh/memories): Photography, places and moments, my personal Instagram and Flickr
- [Free Checklist: Increase Reach Through Writing](https://www.ssp.sh/increase-reach): Actionable tips to boost an open-source product's reach through content