Hi, I'm Niko, an SEO and SEA specialist. I've been running Kommune3, a web agency in Dortmund, since 2007, and right now I'm building Traffalyzer. Here I write down what I learn along the way: Supabase, Drupal and SEO, and now and then how I sort out work and life.
Four of my own LinkedIn posts, every metric disclosed. The one with the biggest reach in my LinkedIn history is, per impression, the weakest I have ever measured. 261,935…
3 AM. Laptop open, app number 17 installing. Next to me "Getting Things Done", and "Atomic Habits" covered in Post-its. I have told that story before, in My 17-App Odyssey. What I…
Prompt trackers tell you whether ChatGPT or Claude recommends your brand. Most of them query the API to find out. Your customers type their question into chatgpt.com or claude.ai…
Since September, rank trackers have been getting some results pages from Google that look normal and are still wrong. Nozzle calls them poisoned SERPs and analyzed 27.5 million…
Lily Ray expects the next big Google update to hit mass-produced AI content and fake authors. Her evidence sits in Google's own documentation, which has changed noticeably over…
Google is switching off reviews for businesses because real guests got too enthusiastic too fast. To the algorithm, the QR code on the counter looks like bought stars. I've…
Disney+ shows up on Google with a URL that ends in utm_source=chatgpt.com. The first reflex says: botched canonical. I think something else happened. I google “Disney+ Login”…
I run a horde of AI agents and I no longer see the details. A CEO doesn't see them either. So why does it still feel wrong to me? I haven't written a line of code in months. I've…
I haven’t written a line of code in months, and I’m still a software developer every day. A report from a wall of pebbled concrete on developer life with AI agents: fatigue…
Drupal SEO: ten modules compared, what core already does, meta descriptions, common pitfalls, E-E-A-T, AI search and a checklist with admin paths. As of November 2026. Most “best…
Vibe coding in a working developer’s day: I have not written a line of code myself in months. Instead I keep AI coding agents running, with loops, a phone hotspot, and a laptop in…
Your grid bot compiled, authenticated, and then failed on the first order? This troubleshooting guide maps the most common crypto trading bot errors — Binance API codes, order…
Grid trading is a strong first strategy, but profitable bots often combine or switch between approaches. This guide covers three proven alternatives — DCA, mean reversion, and…
Your RLS policies look fine – yet the Supabase client throws: permission denied for table projects ERROR: 42501 Or PostgREST shows 42501 / “permission denied”. This is not the…
Your query looks correct – yet the Supabase JS client throws: JSON object requested, multiple (or no) rows returned code: PGRST116 This almost always comes from .single() (or…
Your upload code looks correct, the user is signed in – yet Supabase Storage responds with: StorageApiError: new row violates row-level security policy statusCode: 403 You often…
Your Edge Function works locally – but from the browser or via fetch you only get: {"code":401,"message":"Invalid JWT"} Or: Missing authorization header. This guide walks through…
Your login form looks fine, email and password seem correct – yet Supabase Auth responds with: AuthApiError: Invalid login credentials Or in the Network tab: 400 with…
You wrote an RLS policy that checks another table – and suddenly Supabase throws: ERROR: infinite recursion detected in policy for relation "profiles" In this article I'll show…
Immediate relief, no waiting: You can put these 10 actions into practice today — no appointment, no prior knowledge. Start with what fits into the next 5 minutes and work through…
When I published my first technical blog post a few years ago, I thought nobody would read it. Today, my blog generates over 79,000 impressions per month, ranks at position 6 for…
A single blog article on my private tech blog has achieved over 79,000 impressions in Google Search Console and ranks at an average Position 6 - without a single purchased…
Alex Hormozi generated over $100 million in revenue in less than 10 years - and the secret lies in his systematic approach to lead generation. In this comprehensive guide, I'll…
Want to build a professional crypto trading bot that not only trades but also stores and analyzes all data systematically? The combination of Binance API and Supabase as a backend…
Build comprehensive risk management and logging systems for cryptocurrency trading bots. This final guide in our series covers advanced risk controls, audit trails, compliance…
Implement a professional paper trading system that validates your cryptocurrency trading strategies with real market data without financial risk. This comprehensive guide covers…
Build a professional backtesting framework to validate your cryptocurrency trading strategies with historical data. This comprehensive guide covers data acquisition, performance…
Learn how to implement a profitable grid trading strategy for cryptocurrency trading bots. This comprehensive guide covers the mathematical foundation, a concrete profit…
Learn how to securely configure and authenticate with the Binance API for cryptocurrency trading bots. This comprehensive guide covers API key generation, security best practices…
Learn how to set up a professional Python development environment specifically optimized for cryptocurrency trading bot development. This step-by-step guide covers everything from…