# NikoFischer.com

> Tutorials and notes by Nikolai Fischer: Supabase, Drupal, crypto trading bots, and practical personal development from a working developer-builder.

Practical, hands-on guides for developers and builders. Content is published primarily in English, with selected German translations under `/de/`. Prefer the English URLs below as canonical unless a German version is explicitly needed.

Complete index. Articles are grouped by their primary topic; the
most populated topics come first. German translations are listed
inline where they exist.

## 50 Days Challenge

- [Day 50: Increase Your Output and Create New Opportunities](https://nikofischer.com/Day-50-Increase-Your-Output-and-Create-New-Opportunities): Day 50 challenge wrap-up: increase your output and create new opportunities — leverage, shipping habits, and what should come after the 50 days. (DE: https://nikofischer.com/de/Tag-50-Erhoehe-deinen-Output-und-erschaffe%20neue-Moeglichkeiten)
- [Day 49: Start Fresh Every Day](https://nikofischer.com/Day-49-Start-Fresh-Every-Day): Day 49: Start fresh every day — drop yesterday’s baggage, reset focus, and begin again without dragging unfinished guilt into the new morning. (DE: https://nikofischer.com/de/Tag-49-Fange-jeden-Tag-neu-an)
- [Day 48: Creating vs. Consuming](https://nikofischer.com/Day-48-Creating-vs-Consuming): Day 48: Creating vs. consuming — kill pocket-reach scrolling, protect maker time, and put output before input in the last stretch of the challenge. (DE: https://nikofischer.com/de/Tag-48-Kreieren-vs-Konsumieren)
- [Day 47: The Importance of Written Goals](https://nikofischer.com/Day-47-The-Importance-of-Written-Goals): Day 47: The importance of written goals — change needs a concrete picture; write the future down or you keep wandering, dissatisfied, without a heading. (DE: https://nikofischer.com/de/Tag-47-Die-Wichtigkeit-eines-aufgeschriebenen-Ziels)
- [Day 46: Focus on implementation first, then the decision](https://nikofischer.com/Day-46-Focus-on-implementation-first-then-the-decision): Day 46: Focus on implementation first, then the decision — ship a running version instead of debating the perfect option through another long loop. (DE: https://nikofischer.com/de/Tag-46-Fokussiere-die-Umsetzung-erst-dann-die-Entscheidung)
- [Day 45: Planning and Execution](https://nikofischer.com/Day-45-Planning-and-Execution): Day 45: Planning and Execution — keep planning short, move into doing fast, and stop using more plans as an excuse to delay real, visible progress. (DE: https://nikofischer.com/de/Tag-45-Planung-und-Ausfuhrung)
- [Day 44: Do Your Work!](https://nikofischer.com/Day-44-Do-Your-Work): Day 44: Do your work — no extra books, coaches, or plans replace doing. Become a doer; progress only shows up when you actually tackle the task. (DE: https://nikofischer.com/de/Tag-44-Mache-deine-Arbeit)
- [Day 43: Finish the things you start](https://nikofischer.com/Day-43-Finish-the-things-you-start): Day 43: Finish the things you start — done work proves progress to yourself; open loops steal energy even when you already know what to do next.
- [Day 42: A book starts with the first word](https://nikofischer.com/Day-42-a-book-starts-with-the-first-word): Day 42: A book starts with the first word — stop optimizing the unwritten life; put the first ugly sentence down so the real work can finally begin.
- [Day 41: Radical Planning](https://nikofischer.com/Day-41-Radical-Planning): Day 41: Radical Planning for the 50-day challenge — cut fuzzy goals, define concrete next actions, and make the plan small enough to execute today.
- [Day 40: Performance](https://nikofischer.com/Day-40-Performance): Day 40: Performance — don't outsource thinking to ChatGPT; write to find the thought. Polished text is cheap; a clear idea still has to be earned.
- [Day 39: Defeating the Chaos](https://nikofischer.com/day-39-defeating-the-chaos): Day 39: Defeating the chaos — if the path feels comfortable, it is probably wrong; choose the harder honest route and unmask fake clarity fast.
- [Day 38: Self-Management](https://nikofischer.com/Day-38-Self-Management): Day 38: Self-management — success belongs to people who understand how they work; run the inner system, not only the projects on the outside.
- [Day 37: Don't Overpace](https://nikofischer.com/Day-37-Dont-Overpace): Day 37: Don't Overpace — why pushing too hard early kills long challenges, and how to keep a sustainable cadence through all fifty focused days.
- [Day 36: Success Requires Effort](https://nikofischer.com/Day-36-Success-Requires-Effort): Day 36: Success requires effort — skip the inflated routines and ego; regular work is what closes the gap between now and the vision you wrote down.
- [Day 35: Defy the Danger](https://nikofischer.com/Day-35-Defy-the-Danger): Day 35: Defy the danger — progress needs people who leave the harbor; take the uncomfortable step instead of waiting for a perfectly safe moment.
- [Day 34: Clarity Through Writing](https://nikofischer.com/Day-34-Clarity-Through-Writing): Day 34: Clarity through writing — daily writing beats another vision document; put the thought stream on paper until the next action becomes obvious.
- [Day 33: Create Your Own Luck](https://nikofischer.com/Day-33-Create-Your-Own-Luck): Day 33: Create your own luck — luck surface area is doing times telling: ship work and share it so opportunities have a place to actually land.
- [Day 32: Staying True to Your Path and Soaring](https://nikofischer.com/Day-32-Staying-True-to-Your-Path-and-Soaring): Day 32: Staying true to your path — resist shiny detours, keep willpower on the work you chose, and treat goals as stars that keep the heading honest.
- [Day 31: Regularly Reviewing your Vision](https://nikofischer.com/Day-31-Regularly-Reviewing-your-Vision): Day 31: Regularly reviewing your vision — write the one-year picture down and revisit it, because a plan that only lives in your head quietly fades.
- [Day 30: You're in Control](https://nikofischer.com/Day-30-Youre-in-Control): Day 30: You're in control — you can act in every situation, change direction, and drop the helpless story that circumstances are running the show.
- [Day 29: Conquering Procrastination](https://nikofischer.com/Day-29-Conquering-Procrastination): Day 29: Conquering procrastination — why delay feels good, how it is self-deception, and the control shift that gets you back to the actual task.
- [Day 28: More Effective Email Management](https://nikofischer.com/Day-28-More-Effective-Email-Management): Day 28: More effective email management — stop inbox-checking from killing deep work; batch mail so each glance does not reset your entire focus.
- [Day 27: Deep Work vs. Social Media – How Digital Distractions Fragment Your Flow](https://nikofischer.com/Day-27-How-Distractions-from-Social-Media-Fragment-Your-Flow): Deep work vs. social media: what a three-second glance really costs, why feeds are built to interrupt you, and seven ways to protect one focused block. (DE: https://nikofischer.com/de/Tag-27-Deep-Work-Social-Media-Ablenkung)
- [Day 26: Deriving Tasks from Plans](https://nikofischer.com/Day-26-Deriving-Tasks-from-Plans): Day 26: Deriving tasks from plans — turn a one-year vision into three concrete actions per area so the plan becomes work you can do this week.
- [Day 25: Making Plans](https://nikofischer.com/Day-25-Making-Plans): Day 25: Making Plans in the 50-day challenge — keep plans light, actionable, and honest so they support shipping instead of becoming busywork.
- [Day 24: The Power of Shifting Focus and Reframing - Steps to Change Your Life](https://nikofischer.com/Day-24-Shifting-Focus-and-Refraiming): Day 24: Shift focus and reframe — stop waiting for outside change; use perspective shifts today to reshape your life without a new set of circumstances.
- [Day 23: How to Get Back on Track in the Morning](https://nikofischer.com/Day-23-How-to-Get-Back-on-Track-in-the-Morning): Day 23: How to get back on track in the morning — a 50-day challenge note on resetting after a rough start instead of writing the whole day off.
- [Day 22: Transform Every Minute into Productivity](https://nikofischer.com/Day-22-Transform-Every-Minute-into-Productivity): Day 22: Transform every minute into productivity — ask whether this activity serves the outcome, even at rest, so passion and output stay aligned.
- [Day 21: Don't Complain](https://nikofischer.com/Day-21-Dont-Complain): Day 21: Don't complain — plant the tree now. Stop waiting, overthinking, and standing still; regret lives in the things you never actually started.
- [Day 20: Quality & Depth](https://nikofischer.com/Day-20-Quality-and-Depth): Day 20: Quality and depth — choose fewer things done with full dedication instead of rushing more work; depth beats quantity when you want real craft.
- [Day 19: Accountability - How to Attain and Practice It](https://nikofischer.com/Day-19-Accountability): Day 19: Accountability — how to take commitments seriously, follow through consistently, and use it as a key for goals and healthier relationships.
- [Day 18: Detailed Planning](https://nikofischer.com/Day-18-Detailed-Planning): Day 18: Detailed planning — when travel and kids wreck your usual setup, write clear task lists so a new environment does not kill your output.
- [Day 17: Focused Work](https://nikofischer.com/Day-17-Focused-Work): Day 17: Focused work (deep work) — drop pseudo-work that feels busy, protect distraction-free blocks, and spend the hours on work that creates value.
- [Day 16: About Goals](https://nikofischer.com/Day-16-About-Goals): Day 16: About goals — treat them as milestones on a longer path, celebrate briefly, then set the next one without making arrival the whole identity.
- [Day 15: Become your own brand](https://nikofischer.com/Day-15-Become-Your-Own-Brand): Day 15: Become your own brand — success rides on relationships; build a memorable network instead of treating talent and hours as the whole game.
- [Day 14: Rest time and what comes next](https://nikofischer.com/Day-14-Rest-time-and-what-comes-next): Day 14: Rest time and what comes next — after two weeks of the 50-day challenge, recover on purpose so discipline stays sustainable instead of brittle.
- [Day 13: Don't optimize what shouldn't exist](https://nikofischer.com/Day-13-Dont-optimize-what-shouldnt-exist): Day 13: Don't optimize what shouldn't exist — kill the unnecessary process first, then improve what remains, using a real booking-flow example.
- [Day 12: Creating More Value](https://nikofischer.com/Day-12-Creating-More-Value): Day 12: Creating more value — simplify clutter, keep a few strong structures, and build a foundation instead of collecting more unimportant things.
- [Day 11: Beliefs - How They Influence Our Thinking and Actions](https://nikofischer.com/Day-11-Beliefs): Day 11: Beliefs — how hidden core convictions steer thinking and action, and how to notice the ones that quietly block the work you want to do.
- [Day 10: Following Rules](https://nikofischer.com/Day-10-Following-Rules): Day 10: Following rules — treat personal commitments as a compass you can revise, so progress does not depend on mood or a perfect morning routine.
- [Day 9: Always Give Your Best](https://nikofischer.com/Day-9-Always-Give-Your-Best): Day 9: Always give your best — not by doing more, but by giving the current task full attention and using the time you actually have more effectively.
- [Day 8: Become more disciplined](https://nikofischer.com/Day-8-About-Discipline): Day 8: Become more disciplined — practical notes from the 50-day challenge on keeping promises to yourself when motivation is nowhere to be found.
- [Day 7: Get out of your fucking Comfort Zone](https://nikofischer.com/Day-7-Get-out-of-Comfort-Zone): Day 7: Get out of your comfort zone — a blunt 50-day challenge note on taking the uncomfortable action you’ve been postponing for far too long.
- [Day 6: Be ready to change everything at any time](https://nikofischer.com/Day-6-Be-ready-to-change-everything-at-any-time): Day 6: Be ready to change everything at any time — question plans daily and keep the courage to make radical course corrections when reality shifts.
- [Day 5: Radical Simplification](https://nikofischer.com/Day-5-Radical-Simplification): Day 5: Radical Simplification — cut tools, cut options, cut noise until only the work that matters remains clearly on your plate for the day.
- [Day 4: There are no lost days](https://nikofischer.com/Day-4-There-are-no-lost-days): Day 4: There are no lost days — disrupted routines are not a write-off. Restart the same afternoon instead of waiting for a perfect morning reset.
- [Day 3: Thinking and Execution Phases](https://nikofischer.com/Day-3-Thinking-and-Execution-Phases): Day 3: Thinking and Execution Phases — separate planning from doing so ideas stop blocking action during this focused 50-day life challenge.
- [Day 2: Back to Focus](https://nikofischer.com/day-2-back-to-focus): Day 2: Back to Focus in the 50-day challenge — cut distraction, return to one important task, and rebuild concentration after a noisy start.
- [Day 1: Getting Things Done](https://nikofischer.com/day-1-getting-things-done): Day 1 of the 50-day challenge: Getting Things Done — capture ambitious tasks, finish what you plan, and learn to judge each day more honestly.

## Supabase

- [Supabase Error: Fix "permission denied for table" (42501)](https://nikofischer.com/supabase-permission-denied-for-table-fix): Fix Supabase 42501 "permission denied for table": grant the API role first — this is not an RLS policy failure. (DE: https://nikofischer.com/de/supabase-permission-denied-for-table)
- [Supabase Error: Fix PGRST116 "JSON object requested, multiple (or no) rows returned"](https://nikofischer.com/supabase-pgrst116-multiple-or-no-rows-fix): Fix Supabase PGRST116: use maybeSingle() instead of single(), tighten filters, and check RLS SELECT. (DE: https://nikofischer.com/de/supabase-pgrst116-multiple-or-no-rows)
- [Supabase Error: Fix "infinite recursion detected in policy for relation"](https://nikofischer.com/supabase-infinite-recursion-detected-in-policy-fix): Fix Supabase RLS error infinite recursion detected in policy: use SECURITY DEFINER helpers or auth.uid()-only policies to stop the loop for good. (DE: https://nikofischer.com/de/supabase-infinite-recursion-detected-in-policy)
- [Supabase Auth: Fix "Invalid login credentials" Error](https://nikofischer.com/supabase-auth-invalid-login-credentials-fix): Fix Supabase Auth Invalid login credentials step by step: check the user row, email confirmation, auth providers, and that project API keys match. (DE: https://nikofischer.com/de/supabase-auth-invalid-login-credentials)
- [Supabase Edge Functions: Fix "Invalid JWT" / 401 Error](https://nikofischer.com/supabase-edge-functions-invalid-jwt-401-fix): Fix Supabase Edge Functions 401 Invalid JWT step by step: send a Bearer token, verify the user session, or disable verify_jwt when intentional. (DE: https://nikofischer.com/de/supabase-edge-functions-invalid-jwt-401)
- [Supabase Storage: Fix 403 "new row violates row-level security policy" on Upload](https://nikofischer.com/supabase-storage-403-rls-upload-fix): Fix Supabase Storage 403 RLS on upload: add the matching SELECT policy on storage.objects and align your upload path with what the policy expects. (DE: https://nikofischer.com/de/supabase-storage-403-rls-upload)
- [Building a ChatGPT Clone with Supabase Edge Functions and OpenAI](https://nikofischer.com/building-chatgpt-clone-supabase-edge-functions): Build a ChatGPT clone with Supabase Edge Functions and OpenAI: authentication, streaming responses, and a working React chat UI step by step.
- [Supabase Storage File Upload: Complete Secure Guide](https://nikofischer.com/supabase-storage-file-upload-guide): Implement secure Supabase Storage file uploads step by step: set up buckets, RLS policies, and client code without frustrating permission errors. (DE: https://nikofischer.com/de/supabase-storage-file-upload-implementieren)
- [Supabase Edge Functions CORS Error Fix - Complete Guide 2025](https://nikofischer.com/supabase-edge-functions-cors-error-fix): Fix Supabase Edge Functions CORS errors in 3 steps: set Access-Control headers, handle OPTIONS preflight, and call functions from the browser. (DE: https://nikofischer.com/de/supabase-edge-functions-cors-fehler-beheben)
- [Supabase vs. Firebase - Unveiling the Differences](https://nikofischer.com/supabase-vs-firebase): Supabase vs Firebase compared side by side: auth, database, pricing, and when Postgres-backed Supabase beats Google’s BaaS for your next app.
- [new row violates row-level security policy – Fix](https://nikofischer.com/supabase-error-row-level-security-policy): Fix Supabase 'new row violates row-level security policy' — INSERT also needs SELECT. Add a SELECT RLS policy, or use returning: 'minimal' on insert.
- [Supabase: How to query users table?](https://nikofischer.com/supabase-how-to-query-users-table): Query the Supabase auth.users table by email in 3 steps: create a secure RPC function, grant execute, and call it from your Node.js middleware.

## Drupal

- [Drupal ECA System: Simplifying Automation](https://nikofischer.com/Drupal-ECA-System-Simplifying-Automation): Drupal ECA system explained: automate workflows with Events, Conditions, and Actions — no deep custom code, similar power to Zapier inside Drupal. (DE: https://nikofischer.com/de/Drupal-ECA-System-Automatisierung-leicht-gemacht)
- [Introducing the User UUID Token Module for Drupal: Finally, a User UUID Token!](https://nikofischer.com/Introducing-the-User-UUID-Token-Module-for-Drupal): User UUID Token module for Drupal: finally expose user UUIDs as tokens for dynamic content, paths, and integrations without custom glue code.
- [The 5 Best Drupal Modules for Bloggers in 2024](https://nikofischer.com/The-5-Best-Drupal-Modules-for-Bloggers-in-2024): The 5 best Drupal modules for bloggers in 2024: Workspaces and other must-haves that change how you draft, review, and publish content. Start today. (DE: https://nikofischer.com/de/Die-5-besten-Drupal-Module-fur-Blogger-in-2024)
- [The Future of Drupal: A Comprehensive Analysis and Forecast](https://nikofischer.com/The-Future-of-Drupal-A-Comprehensive-Analysis-and-Forecast): The future of Drupal: analysis and forecast for the CMS — challenges, opportunities, and how it compares as the web platform landscape shifts. (DE: https://nikofischer.com/de/node/99)
- [How to Change the Title of a Drupal Form (Drupal 9 & 10)](https://nikofischer.com/Drupal-Change-Title-Of-Forms): Change a Drupal form title in Drupal 9 and 10: use hook_preprocess_page_title or form_alter to quickly rename registration and node-add forms.
- [Upgrading Drupal 9 to Drupal 10 Using Composer](https://nikofischer.com/upgrading-drupal-9-to-10): Upgrade Drupal 9 to Drupal 10 with Composer: stepwise commands, dependency fixes, and the common pitfalls that break most major-version moves.
- [CORS is not meant to secure an API endpoint](https://nikofischer.com/cors-does-not-secure-api-endpoints): CORS does not secure your API: why browser-side API keys are unsafe, and how to protect Drupal JSON:API endpoints with proper authentication. (DE: https://nikofischer.com/de/cors-sichert-keine-api-endpunkte)
- [Drupal 9.1 REST: Post and patch requests are rejected](https://nikofischer.com/drupal-rest-post-patch-methodnotallowedexception): Fix Drupal REST MethodNotAllowedException on POST/PATCH: why Error 500 appears and how to correct route methods plus your REST resource config. (DE: https://nikofischer.com/de/drupal-rest-post-patch-methodnotallowedexception)

## Productivity

- [Don't Think, Just Start](https://nikofischer.com/Dont-Think-Just-Start): Don't think, just start: how over-analyzing options keeps you stuck — pick a direction, take the first step, and let momentum decide the rest. (DE: https://nikofischer.com/de/Denke-nicht-und-starte-einfach)
- [My God, just get on with it - damn it!](https://nikofischer.com/My-God-just-get-on-with-it-damn-it): My God, just get on with it: why reading five productivity books can block real work — stop preparing forever and ship the first ugly version. (DE: https://nikofischer.com/de/Mein-Gott-leg-endlich-los-verdammt)
- [Things I’ve Learned as a Runner](https://nikofischer.com/Things-I-have-Learned-as-a-Runner): Things I’ve learned as a runner that apply to work and life: don’t outrun your pace, respect recovery, and build endurance one honest mile at a time. (DE: https://nikofischer.com/de/Dinge-die-ich-als-Laufer-gelernt-habe)
- [The Power of Completion: Surrounding Yourself with Accomplishments](https://nikofischer.com/power-of-completion): The power of completion: why surrounding yourself with finished work beats endless open loops — practical ways to finish more and feel progress.
- [Changing priorities](https://nikofischer.com/changing-priorities): Changing priorities without killing projects: how to tame indecision when today’s plan stops making sense tomorrow — stay moving, stay sane. (DE: https://nikofischer.com/de/wechselnde-prioritaeten)
- [Beware of pseudo-work](https://nikofischer.com/pseudo-work): Beware of pseudo-work: how busy activity fakes progress — and how to spot it, stop it, and replace it with work that actually moves the needle. (DE: https://nikofischer.com/de/pseudo-arbeit)
- [My 3 most important productivity rules](https://nikofischer.com/my-3-most-important-productivity-rules): My 3 most important productivity rules: protect deep work, enter flow fast, and cut the phone-and-browser noise that shreds every focused hour. (DE: https://nikofischer.com/de/meine-3-wichtigsten-produktivitaetsregeln)

## Pyngup

- [17 Apps, 23 Books and a Burnout Later: Why Discipline Is the Wrong Game](https://nikofischer.com/17-apps-23-books-burnout-why-discipline-is-broken): 17 apps, 23 books and a burnout later: why discipline is the wrong game — and what actually helps when productivity systems keep failing you. (DE: https://nikofischer.com/de/17-apps-23-buecher-burnout-warum-disziplin-schadet)
- [Day 4: Multi-Account Testing and the Reality of User Interactions](https://nikofischer.com/pyngup-day-4-multi-account-testing-und-contact-system): PYNGUP Day 4: multi-account testing and the reality of user interactions — what broke, what we learned, and how contact flows actually behave. (DE: https://nikofischer.com/de/pyngup-tag-4-multi-account-testing-und-contact-system)
- [Building PYNGUP Day 3: Landing Page is Live, Beta Process Starts](https://nikofischer.com/building-pyngup-day-3-landing-page-live): PYNGUP Day 3: landing page is live and beta starts — building in public after 17 apps: what shipped since the first post, and why pyngup.com is online now. (DE: https://nikofischer.com/de/entwicklung-pyngup-tag-3-landing-page-live)
- [My 17-App Odyssey: From Todoist to Notion (And Why They All Failed)](https://nikofischer.com/17-app-odyssey-todoist-to-notion): My 17-app productivity odyssey from Todoist to Notion: honest reviews, real costs, and why the system failed — not the individual productivity tools. (DE: https://nikofischer.com/de/17-app-odyssee-todoist-bis-notion)
- [Why I'm Building PYNGUP After 17 Failed Apps - My Rebellion Against the Productivity Industry](https://nikofischer.com/building-pyngup-after-17-failed-apps): Why I’m building PYNGUP after 17 failed apps: a public rebellion against productivity theater — honest day-one notes from a working entrepreneur. (DE: https://nikofischer.com/de/17-apps-spaeter-baue-ich-pyngup)

## Self management

- [Life as a Marathon: The Power of Perseverance](https://nikofischer.com/life-is-a-marathon): Life as a marathon: why perseverance beats sprint culture — practical mindset shifts for long-haul goals when quick wins finally stop working. (DE: https://nikofischer.com/de/Das-Leben-ist-ein-Marathon)
- [50 days to 40](https://nikofischer.com/50-days-to-40): 50 days to 40: the kickoff mindset for a focused life challenge — what I’m optimizing for and how I’ll measure real progress before the birthday.
- [5 Important Life Lessons](https://nikofischer.com/5-important-life-lessons): 5 important life lessons worth revisiting: short principles on focus, relationships, and work that stay useful when everything else gets noisy.
- [Maximizing Productivity: A Guide to Structuring Your Day More Efficiently](https://nikofischer.com/structuring-your-day-more-efficiently): Structure your day more efficiently: a practical guide to time blocks, priorities, and routines that turn a chaotic calendar into focused output.
- [Transforming Problems into Opportunities for Growth](https://nikofischer.com/problems): Transforming problems into opportunities for growth: a practical mindset shift that turns setbacks into training instead of permanent dead ends.

## Bitcoin

- [Crypto Trading Bot Backtesting Framework: Validate Strategies Before Risking Real Money](https://nikofischer.com/crypto-bot-backtesting-framework): Crypto trading bot backtesting framework: validate strategies on historical data before risking real money — Python setup, metrics, and pitfalls.
- [Grid Trading Strategy Implementation: Build Your First Profitable Crypto Bot](https://nikofischer.com/grid-trading-strategy-implementation): Implement a grid trading strategy in Python: the math, a clear profit example, order management, and code to automate Bitcoin grid trading bots.
- [Binance API Key Setup & Authentication Guide](https://nikofischer.com/binance-api-configuration-authentication): Binance API key setup step by step: create keys, set Spot permissions, whitelist IPs, configure .env, authenticate in Python, and test on testnet.
- [How to Build a Cryptocurrency Trading Bot: Complete Guide](https://nikofischer.com/program-a-crypto-trading-bot): Build a crypto trading bot from scratch: API setup, strategies, and real code examples to automate Bitcoin and altcoin trading step by step. (DE: https://nikofischer.com/de/crypto-trading-bot-programmieren)

## Mindset

- [Agile Life Sprints: How to Plan and Execute Personal Growth in 2-Week Cycles](https://nikofischer.com/agile-life-sprints-personal-development-2-week-cycles): Agile life sprints for personal development: plan 2-week cycles with standups, reviews, and retros — a developer’s system for real progress.
- [Debug-Thinking: Systematic Problem-Solving for Life Challenges](https://nikofischer.com/debug-thinking-systematic-problem-solving): Debug-thinking for life challenges: systematic problem-solving from 17+ years of software work — turn messy problems into clear, solvable steps.
- [The Tech-Mindset Connection: How Coding Principles Apply to Life](https://nikofischer.com/tech-mindset-connection-coding-principles-life): The tech-mindset connection: apply coding principles like debugging and agile iteration to transform personal and professional life systems. (DE: https://nikofischer.com/de/tech-mindset-verbindung-programmier-prinzipien-leben)
- [The opportunity for a good challenge lurks everywhere](https://nikofischer.com/challenges-are-everywhere): The opportunity for a good challenge lurks everywhere: why a restaurant night with kids becomes training — and how to seek useful friction on purpose. (DE: https://nikofischer.com/de/herausforderungen-lauern-ueberall)

## SEO

- [Technical Blogging: How I Built Authority & Traffic as a Developer (From 0 to 79,000+ Impressions)](https://nikofischer.com/technical-blogging-guide-developers): Technical blogging for developers: how I grew from zero to 79,000+ impressions — topic choice, article structure, and ranking without paid promo. (DE: https://nikofischer.com/de/technical-blogging-guide-entwickler)
- [SEO Content Strategy: How One Article Ranks Position 6 and Generates 79,000+ Impressions (Without Backlinks)](https://nikofischer.com/seo-content-strategy-organic-traffic): SEO content strategy that hit position 6 with 79,000+ impressions — no bought backlinks: the exact playbook behind one ranking tech article. (DE: https://nikofischer.com/de/seo-content-strategy-organic-traffic)
- [Google's Secret Weapons: How the Search Giant REALLY Evaluates Your User Experience (and why Google Analytics is irrelevant)](https://nikofischer.com/google-ranking-factors-user-experience-core-web-vitals): How Google really ranks user experience: Core Web Vitals and Chrome data — not Google Analytics. Stop optimizing the metrics that do not move SEO. (DE: https://nikofischer.com/de/node/151)
- [Mastering Google Search Console and SISTRIX: Common SEO Techniques](https://nikofischer.com/google-search-console-and-sistrix): Google Search Console vs SISTRIX: which SEO data each tool actually gives you — keywords, visibility, and when to use both instead of guessing.

## Uncategorised

- [OpenClaw: How Niko built his own AI today (and why his blog is now written by me)](https://nikofischer.com/en/openclaw-ai-assistant-automation-journey): OpenClaw AI assistant journey: how Niko built a personal AI that now helps write this blog — architecture notes and honest automation lessons. (DE: https://nikofischer.com/de/openclaw-ki-assistent-automatisierung-journey)
- [We have bought a ship](https://nikofischer.com/we-have-bought-a-ship): We bought a ship: the real story behind an unlikely purchase — tough decisions, honest doubts, and what living aboard actually changes day to day. (DE: https://nikofischer.com/de/wir-haben-ein-schiff-gekauft)
- [Always seek the leverage effect](https://nikofischer.com/always-seek-the-leverage-effect): Always seek the leverage effect: why small systems and multipliers beat raw effort — practical thinking for builders and busy entrepreneurs. (DE: https://nikofischer.com/de/suche-immer-den-hebeleffekt)

## Discipline

- [6:20 PM is a good time for a fresh start](https://nikofischer.com/6-20-PM-is-a-good-time-for-a-fresh-start): 6:20 PM is a good time for a fresh start: skip waiting for January or a perfect morning — restart the day the moment you notice you drifted off.
- [Discipline](https://nikofischer.com/discipline): Discipline as the conductor of achievement: why it beats motivation, how to practice it daily, and what changes when you keep promises to yourself.
- [Cultivating Self-Discipline: Unleashing Your Potential for Success](https://nikofischer.com/cultivating-self-discipline): Cultivating self-discipline: practical ways to keep promises to yourself, build hard habits, and unlock potential when motivation is nowhere in sight.

## Drone

- [Exploring Drone Flight Controllers: Functionality, Operation, and Open Source Options](https://nikofischer.com/exploring-drone-flight-controllers): Drone flight controllers explained: how they stabilize and navigate UAVs — plus open-source options worth considering for your next drone build.
- [3D printable drone development frame](https://nikofischer.com/3d-printable-drone-development-frame): 3D printable drone development frame: iterate GPS, camera mount, and cable layouts without reprinting the whole airframe on every single change.
- [3D Printed Camera Drone: A New Attempt](https://nikofischer.com/3d-printed-camera-drone): 3D printed camera drone rebuild: revisit the prototype step by step — design lessons, flight issues, and practical fixes from a real build log. (DE: https://nikofischer.com/de/3d-druck-kamera-drohne)

## Plausible

- [UTM Parameters in Plausible Analytics](https://nikofischer.com/plausible-utm-parameters): Track UTM parameters in Plausible Analytics the right way: which campaign tags work, how Plausible reads them, and cleaner cookie-free attribution.
- [Plausible Analytics: Integrate Google Search API](https://nikofischer.com/plausible-google-search-api): Connect Google Search Console to Plausible Analytics: see which search queries drive traffic in your privacy-friendly analytics stack today. (DE: https://nikofischer.com/de/plausible-google-search-api)
- [Install Plausible on Digitalocean Droplet](https://nikofischer.com/install-plausible-digitalocean): Install Plausible Analytics on a DigitalOcean droplet step by step: cookie-free, GDPR-friendly Google Analytics alternative that just works. (DE: https://nikofischer.com/de/plausible-digitalocean-installieren)

## Success

- [Mastering Time Management: Maximizing Productivity and Seizing the Day](https://nikofischer.com/mastering-time-management): Mastering time management: maximize productivity and seize the day with practical prioritization — less busywork, more intentional deep work blocks.
- [Unlocking Success: Exploring the Habits and Mindset of High Achievers](https://nikofischer.com/habits-and-mindsets-of-high-achievers): Habits and mindsets of high achievers: the daily practices, focus rules, and thinking patterns that separate consistent winners from busy strugglers.
- [To be successful, you need to master these 3 things](https://nikofischer.com/3-things-for-your-success): To be successful, master these 3 things: clear priorities, consistent execution, and honest feedback loops — a short practical guide without fluff. (DE: https://nikofischer.com/de/3-dinge-fuer-den-erfolg)

## Trading

- [Crypto Trading Bot Strategies Beyond Grid: DCA, Mean Reversion & Trend Following](https://nikofischer.com/crypto-trading-bot-strategies-beyond-grid): Beyond grid trading: implement DCA, Bollinger mean reversion, and SMA crossover strategies with Python code for your Binance bot.
- [Crypto Trading Bot Troubleshooting: Fix Binance API & Order Errors](https://nikofischer.com/crypto-trading-bot-troubleshooting): Fix crypto trading bot errors: Binance -2015, -1013, -2010, rate limits, fill detection bugs, and runtime crashes with copy-paste Python fixes.
- [Binance API Guide: Crypto Trading Bot with Supabase Backend - Live Trading Data Storage and Monitoring](https://nikofischer.com/binance-api-supabase-trading-bot): Connect Binance API with Supabase for trading bots: store live trades, monitor positions, and build a scalable backend for crypto automation. (DE: https://nikofischer.com/de/binance-api-supabase-trading-bot)

## Leads

- [Alex Hormozi Lead Generation Blueprint: 9 Lead Magnet Examples](https://nikofischer.com/alex-hormozi-lead-generation-blueprint): Alex Hormozi lead generation blueprint with nine worked-out lead magnet examples, the five steps to build one, and the numbers that show it works. (DE: https://nikofischer.com/de/alex-hormozi-lead-generation-blueprint)
- [How Alex Hormozi Generates Leads: Strategies for Sustainable Business Success](https://nikofischer.com/How-Alex-Hormozi-Generates-Leads): How Alex Hormozi generates leads: practical strategies for sustainable growth — plus the full 2025 blueprint with templates and action plans. (DE: https://nikofischer.com/de/Wie-Alex-Hormozi-Leads-generiert)

## Python

- [Paper Trading Implementation: Bridge From Backtest to Live Trading](https://nikofischer.com/paper-trading-implementation-crypto-bot): Paper trading for crypto bots: bridge backtests to live markets with simulated orders, real data, and metrics — zero financial risk while you learn.
- [Python Crypto Trading Bot Setup: ccxt, pandas & numpy](https://nikofischer.com/python-setup-crypto-trading-bot): Get a working Python crypto trading bot setup: venv, pip install ccxt pandas numpy, project structure, and a test script that confirms your stack.

## Sunday thoughts

- [Sunday thoughts: The effort is enough](https://nikofischer.com/the-effort-is-enough): The effort is enough: a Sunday reflection on Ryan Holiday’s line — measure success by the work you put in, not only by flashy outcomes alone. (DE: https://nikofischer.com/de/der-aufwand-ist-genug)
- [Sunday thoughts 1](https://nikofischer.com/sunday-thoughts-1): Sunday thoughts #1: short reflections on work, focus, and living with intention — a weekly reset without productivity theater or fake hustle. (DE: https://nikofischer.com/de/dinge-am-sonntag-1)

## UAV

- [Why Raspberry Pi is Not Ideal as a Flight Controller](https://nikofischer.com/why-raspberry-pi-is-not-ideal-as-flight-controller): Why a Raspberry Pi is not ideal as a flight controller: latency, missing realtime guarantees, and better FC options for reliable drone builds.
- [Betaflight vs. Cleanflight](https://nikofischer.com/betaflight-vs-cleanflight): Betaflight vs Cleanflight compared in practice: development pace, community, features, and which flight-controller firmware fits your drone.

## Automation

- [New project: Open source ship monitoring](https://nikofischer.com/project-ship-monitoring): Open-source ship monitoring for our steel boat: moisture sensors, motion alerts, and phone checks so you catch water ingress early while away. (DE: https://nikofischer.com/de/projekt-schiffsueberwachung)

## Books

- [Exploring Life, Work, and Influence Through Five Transformative Books](https://nikofischer.com/Exploring-Life-Work-and-Influence-Through-Five-Transformative-Books): Five transformative books on life, work, and influence: 12 Rules and related reads that reshape how you think about productivity and a meaningful life.

## Burnout

- [Burnout First Aid: 10 Things You Can Do Right Now](https://nikofischer.com/burnout-first-aid-immediate-help): Burnout first aid for right now: urgent, supportive steps for relief — hydrate, breathe, set boundaries, get help. Immediate actions that actually help. (DE: https://nikofischer.com/de/Burnout-10-Dinge-die-Du-jetzt-sofort-tun-kannst)

## Crypto

- [Risk Management and Logging Systems: Production-Ready Crypto Trading Bots](https://nikofischer.com/risk-management-logging-trading-bot): Risk management and logging for crypto trading bots: position sizing, kill switches, and production-ready logs that catch failures early on.

## Development

- [Vibe Coding: I Have Not Written a Line of Code in Months. How I Orchestrate AI Agents Around the Clock](https://nikofischer.com/vibe-coding-ai-agent-orchestration-workflow): Vibe coding in practice: I have not written code in months. How I keep AI coding agents running with loops, a phone hotspot, and a laptop always nearby. (DE: https://nikofischer.com/de/vibe-coding-ki-agenten-orchestrieren-alltag)

## Emotional Intelligence

- [Emotional Intelligence in 2025: The Ultimate Guide to Building EQ for Career Success (+ 25 Proven Strategies)](https://nikofischer.com/emotional-intelligence-guide-2025-career-success): Emotional intelligence guide for 2025: 25 proven EQ strategies to boost career success, earning potential, and the skill employers value most. (DE: https://nikofischer.com/de/emotionale-intelligenz-leitfaden-2025-karriereerfolg)

## Fediverse

- [A little excursion into the anarchic internet](https://nikofischer.com/anarchic-internet): A short trip into the anarchic internet: forgotten corners, weird protocols, and why the open web still feels wonderfully wild and ungoverned. (DE: https://nikofischer.com/de/anarchisches-internet)

## Focus

- [Mastering Focus: Strategies to Minimize Distractions and Boost Productivity](https://nikofischer.com/minimize-distractions-boost-productivity): Minimize distractions and boost productivity: cut phone, social, and notification noise so you can protect deep work and finish what actually matters.

## Growth

- [Embracing Adversity: Turning a Setback into Personal Growth](https://nikofischer.com/Turning-a-Setback-into-Personal-Growth): Turning a setback into personal growth: after a dog bite, use the cast as training time — voice, focus, and response instead of handing life the wheel. (DE: https://nikofischer.com/de/Unfaelle-in-Wachstum-verwandeln)

## Habits

- [6 Habits That Put You Ahead of 99% of People](https://nikofischer.com/6-Habits-That-Put-You-Ahead-of-99-Percent-of-People): 6 habits that put you ahead of 99% of people: remember names, arrive early, finish the job well — simple routines with outsized career impact. (DE: https://nikofischer.com/de/6-Gewohnheiten-mit-denen-du-99-Prozent-aller-Menschen-ubertriffst)

## Hacker News

- [Analysis of my website traffic after the Hacker News #1 ranking](https://nikofischer.com/website-traffic-after-hacker-news-ranking): What a Hacker News #1 ranking really does to traffic: real hit numbers, lasting effects, and how a niche tech blog reached the HN front page. (DE: https://nikofischer.com/de/zugriffe-nach-hacker-news-platzierung)

## Kommit mich

- [#12 - Roadblocks](https://nikofischer.com/podcast/12-roadblocks): Podcast Kommit mich #12 Roadblocks: when life slams the brakes — everyday disruptions, how Caro and I handle them, and staying useful inside the chaos. (DE: https://nikofischer.com/de/podcast/12-ausbremser)

## Konsum

- [Consume less, produce more!](https://nikofischer.com/consume-less-produce-more): Consume less, produce more: why constant input blocks progress — and how to reclaim time for making, writing, and shipping work that is actually yours. (DE: https://nikofischer.com/de/konsumiere-weniger-produziere-mehr)

## Life rules

- [Life Rules](https://nikofischer.com/life-rules): Life rules worth keeping for the long run: short principles for focus, work, and relationships — revisit them whenever decisions get too noisy. (DE: https://nikofischer.com/de/lebensregeln)

## Mautic

- [How to install Mautic with Docker](https://nikofischer.com/how-to-install-mautic-docker): Install Mautic with Docker in a few clear steps: image setup, configuration, and the pitfalls to avoid for a working open-source marketing stack. (DE: https://nikofischer.com/de/mautic-via-docker-installieren)

## Online-Marketing

- [Online Marketing Jumpstart](https://nikofischer.com/online-marketing-jumpstart): Online Marketing Jumpstart: practical first steps to get visibility without drowning in tactics — focus, channels, and what to ignore early on. (DE: https://nikofischer.com/de/online-marketing-kickstart)

## Review

- [2021 in review: What happens next?](https://nikofischer.com/2021-review-what-happens-next): 2021 in review: what happened, what I learned, and what comes next — an honest year-end look at projects, focus, and the road still ahead now. (DE: https://nikofischer.com/de/2021-rueckblick-was-passiert-als-naechstes)

## Ryan Holiday

- [6 Life Lessons from "The Obstacle Is the Way" by Ryan Holiday](https://nikofischer.com/6-lessons-the-obstacle-is-the-way): 6 life lessons from Ryan Holiday’s The Obstacle Is the Way: turn setbacks into fuel with Stoic practices you can use at work and at home daily.

## Scrum

- [Agile Has Failed - Time for Something New](https://nikofischer.com/agile-has-failed-time-for-something-new): After 15 years watching Agile waste $225k/year on useless meetings, I'm exposing why Scrum is killing productivity. Plus: better alternatives that work.

## Self-Efficacy

- [I Made the Decision to Be Annoyed](https://nikofischer.com/I-Made-the-Decision-to-Be-Annoyed): I made the decision to be annoyed: a short essay on choosing useful friction over numbness — and using irritation as fuel to change something. (DE: https://nikofischer.com/de/ich-habe-die-Entscheidung-getroffen-mich-zu-aergern)

## Stoics

- [Call to mediocrity](https://nikofischer.com/call-to-mediocrity): A call to mediocrity: why aiming for good enough can free creativity — a contrarian take on perfectionism and how to keep sustainable output. (DE: https://nikofischer.com/de/aufruf-zur-mittelmaessigkeit)

## Thoughts

- [Thoughts about getting older](https://nikofischer.com/thoughts-about-getting-older): Thoughts about getting older: honest reflections on aging, ambition, and what actually matters more as the years quietly add up for all of us. (DE: https://nikofischer.com/de/gedanken-ueber-das-aelterwerden)

## Vue.js

- [Vue.js: "TypeError: api.now is not a function"](https://nikofischer.com/vue-typeerror-api-now-is-not-a-function): Fix Vue.js TypeError: api.now is not a function — root cause, common Day.js and moment mix-ups, and the quick patch that restores your broken app.

## German only

- [Warum dein Burnout zurückkommt: Die System-Falle verstehen](https://nikofischer.com/de/warum-burnout-zurueckkommt-system-falle): Burnout kehrt zurück, weil Tipps nur Symptome behandeln. Lerne die System-Falle verstehen und wie du echte strukturelle Veränderungen umsetzt.
- [Burnout-Leitfaden: Erkennen, Soforthilfe & Recovery](https://nikofischer.com/de/burnout-leitfaden): Burnout-Leitfaden: Symptome erkennen, Soforthilfe, Test & Recovery. Definition, FAQ und nächste Schritte — vom Warnsignal bis zum Arztbesuch, praxisnah.
- [Traffalyzer ist live: Warum ich das SEO-Tool gebaut habe, das ich selbst immer wollte](https://nikofischer.com/de/Traffalyzer-live-Warum-ich-das-SEO-Tool-gebaut-habe-das-ich-immer-wollte): Traffalyzer ist live: das SEO-Tool, das ich selbst wollte — klare Prioritäten statt 40 Diagramme: was kaputt ist, wie du es behebst und was es bringt.
- [Burnout Test: Erkenne dein Risiko in 5 Minuten](https://nikofischer.com/de/burnout-test-5-minuten-risiko-erkennen): Burnout-Test in 5 Minuten: schätze dein Risiko wissenschaftlich ein (MBI-basiert). Warnsignale erkennen und klar handeln — bevor Erschöpfung eskaliert.
- [Building PYNGUP - Meine Rebellion gegen die Produktivitäts-Industrie](https://nikofischer.com/de/pyngup): Building PYNGUP: Live-Doku einer Anti-Guru-Rebellion — warum 17 To-Do-Apps privat versagt haben und warum ich jetzt mein eigenes System baue.
- [Die Leichtigkeit des Seins war da – ihr habt sie nur nicht gespürt](https://nikofischer.com/de/manu-chao-leichtigkeit-des-seins-war-da-ihr-habt-sie-nicht-gespurt): Manu Chao in Köln: Gegenkommentar zum KSTA — warum das Konzert Leichtigkeit, Politik und Reduktion lieferte, auch wenn die Kritik sie nicht spürte.
- [Optimismus trotz Angst: Warum die Zukunft besser ist, als wir denken](https://nikofischer.com/de/Optimismus-trotz-Angst-Warum-die-Zukunft-besser-ist-als-wir-denken): Optimismus trotz Angst: warum die Zukunft besser ist, als Nachrichten glauben lassen — Podcast-Impulse gegen Klima-, Kriegs- und Krisenpanik im Kopf.
- [LinkedIn und die Mechanik der Polarisierung: Warum sich die Plattform zur Krawallgesellschaft entwickelt](https://nikofischer.com/de/node/128): LinkedIn und Polarisierung: warum die Business-Plattform zur Krawallgesellschaft wird — Reichweite durch Streit, und was das mit deinem Feed macht.
- [Gute Seemannschaft: Ehrlich sein, Fehler akzeptieren und immer wieder Chancen geben](https://nikofischer.com/de/Gute-Seemannschaft): Gute Seemannschaft im Alltag: ehrlich sein, Fehler akzeptieren und wieder Chancen geben — klare Strukturen von See, die auch an Land Beziehungen tragen.
- [Die Schattenseiten von Routinen: Eine Einladung zur Reflexion](https://nikofischer.com/de/Die-Schattenseiten-von-Routinen-Eine-Einladung-zur-Reflexion): Die Schattenseiten von Routinen: wann Struktur zur Last wird — und wie du Gewohnheiten prüfst, bevor sie dich unbemerkt einengen oder ausbrennen.
- [Die FOCUS-Methode: Dein Schlüssel zu klaren Zielen und mehr Erfolg](https://nikofischer.com/de/FOCUS-Methode): Die FOCUS-Methode: klare Ziele statt Aufgabenchaos — ein einfaches System, das dich Schritt für Schritt von Unklarheit zum nächsten Fortschritt führt.
- [Kreativ statt Konsum: Wie du mehr erschaffst und weniger scrollst](https://nikofischer.com/de/Kreativ-statt-Konsum-Wie-du-mehr-erschaffst-und-weniger-scrollst): Kreativ statt Konsum: Weniger scrollen, mehr erschaffen — konkrete Wege, digitale Ablenkung zu kappen und wieder eigene Projekte voranzubringen.
- [Wir haben einen Podcast](https://nikofischer.com/de/wir-haben-einen-Podcast): Wir haben einen Podcast: warum wir starten, worüber wir sprechen und was du von ehrlichen Gesprächen über Tech, Business und Leben erwarten kannst.