How to Move Analytics from Your App Database to a Data Warehouse
Move analytics from PostgreSQL to a data warehouse with a hands-on ClickHouse plan: ELT vs ETL, CDC vs…
Blog
Tech Insights & Engineering Notes
AI systems, platform engineering and architecture. Lessons from 13+ years of building at scale.
-
-
Event-Driven Analytics Architecture Explained
Learn event-driven analytics: producers, a broker, consumers, schemas, delivery guarantees and replay, with a small runnable Node.js example…
-
AI Image Generation Models: How to Evaluate and Choose
Evaluate AI image models with a concrete rubric: adherence, edits, typography, licensing, ops. Then compare GPT Image, Gemini,…
-
.NET Versions Explained: LTS vs STS and Which to Choose
Confused by .NET LTS vs STS? See the release calendar, support windows, and a decision framework for picking…
-
How to Build an Analytics Dashboard with React
Build an analytics dashboard with React 19, Vite and Recharts: a data-fetching hook, date filters, and loading and…
-
Cookieless Analytics: How to Track Users Without Cookies
Cookieless analytics explained: compare daily rotating hashes, localStorage and server-side sessions, with runnable Node.js code and honest accuracy…
-
Automate an AI Workflow in n8n: Webhook to LLM to Slack
Wire LLMs into n8n workflows without hand-rolling glue. Covers triggers, model nodes, and where orchestration actually pays off.
-
Installing .NET SDK and Setting Up Your First Project
Learn how to install .NET SDK on Windows, macOS, or Linux, verify it with dotnet --info, then build…
-
Async Event Tracking: Collect Analytics Without Slowing Down Your App
Async event tracking keeps analytics off the critical path. Build client batching, retries, a server buffer, backpressure and…
-
PostgreSQL Schema Design for Analytics
PostgreSQL schema design for analytics: build the events table, JSONB properties, sessions, users and a daily rollup with…
-
How to Build Your Own Analytics API in Node.js
Build your own analytics API in Node.js: an Express collector with validation, CORS allow-list and rate limiting, plus…
-
How to Build a Custom Analytics Dashboard with HTML and JavaScript
Build a custom analytics dashboard with plain HTML, JavaScript and Chart.js: KPI cards, a trend chart and a…
-
SQL Queries for User Analytics (MySQL Examples)
Copy-paste SQL queries for user analytics in MySQL 8.4: DAU/MAU, sessions, funnels, retention cohorts and window functions, each…
-
How to Centralize Server Logs for a Web App
Learn how to centralize server logs for a web app and turn nginx and app logs into analytics…
