ClickHouse UDFs for comparison operators, criteria tables as tuple arrays, queries with arrayAll and JSONExtractString, and a materialized view for segment membership (educational CDP-style example).
Read full article →First steps with ClickHouse OLAP-Docker Compose demo, JSON type config, ReplacingMergeTree, multi-tenant entities table, inserts, queries, and FINAL for deduplication.
Read full article →NotebookLM, AI-generated audio from the zettelkasten post and Jon Radoff’s piece on the “Direct from Imagination” era.
Read full article →Capture row-level changes from PostgreSQL and stream them to Kafka using Debezium and Kafka Connect-Docker setup, connectors, and REPLICA IDENTITY for updates.
Read full article →Repository with links on zettelkasten and note-taking — articles, books, videos, and the guide on GitHub.
Read full article →Analog or digital, tooling, customization cost, and why prioritizing knowledge development on paper can help.
Read full article →Luhmann, practices, and contrast with “second brain.”
Read full article →Exploratory, evolutionary, and productive — Antinet mindsets, focus, errata, and how Luhmann actually wrote.
Read full article →Phases of knowledge development — selection, extraction, creation, and installation per Scott P. Scheper.
Read full article →And when not to use it — why zettelkasten helps you produce content, the tree analogy, and serendipity.
Read full article →Analog-style, Antinet-inspired — note-taking method and initial zettelkasten structure with index cards.
Read full article →