AI

Unlock WhatsApp Data with Local Analytics Dashboard

Most people think of WhatsApp as “just messaging.”

But after years of conversations, support threads, customer discussions, team coordination, and random life moments… it quietly becomes one of the richest personal datasets you own.

So I built wacrawl-ui — a local analytics dashboard for WhatsApp archives generated by wacrawl.

The idea is simple:

  • Your data stays local
  • No cloud sync
  • No browser extension
  • No scraping APIs
  • No “AI magic” uploading your chats somewhere

Just a fast local dashboard on top of SQLite.

What’s inside:

  • Full-text search (FTS5) – It’s working quite fast. Even on ~100k messages.
  • Messaging activity analytics
  • Contact insights
  • Media browsing
  • Response-time patterns
  • Word clouds
  • Group activity stats
  • Read-only local API
  • React + Vite frontend
  • Express backend
  • Zero external dependencies once running – You only need to make sure you run ‘wacrawl sync‘ before.

A few things I found interesting while building it:

  1. SQLite is still absurdly powerful
    People underestimate what you can do locally with FTS indexes and good schema design.
  2. “Local-first” UX matters more than ever
    We’ve normalized uploading deeply personal data to random SaaS products. We should challenge that assumption.
  3. Personal analytics is an untapped category
    Not surveillance. Not ad targeting.
    Tools that help you understand your own data.
  4. Read-only architectures reduce risk dramatically
    The app intentionally avoids mutation flows. That constraint simplified security and reliability decisions across the stack.

The whole thing runs with one line:

npx wacrawl-dashboard@latest

No complicated setup.

Still early, but I think there’s a broader shift happening toward:

  • local AI – Ollama for the win.
  • local analytics – secure, private and handy.
  • local search – that works fast.
  • user-owned datasets – It’s not for everyone, but it’s useful.

Well, that future feels healthier.

Feel free to check the repo: github.com/greenido/wacrawl-ui and contribute.

Be strong.

Standard
Modern office building with digital graphic illustrating secure data, verified access, and network integrity
AI, Business

Bridging the Cybersecurity Gap for SMBs

I recently joined the MSP 1337 podcast with Chris Johnson to talk about something I’ve been thinking about for years:

Small and midsize businesses are being asked to operate with enterprise-level security expectations — without enterprise-level resources.

That gap is becoming impossible to ignore.
And AI is accelerating both sides of the problem.

Attackers are moving faster.
Infrastructure is becoming noisier.
Compliance requirements are multiplying.
Meanwhile, SMBs and MSPs are still expected to somehow manage everything with limited staff, fragmented tools, and endless alerts.

That model is cracking.

Btw, you can listen to it here:
Apple Podcasts
– Spotify

Continue reading
Standard
Home office devices protected by a glowing digital shield blocking cyber attacks
AI, Business

Ransomware Risks: Why SMBs Need AI Security Now

Last week I was staring at my EnduraCoach dashboard, watching it yell at me for sneaking in an extra sprint session that my body wasn’t ready for. The AI caught the overtraining pattern across heart-rate, sleep, and power data and shut it down before I wrecked my Ironman build. That same evening the April ransomware numbers landed. SMBs got hammered again. And I thought: if only every founder had an always-on coach like this for their security stack.

Here’s the uncomfortable truth from April 2026: ransomware didn’t slow down—it accelerated. A new player called JanaWare quietly encrypted files for hundreds of Turkish home users and small businesses through targeted phishing campaigns. Low-dollar demands ($200–$400) but high volume. Attackers are learning that SMBs are softer targets and faster payers.

The broader picture is uglier.
Verizon’s 2025 DBIR (still the gold standard) showed 88% of ransomware breaches hit SMBs versus just 39% for enterprises. Unpatched vulnerabilities caused 29% of incidents; stolen credentials another 30%.
Sophos and Black Kite reports confirm SMBs in the $4M–$8M revenue band are now the sweet spot for attackers.

Most of us simply don’t have a 24/7 SOC or the headcount to patch, triage, and remediate at machine speed.

Continue reading
Standard
AI

Understanding MCP vs Agent Skills: Key Differences Explained

There’s a lot of confusion right now between MCP (Model Context Protocol) and “Agent Skills.” They’re often mentioned in the same breath, but they solve different problems. If you treat them as interchangeable, you’ll either over-engineer simple workflows or underpower serious integrations.

Here’s the clean way to think about it.

The Core Difference

MCP is about connecting agents to systems.
Skills are about teaching agents how to do things.

That distinction alone gets you 80% of the way.

Integration Model

MCP is a client-server protocol. You stand up an MCP server, expose tools, and now multiple agents can talk to multiple backends through a consistent interface. It’s a hub.

Skills are much simpler: a folder with a SKILL.md file. The agent loads it when triggered and follows the instructions. No protocol, no network layer, no abstraction.

Implication:

  • MCP scales across teams and services
  • Skills scale across use cases and workflows
Continue reading
Standard
Tall tower made of stacked coins with cracks and falling coins, city buildings and dark storm clouds in the background
Business

Key Lessons from Sorkin’s ‘1929: The Wall Street Crash’

Andrew Ross Sorkin’s book “1929: Inside the Greatest Crash in Wall Street History—and How It Shattered a Nation” (published in 2025) provides a forensic, narrative-driven account of the most famous market collapse in history.
Sorkin, who also wrote the 2008 crisis definitive history Too Big to Fail, focuses on the human psychology, hubris, and technical failures that turned a speculative boom into a generational disaster.

Here are the top 20 takeaways from the book, followed by specific lessons for you as a long-term investor.

1. Euphoria is the market’s most dangerous condition
Pessimism had gone out of fashion by the 1920s. Government commissions, governors, and economists all declared boom-and-bust cycles relics of a vanished age — it was a fatal illusion. When everyone agrees the good times will last forever, that’s when risk is highest.

Continue reading
Standard
Business

Effortless Techmeme Summaries to Slack and Telegram

Every morning starts the same way: open Techmeme, scan headlines, open too many tabs, and somehow end up 20 minutes deep into something you didn’t mean to read.

That loop is the problem. Instead of trying to “summarize the internet” or build another bloated AI dashboard, this project does something much simpler: take a strong source, rank and summarize it, and deliver a clean digest to Slack or Telegram.

That’s it—and that’s why it works.

Continue reading
Standard
Tangled cables with floating social media app icons above an e-waste recycling bin
webdev

How to Clean Up Homebrew (brew) and Maximize macOS Storage

At some point, every dev hits it.
You’re installing something routine—npm install, a Go build, whatever—and macOS throws it in your face:

Disk Full.

You check storage, expecting the usual suspects. Not your videos. Not even Docker (okay, maybe a little).
It’s Homebrew quietly eating your SSD in the background.

Left unchecked, Homebrew turns into a museum of bad decisions:

  • tools you needed once, 14 months ago
  • duplicate runtimes “just in case”
  • dependencies of dependencies of dependencies

Let’s fix it—without nuking your setup.

Continue reading
Standard
Sport

Train Smarter for Your Ironman with EnduraCoach — The AI Companion That Actually Delivers

A few months ago, I finished a long ride—just over 100 miles, solid climbing, felt strong the entire way. The kind of session that makes you think, I’m on track.

The next week, I pushed again. Then again.

Nothing dramatic—just a bit more volume, a bit more intensity. Exactly what most self-coached athletes do when things feel good.

Two weeks later, I was flat. Not injured. Not sick. Just… off. Power was down, runs felt heavy, motivation dipped. The frustrating kind of fatigue where nothing is clearly wrong—but nothing is clearly right either.

When I looked back, the pattern was obvious:

  • I had increased load too quickly
  • Skipped a proper recovery week
  • Let “feeling good” override structure

What’s worse: all the data was there.
Garmin had it.
The workouts were logged.
The signals existed.

I just didn’t have a system that could connect the dots, enforce discipline, and still adapt intelligently.

That’s the gap.

Most tools today fall into two extremes:

  • Static plans that ignore what you actually did
  • “AI coaching” that sounds smart but you can’t really trust

I wanted something in between:

A system that keeps me honest on the fundamentals—while still helping me think, adapt, and improve.

That’s where EnduraCoach started.

Continue reading
Standard
AI, Business

Why SMBs Struggle with Cybersecurity: The Real Challenges

I recently had a conversation on The Changelog, and it reinforced something I’ve seen over and over again:

SMB cybersecurity isn’t just hard — it’s structurally broken.

Not because people don’t care.
Not because tools don’t exist.
Because the entire model assumes resources that SMBs simply don’t have.

The uncomfortable truth

Security today is designed for enterprises and downsized for everyone else.
That doesn’t work.
Enterprise model:

  • Dedicated security teams
  • Time to triage alerts
  • Budget to stack tools

SMB reality:

  • One DevOps person wearing five hats
  • Compliance pressure (SOC 2, ISO 27001, CMMC…)
  • A pile of tools that don’t talk to each other

So what happens?

They install more tools…generate more alerts…and end up less certain about their security posture.
That’s the paradox.

Continue reading
Standard
Animated coffee cup with a spoon glowing magical shield against dark fiery monsters
AI, Business

SMB Cybersecurity Is Broken — Here’s What We’re Doing About It

SMB cybersecurity is a mess. Yes – It’s 2026 and it’s broken. Big time.

Too many tools.
Too many dashboards.
Too many alerts that nobody has time—or context—to act on.

And the result?
A false sense of security.

You can have RMM, MDM, EDR, SIEM, compliance tools… and still be exposed. Not because the tools are bad—but because the system is unworkable for the people actually running it.

Most small and mid-sized businesses don’t have a SOC.
They don’t have a dedicated security team.
They don’t have time to interpret 300 alerts a day.

What they have is:

  • An overstretched IT person (or MSP or the owner that is busy with 127 other things that are all urgent)
  • A growing attack surface
  • And a stack of tools that don’t talk to each other

That’s the real gap.

A Quick Look

We recently shared a glimpse of what we’re building here:

Continue reading
Standard